Restore SQL database

Restore SQL database Using SQL Server Management Studio

in my previous tutorial we talk about MS SQL database backup steps and verify the backup and now I will walk through database restore steps

Connect to the appropriate instance of the Microsoft SQL Server Database Engine, in Object Explorer, click the server name to expand the server tree.

Right-click the database, then click Restore Database.
In the Restore Database window select “From device” as a source for restore, if you are restoring from .bak file and click the button to search for .bak file
Click “Add” then locate the Database file .bak and click “OK”
Select the restore options and restore folder for the database and log files
In the Destination to restore, fill “To database” field from the list box select the database name to. You can optionally type a new name then click OK to start restore the database
Windows below will appear after the database restored successfully
For Additional information

Restore a Database Backup Using SSMS

RESTORE (Transact-SQL)


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s