April 20, 2006 03:20 PM
Special Snapshots
Run maintenance without interfering with database users
Rating:
(0)
SQL Server Magazine
InstantDoc ID #49769
One problem associated with managing a healthy 24 × 7 database server is that so many maintenance activities can block access to the data. And the interference cuts both ways: Ongoing database modifications can prevent you from concurrently running system health reports, such as database consistency checks and fragmentation reports.
SQL...
...This article is for paid Professional Members only.
Already a Professional Member? Please log in now: