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.
SQL_08
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
SQL_09
Click “Add” then locate the Database file .bak and click “OK”
SQL_10
Select the restore options and restore folder for the database and log files
SQL_11
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
SQL_12
Windows below will appear after the database restored successfully
SQL_13
For Additional information

Restore a Database Backup Using SSMS
https://msdn.microsoft.com/en-us/library/ms177429.aspx

RESTORE (Transact-SQL)
https://msdn.microsoft.com/en-us/library/ms186858.aspx

Leave a Reply

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

WordPress.com Logo

You are commenting using your WordPress.com 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