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.
#1 – Restoring
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.
#3 – SQL
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.
#4 – Backup
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.
#5 – Restore
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.
#7 – Recover lost SQL
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.
#8 – Database
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.
#10 – Restoring
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