We have 2 different SQL Servers which both have a copy of the AdventureWorks2012 database in Full recovery mode. One of the SQL Server hosts the primary copy of the AdventureWorks2012 database which gets restored every night to the other SQL Server as a secondary copy for development use. One of the tables in the […]

When your databases grow, operations, like a database backup and restore, are going to take a longer time to complete. Maybe at some point you are running out of your time window to complete a database backup or a restore. Instead of expending your time window (if that is even an option) you can use […]

A question I hear a lot from fellow DBA’s is how they can minimize the impact of index maintenance in a log shipped environment for large databases. The problem with running index maintenance like rebuilds in VLDB’s is that they generate very large transaction log backups. If the SQL Server environment you manage uses log […]