Top 10 SQL Server backup and recovery tips

#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.

#2 – Restore basics: How to restore SQL Server using Enterprise Manager
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.

#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

Digg This!     StumbleUpon     Del.icio.us

RELATED CONTENT SQL Server Backup and Recovery The keys to database backup protection for SQL Server Choosing a SQL Server disaster recovery solution Licensing a standby server for SQL Server replication Can I encrypt and restore a database backup in SQL Server 2005? SQL Server errors, failures and other problems fixed from the trenches Get SQL Server log shipping functionality without Enterprise Edition SQL Server 2008 backup compression pros and cons SQL Server backups using SAN database snapshots Tips for scheduling and testing SQL Server backups Code to restore SQL Server databases in VB.NET SQL Server Backup and Recovery Research Microsoft SQL Server Performance Monitoring and Tuning Performance implications of transaction log autogrowth in SQL Server The short course on how SQL Server really works Determining the source of full transaction logs in SQL Server Improving SQL Server full-text search performance New GROUP BY option provides better data control in SQL Server 2008 Microsoft SQL Server 2008 Resource Governor primer Examining data files when SQL Server tempdb is full Testing transaction log autogrowth behavior in SQL Server Meeting business needs with SQL Server full-text search Using dynamic management views to improve SQL Server index effectiveness SQL Server Replication Top load balancing methods for SQL Server New replication features in SQL Server 2008 and what they mean to you SQL Server database replication tutorial Licensing a standby server for SQL Server replication Upgrade live applications to SQL Server 2005 for high availability Tool to synchronize two SQL Server databases Simplify SQL Server replication Replication techniques in SQL Server Podcast: SQL Server high availability options Managing identity columns with replication in SQL Server

RELATED GLOSSARY TERMS Terms from Whatis.com − the technology online dictionary rollback  (SearchSQLServer.com)

RELATED RESOURCES 2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems Search Bitpipe.com for the latest white papers and business webcasts Whatis.com, the online computer dictionary

restores.

#6 – Selecting a SQL Server recovery model
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.

#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.