:::: MENU ::::

how to restore SQL Server backup through SQL Server management Studio(SSMS)

  • Feb 12 / 2009
  • 0
Backup and Restore, dbDigger, SSMS tips and tricks

how to restore SQL Server backup through SQL Server management Studio(SSMS)

Microsoft has introduced SQL Server Management Studio (SSMS) with SQL Server 2005 release. It is now a favorite tool of SQL Server DBAs. Most of new DBAs and students that are new to SQL Server feel a bit confusion to adopt various facilities for tasks provided in SSMS. I have sketched a step by step configuration for some basic tasks through SSMS.
In this post we will see how to restore SQL Server backup through SQL Server management Studio(SSMS). Follow these steps in your SSMS

Restore SQL Server Database-1

Restore SQL Server Database-2

 

Restore SQL Server Database-3

 

Restore SQL Server Database-4

 

Restore SQL Server Database-5

 

Restore SQL Server Database-6

 

If database already exists then set the option to overwrite it. Make sure that the path you are providing for files in valid path.

 

Restore SQL Server Database-7

 

Click Ok to start restore operation.

Consult us to explore the Databases. Contact us