SQL Server restore master database
Restore master database is a must know task for any DBA. Master database is one of the key SQL Server database and should be a part of backup/maintenance plan. In case …
SQL Server restore master database Read MoreTag: restore database
SQL Server restore database with move example
A common task for a DBA is to restore a database to a new location. The script for the same is given below USE [master] GO RESTORE DATABASE [AdventureWorks] FROM DISK …
SQL Server restore database with move example Read MoreRestore SQL Server database from bak file command line
Here is a script to restore SQL Server database from bak file command line. This is done via SQLCMD through command line. The first thing is to open up the command …
Restore SQL Server database from bak file command line Read MoreSQL Server 2012 Restore Page using SSMS
Dear Friends, Every release of SQL Server shipped with full of new features so is SQL Server 2012. Some of them are Availability Groups, Contained Databases, Column Store Indexes, User Defined roles, …
SQL Server 2012 Restore Page using SSMS Read MoreSQL Server Database States – simple talk but not simpler
Dear Friends, Very recently while imparting training to junior DBAs someone from them asked me what are the different states of a database and how they can move into each stage? …
SQL Server Database States – simple talk but not simpler Read More