Backup Strategy for SQL Server
Having a plan for how you manage your database backups is like having an insurance policy to cover your company’s data assets: With a good database backup policy, your data will always be recoverable with minimal data loss. Every DBA must consider what kind of backup requirements are necessary for each database, so an adequate backup solution can be deployed to meet the backup requirements. This article will discuss different database backup techniques that can be used to help minimize the data loss due to unforeseen database corruption, crash, and/or hardware failure.
Restoring Your Database Safely
SQL Server provides you with numerous ways to back up your database, but the best backup solution won't help you if you don't know how to restore your backups. In this 10-Minute Solution, SQL Server Pro Joe Lax walks you through the RESTORE command and demonstrate its various options.
SQL Server Database Backup Performance with Quest (Imceda) LiteSpeed for SQL Server
For the last several weeks, I have been working with Imceda (now Quest Software) on improving the performance of LiteSpeed for SQL Server, particularly for high-end storage systems. This report represents my assessment of LiteSpeed performance characteristics. I am an independent consultant, so this report does not represent the views or claims of Quest. All of the tests were conducted using publicly available tools, and can be reproduced with reasonable accuracy.
Using SQL-DMO To Backup and Verify a Database
This article expands upon those concepts by showing you how to use SQL-DMO to create an Active Server Page application to backup and verify a SQL Server database.
