{"id":3112,"date":"2017-06-29T08:17:36","date_gmt":"2017-06-29T08:17:36","guid":{"rendered":"http:\/\/www.fastwebhost.in\/blog\/?p=3112"},"modified":"2021-06-26T05:35:32","modified_gmt":"2021-06-26T05:35:32","slug":"backup-restoration-database-sql-server-management-studio","status":"publish","type":"post","link":"https:\/\/www.fastwebhost.in\/blog\/backup-restoration-database-sql-server-management-studio\/","title":{"rendered":"Backup & Restoration of Database Using SQL Server Management Studio"},"content":{"rendered":"

Microsoft SQL Server Management Studio is a free open source graphical management tool which can be used to manage your SQL Server 2008 Edition. It is always better to backup your database, because you never know if the information is lost or the database goes corrupt.<\/p>\n

The backup file you download will need to be in .bak file extension. When you take a backup of database it will be generated on the server itself.<\/p>\n

In order to backup your MS SQL Server 2008 Database on your windows server hosting platform, follow the steps shown below:<\/p>\n

First, you need to configure the Microsoft SQL Server Management Studio on your local machine. If you don\u2019t have it, you can download the latest version from the following location.<\/p>\n

https:\/\/docs.microsoft.com\/en-us\/sql\/ssms\/download-sql-server-management-studio-ssms<\/a><\/p>\n

How to Backup Database through  SQL Server Management Studio ?<\/h2>\n

Step 1<\/span><\/h3>\n

<\/span>Open your Microsoft SQL Server Management Studio and connect by using your Database Username and Password.<\/p>\n

\"SQL<\/span><\/p>\n

Step 2<\/h3>\n

Select the database >> Right-click >> Tasks >> Back Up.<\/p>\n

\"\"<\/span><\/p>\n

Once you click on the \u201cBackup\u201d the following Backup Database window will appear as shown in the image below.<\/p>\n

\"\"<\/span><\/p>\n

Step 3<\/h3>\n<\/p>\n

Select Backup type as Full.<\/p>\n

Step 4<\/h3>\n

By clicking on the \u201cAdd\u201d button the following window will appear to select the path and file name for the database backup file.<\/p>\n

\"\"<\/span><\/p>\n

Step 5<\/h3>\n

Select the destination folder for the backup file and enter the \u201cFile name\u201d with .bak extension.<\/p>\n

\"\"<\/span><\/p>\n

Make sure you place your MS SQL database .bak file under the MSSQL backup folder.<\/p>\n

Step 6<\/h3>\n

Hit the OK button to finish the backup of your MS SQL Server 2008 Database.Upon the successful completion of database backup, the following confirmation window will appear with a message \u201cThe backup of database \u201ctest\u201d completed successfully.<\/p>\n

\"\"<\/span><\/p>\n

Following the above steps, you will be able to create a successful backup of your MS SQL Server  Database into the desired folder.<\/p>\n

How to Restore MS SQL Server Database Backup File ?<\/span><\/h2>\n

<\/span><\/p>\n

In order to restore a database from a backup file, follow the steps shown below:<\/p>\n

Step 1<\/h3>\n

Open your Microsoft SQL Server Management Studio and connect to your database.<\/p>\n

Step 2<\/h3>\n

 Select the database >> Right-click >> Tasks >> Restore >> Database.<\/p>\n

\"\"<\/span><\/p>\n

Step 3<\/h3>\n

The following \u201cRestore Database\u201c windows will appear. Select \u201cFrom device\u201d mentioned under the \u201cSource for restore\u201d and click the ellipses button in front of that to specify the file location.<\/p>\n

\"\"<\/span><\/p>\n

Step 4<\/h3>\n

Select the option \u201cBackup media as File\u201d and click on the Add button to add the backup file location.<\/p>\n

\"\"<\/span><\/p>\n

Step 5<\/h3>\n

Browse the backup file (.bak) you wish to restore and hit the OK button.<\/p>\n

\"\"<\/span><\/p>\n

Step 6<\/h3>\n

Select the restore point you want to use. Since a SQL backup file can hold multiple backups you may see more than one restore point listed.<\/p>\n

\"\"<\/span><\/p>\n

Step 7<\/h3>\n

Once your restore options are set, click Ok.<\/p>\n

\"\"<\/span><\/p>\n

Conclusion<\/h2>\n

SQL Server Management Studio makes the restore process simple and is ideal if you seldom perform database restores. This process works in every version of SQL Server from Express to Enterprise.<\/p>\n

By the end of this article you will know the procedure of backing up and restoring MS SQL Server Database.<\/p>\n

List of Articles for Plesk users<\/h3>\n

<\/span><\/p>\n