To take back up of database In SQL Server Database .
Follow the steps :
I have explained how to take back up of database using SQL Server Management Studio .
1. Fisrt Connect to the appropriate SQL Server Database Engine .
2. Expand Databases and select the databse which you want to take a back up .
8.Once back Up of database complete , One message will prompt that "The backup of database 'DatabaseName' completed successfully .
Follow the steps :
I have explained how to take back up of database using SQL Server Management Studio .
1. Fisrt Connect to the appropriate SQL Server Database Engine .
2. Expand Databases and select the databse which you want to take a back up .
3. Rigth Click On Database and Go to the Task Option and In task Option Click on the Back Up option .
4.After then One dialog box will open then Add the destination file path where you want to save the back up file .
5.Click on the add button for the destination path .
6.One Dialog Box will open then choose the destination path and give the file name with .bak extension ,Like TestBaup.bak .
7.Finally you need click on OK Button .
8.Once back Up of database complete , One message will prompt that "The backup of database 'DatabaseName' completed successfully .
No comments:
Post a Comment