How to Backup a DataBase
SQL: How to Backup a DataBase using SQL
Description
The Sql Server is vast and very power full server where we can build a number of databases and other objects. These databses can be backed up and saved for future use.
Steps:
To backup the database in sql there are steps as following :
- Connect the SQL Server.
- Right click on the DataBases and expand it.
- After expanding you will get to see the DataBase which you want to backup.
- Right click on the DataBase eg: TestDB
- You will see the option : Tasks after right clicking, click on it: futher it will show you Backup option.
- Click on the Backup option and it will show you the Screen.
- Provide the Destination folder where you want to save the Backup.
- click on OK button.
- Now you have the Backup of your DataBase.
0comments
Post a Comment