Steps to take the database backup
Open SQL Server Management Studio. It will ask for server
credentials. Enter the server name, username, password and click on connect
button.
After the successful connection you can find all the
databases in the server.
Select the required database and right click on that, select
Tasks --> Backup option.
Click on remove button and then click on Add button to enter
the filename for the backup and the path where it has to be saved. Select the
path where it has to be saved and mention the filename with “.bak” extension.
Click on Ok button.
Click on Ok button twice and the backup of the selected
database starts. Once the backup is finished the message will be displayed –
The backup of database ‘IOCDocs’ completed successfully.
No comments:
Post a Comment