How to check Log shipping status in SQL Server 2008: SQL server recovery model has to be Full recovery mode…
A copy-only backup in SQL Server(any version like 2012 or 2008 or 2005) is taken in cases you do not…
Comparing ALTER INDEX options Index Rebuild and Reorganize: 1.Index Rebuild requires building the new index before dropping the old one.…
BACKUP LOG WITH TRUNCATE_ONLY is no longer a recognized BACKUP option. This command get rid of the contents of your…
SQL Server 2008 Recovery Models In SQL Server 2008 there are 3 recovery models you can use: simple, bulk-logged, and…
A SQL Server DBA given choice to select his Disk configuration should know the different Raid configurations and should select…
One of the important things I would recommend is not having transaction log VLFs be too large, with 500MB being…
This website uses cookies.