Forrards Blog

Category
130 cents total
How to close all active database connections in one shot?

While trying to restore SQL Server database or do any other actions which require exclusive database access you may face with the following error:Exclusive access could not be obtained because the database is in use.

Forrards
March 31, 2023
Consequences of wrong database autogrowth settings

In this article we`re going to address the question about autogrowth settings of the database. To be more precise we`re going to talk about database files settings and their autogrowth settings. From the first glance this seems to be an easy question. But in reality it may cause serious issues in mission critical data systems and even downtime. The goal of the article is to decide whether to set the growth in percents or megabytes and what should be the size of the file growth.

Forrards
March 31, 2023
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.

Subscribe to our blog

                             

Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.
SQL Server issue: switching partitions using the parameter with enabled replication

It’s quite an unpleasant thing that we had to face once. There was a working script, which had been functioning for a long time and did not cause any problems until a need to replicate a few directories...But let’s get into the details step by step:First of all, we create the partition function and a scheme to demonstrate very unexpected behavior of SQL Serverset nocount on;

Forrards
March 30, 2023
Database migration from on-premises Microsoft SQL Server to Azure SQL managed instance via backup/restore

This guide describes the process of database migration from Microsoft SQL Server on-premises to Azure SQL managed instance.

Anna
March 30, 2023

Let's discuss your project or resource request

                       

Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.

Contact Us
To let us help you

Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.