Steps to connect to your SQL Server and reset the sa password with out having permissions. You can recover your sa password, or this can be used to connect to any sql server instance your ex DBAs left you with out providing you the necessary permissions or credentials. First you have to shutdown your SQL […]
Category: Microsoft SQL Server
How to start SQL Server in Single user mode
Detailed steps to start a SQL Server instance in Single User mode. Also how to connect to the single user mode sql server instance using SQLCMD. Open SQL Server Configuration manager from your start menu 2. You can see the names of the SQL Server services. In this case I need to start the 1st […]
How to move msdb database files in SQL Server
Detailed steps on how to move msdb database files (mdf and ldf) from one location to another. This change requires a restart of your SQL Server Instance, so make sure to do this during a maintenance window. First find the msdb database files location which we want to move. To do that, execute the following […]
How to move master database files in SQL Server
Detailed steps on how to move master database files (mdf and ldf) from one location to another. This change requires a restart of your SQL Server Instance, so make sure to do this during a maintenance window. Open your SQL Server Configuration Manager 2. Right click on the SQL Server Instance -> select Properties 3. […]
How to move model database files in SQL Server
Detailed steps on how to move model database files (mdf and ldf) from one location to another. This change requires a restart of your SQL Server Instance, so make sure to do this during a maintenance window. First find the model database files location which we want to move. To do that, execute the following […]
How to move tempdb database files in SQL Server
Detailed steps on how to move tempdb database files (mdf and ldf) from one location to another. Tempdb is recreated every time you restart SQL Server Instance. So all we have to do is update the new path in master database, and a restart of the sql server instance will create tempdb in the newly […]
How to move database files in SQL Server
Detailed steps on how to move database files from one location to another. We will see how to move user database files, and how to move system database files. We will see how to move both mdf and ldf files to another location. Move User Database Files First find the database files location which we […]
How to shrink a file in SQL Server
How to shrink data or log files in SQL Server. What to do if a file is not shrinking, how to find the reason for not shrinking. Connect to your SQL Server Instance Click New Query to open a query window. Now first run the below query to find the name of the data or […]
How to find SQL Server version
How to find the installed version of SQL Server. This query will give us the required version information of the SQL Server instance.
SQL Server 2014 Build Versions
Microsoft SQL Server 2014 Build Versions details and where to download information. Download the most recent or search for the required SQL Server Service Pack 2014 (SP), SQL Server Cumulative Updates (CU) or General Distribution Release (GDR). Find SQL Server Build Versions for all SQL Server products, click here SQL Server Build Versions Detailed