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 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.
#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
Join the conversationComment
Share
Comments
Results
Contribute to the conversation