Try using below script. Also you would need to change query option --> remove include column header in resultset from query output.

/**************************************************************************************************/
/***        Build Restore Scripts...

This script would require small modifications. I have modified the script so tht it would display restore script properly in output window. Also we would need to remove query option...

In SQL Server, DBCC commands use internal read-only database snapshots. These database snapshots are created on the same drive where the corresponding database data files are located. Database snapshots grow...

By mistake i mentioned mirror database. The steps mentioned would be executed on principle server on principle database. In case of T-log drive running out of disk space you've to...

Yes database which is residing on principle server. You've to take T-log backup multiple time to enable database for shrinking T-log file.

You can follow below steps

1. Run below script against db in mirroring on principle server.

DECLARE @DatabaseName VARCHAR(50);

SET @DatabaseName = 'Mirrored DB Name' --> Replace the mirror...

Hi,

It is recommended to grant the SQL service account the OS privilege "Lock pages in memory". By doing this you are preventing the OS from swapping SQL's memory pages to...