Win IT Chapter 2: SQL Server:

Chapter 2: SQL Server

Find out how to successfully back up and recover SQL Server data with this collection of tips and expert advice. Our three categories include Basics, Restore Procedures, and Maintenance and Troubleshooting, with tips on selecting a SQL Server backup model, steps to faster backups, and optimizing backup performance.


Browse SubCategories:

Maintenance and Troubleshooting:

1 - 3 of 17
  • Restoring a database with only the .mfd file

    (presented by SearchSQLServer.com)

    Ask the Expert -  Do you want to learn how to restore a database with only the .mfd file? Expert Greg Robidoux tells you how.

  • Use caution when backing up or restoring a single table

    (presented by SearchSQLServer.com)

    Tip -  It is possible to back up and restore a single SQL Server table -- but certain precautions must be taken or data integrity may be compromised. Learn the best way to handle a single-table restore in this tip by contributor Serdar Yegulalp.

  • Automate SQL Server restores to refresh test environments

    (presented by SearchSQLServer.com)

    Tip -  Creating an automated task to restore your database as needed enables you to easily refresh a development or test environment. Edgewood Solutions' Greg Robidoux offers a list of steps and a sample script to help you automate restores in this tip.

VIEW ALL IN THIS CATEGORY

Restore Procedures:

1 - 3 of 11
  • 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.

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

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

VIEW ALL IN THIS CATEGORY