Monthly Archives: January 2011

Reindex on Mirrored Databases

Posted by yrushka on January 25, 2011 None comments

The basic Index Rebuild or DBCC Reindex has a different impact on mirrored databases and can cause you more problems than you think.

Before starting the maintenance on Indexes check if:

  • Mirroring is set to high – safety or high – performance.
  • Space available on both servers (Principal/Mirror) for Log Files disk.
  • Space available on both servers (Principal/Mirror) for Data Files disk.
  • Space available
Continue reading

Check Restore Backup Shrink execution time & estimated time

Posted by yrushka on January 25, 2011 None comments

Have you ever wondered how to estimate the time for a restore, backup or even check how much time will take your shrink operation?These days I was thrilled to find out that starting with SQL 2005 there are some dynamic views that can be queried for this info:

Here you go:

Start your Restore/Backup or Shrink operation from SQL Query or directly from SSMS Interface.

You must… Continue reading