Win IT Restore Procedures:

Chapter 2: SQL Server

Restore Procedures

Display in sets of:
  • Restoring an existing database on the same server

    (presented by SearchSQLServer.com)

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

  • Restoring from previous SQL Server versions

    (presented by SearchSQLServer.com)

    Tip -  Restoring your SQL Server 7.0 or 2000 machine to 2005 may be fairly straightforward. Restoring an earlier version is another story entirely. Edgewood Solutions' Greg Robidoux explains how to restore an older database to a new SQL Server 2005.

  • Restore basics: How to restore using T-SQL commands

    (presented by SearchSQLServer.com)

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

  • Restore basics: How to restore SQL Server using Enterprise Manager

    (presented by SearchSQLServer.com)

    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.

  • How to restore from a transaction log in SQL Server

    (presented by SearchSQLServer.com)

    Tip -  A successful SQL Server restore often involves retrieving data from transaction log backups, which means restoring multiple files rather than one large full backup. Edgewood Solutions' Greg Robidoux walks you through the process of backing up and...

  • What's the best approach for restoring MSDB on another server?

    (presented by SearchSQLServer.com)

    Ask the Expert -  Expert Greg Robidoux explains how to restore MSDB on another server while also allowing users access.

  • Can I restore a SQL Server 7.0 backup in SQL Server 2005?

    (presented by SearchSQLServer.com)

    Ask the Expert -  Adam Machanic explains if SQL Server 2005 supports backup and restore from previous versions

  • How to back up and restore Analysis Services databases

    (presented by SearchSQLServer.com)

    Tip -  Backing up a Microsoft Analysis Services (MSAS) database looks easier than it is. Contributor Baya Pavliashvili explains how to back up and restore MSAS 2000 databases and identifies enhancements in MSAS 2005.

  • How to store database backup media

    (presented by SearchSQLServer.com)

    Tip -  As a DBA, you may not personally be responsible for long-term storage of backup files, but you must always be ready to replace data quickly in the event of a SQL Server failure. Edgewood Solutions' Greg Robidoux offers some important best practices for...

  • SQL Server database backup and restore in different servers using DTS

    (presented by SearchSQLServer.com)

    Ask the Expert -  SQL Server database backup and restore in a different server using DTS is explained by expert Greg Robidoux.