How to Restore an SQL Dump File

Shares & Saves

A Structured Query Language (SQL) dump file is a copy of your SQL Server database. These files are used as a backup in case an emergency occurs, such as a hard drive failure or a database corruption. SQL Server provides a wizard for database administrators. This wizard helps you import the SQL Server dump file to the engine, restoring the database for all of your desktop and Web applications.

  • Click the Windows "Start" button and select "All Programs." Click "SQL Server" and then click "SQL Server Management Studio." The Management Studio software is included with SQL Server as a way to manage your database.

  • Right-click the server name on the left side of Management Studio. Select "Tasks" and then click "Restore Database." This opens the wizard. The wizard provides several defaults, which are sufficient for a quick restoration of your file.

  • Enter a name for the restored SQL dump file. This can be any new name, but you typically use the same name as the database dump file to avoid confusion.

  • Click the "Add" button in the "From Device" section. Double-click the SQL dump file, which has the .BAK file extension. You can restore your file from a CD, DVD, external hard drive, network drive or the local hard drive.

  • Click the "Restore" button. The wizard retrieves the dump file and copies the database to your local hard drive and database engine. This can take several minutes to complete.



  • Photo Credit computer image by blaine stiger from

You May Also Like

Read Article

Your Black Friday/Cyber Monday Survival Guide