DCM : Differential Changed Map pages track the extents modified after the full backup. DCM has a bit for every extent…
Database is in suspect mode, how you recover?
Change the status of your database in “EMERGENCY” mode. (i.e. ALTER DATABASE Database Name SET EMERGENCY;) Check for any of…
Difference between re-build and reorganization with query syntax.
SQL,SQL SERVER,SQL DATABASE,Microsoft SQL Server,Database,Database Administrator While index reorganization is a pure cleanup operation which leaves system state as it…
What is the Pre-requisite of mirroring ?
The principal server and mirror server, must be running the same edition of SQL Server. The witness server (if any)…
List of Some SQL CMD Arguments with Description
-s instance_nameSpecifies the instance of SQL Server you want to connect. If no named instance is specified, sql server starts…