Top 10 SQL Server backup and recovery tips

We've tallied a Top 10 collection of backup and recovery tips for 2006. View the complete list where database restores of different shapes and sizes took the majority of slots.

#1Restoring a database from another SQL Server
Restoring a database from another SQL Server is simple -- matching up the logins and users again is not. Get the steps you need to restore one database from another in this tip.

To restore a SQL Server database you have two basic options. Edgewood Solutions' Greg Robidoux explores the first of two in this SQL Server restore series.

#3SQL Server backup and restore, part I: The basics
This in-depth tip analyzes the various options available for your backup and recovery process with SQL Server 2000.

#4Backup and recovery enhancements in SQL Server 2005
The backup and restore capabilities of SQL Server 2005 are largely unchanged from SQL Server 2000, but there are several new features worthy of your attention. Edgewood Solutions' Greg Robidoux explains the pros and cons of using these features -- from mirrored backups to online restores.

#5Restore basics: How to restore using T-SQL commands
SQL Server Enterprise Manager may be a quick and easy way to run backups and restores, but T-SQL commands offer much greater flexibility. Find out how to script your SQL Server backups or restores.

SQL Server 2000 offers three recovery models: Full Recovery, Simple Recovery and Bulk-Logged Recovery. Greg Robidoux discusses choosing the best one for your needs.

#7Recover lost SQL Server data
Data recovery success in SQL Server depends on your failover method in place. Failover options range from a simple backup and restore process to the highly sophisticated clustering model. Edgewood Solutions' Greg Robidoux outlines the available methods and guides you toward the best failover solution to fit your SQL Server environment.

#8Database mirroring setup in SQL Server 2005
SQL Server 2005 database mirroring allows you to automatically mirror database contents from one SQL Server database to another. Edgewood Solutions' Greg Robidoux explains how it works, what you need to make it work and how to get it up and running via Management Studio.

#9 Disaster recovery: What your SQL Server plan should look like
Failover and failback solutions must minimize SQL Server data loss. Develop the best disaster recovery plan to match your budget and business goals.

#10Restoring an existing database on the same server
Restoring an older version of a database to the same server is an occasional duty for DBAs. Backup and Recovery expert Greg Robidoux takes you through the process in T-SQL and Enterprise Manager.


This was first published in November 2006

There are Comments. Add yours.

TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: