The process was taking more than 6 hours to complete.With no IO/CPU activity, i decided to stop the operation as it seemed to hang.Before you change the current setting, it pays to understand exactly what it means and the implications of any change.Each database has a collection of individual properties, many of which can have a significant effect on a database’s behavior, performance and availability.The procedure used to recover a damaged master database is different from the procedure used to recover user databases.
Knowing this can be very helpful when troubleshooting many SQL Server related problems.
The purpose of performing a Database Properties Health Check is to determine what your database’s properties are currently set to for each of your SQL Server instances, and to determine if the settings are appropriate for your particular environment.
The recommendations made in the article are general in nature and may or may not apply to your particular server’s environment.
Another tracking and capturing solution introduced in SQL Server 2008 Enterprise, that tracks any Insert, Update or Delete operation applied to the user tables , with What , When and Where these changes applied, without any extra coding effort and keep it in system tables that can be easily accessed using normal queries.
This new feature is called SQL Server Change Data Capture, or CDC.