SQL Server Aggregator

Recovery of database 'dbname' (10) is 17% complete (approximately 31602 seconds remain). Phase 3 of 3. This is an informational message only. No user action is required.

Though the message specifies as an informational message only and no user action is required, you should take some action to avoid current behaviour of databases within your environment. Also check whether you have enabled the AUTO_CLOSE property for Read More...

Posted Wednesday, September 05, 2007 6:13 PM from SSQA.net | (Comments Off)

Filed under: SQL Server, performance, databases, error log, recovery, suspect, message, sqlagent

Disaster Recovery - planning FAQ

Whether you're still in the planning stages, or you're trying to refine your organization's disaster recovery processes, this recently updated FAQ guide has information that can help. DR-Q&A Read More...

Posted Wednesday, September 05, 2007 2:45 AM from SSQA.net | (Comments Off)

Filed under: SQL Server, Backup, recovery, disaster

Data Protection and Disaster Recovery Tips

How to protect and secure data in the event of a disaster? It's not possible to anticipate every possible disaster your organization may encounter, but you don't have to. Discover a wealth of information about how to protect and secure your data in the Read More...

Posted Tuesday, August 28, 2007 8:54 PM from SSQA.net | (Comments Off)

Filed under: SQL Server, server, recovery, high availability, tips, disaster

Changing database recovery models: FULL to BULK-LOGGED and vice-versa

Since SQL Server version 2000 better enhancement of three types of recovery models: simple, full and bulk-logged are fetching long-run support for all kinds of database activies. As you know such recovery models offer varying levels of recovery for restoring Read More...

Posted Tuesday, August 14, 2007 7:38 PM from SSQA.net | (Comments Off)

Filed under: SQL Server, database, transaction log, full, recovery, bulk-logged, recovery model