Database Backup:
It is important to backup the database, so we can recover our data and up and running again.In case of any problem occurs such as system crash, hardware failure. Backups take for disaster recovery purpose.
Here we take on the SQL server Database Backup for sample systems.
MS SQL database maintenance is easy and powerful tool for Microsoft community.
Here you can find the MS SQL database backup step by step with full screenshot.
Step 1: Open the SQL Server management console studio in your server.
Step 2: Right click the required SID under Database console.
Then click the tasks button.
Step 3: Goto Backup tab for choosing the backup option.
It is important to backup the database, so we can recover our data and up and running again.In case of any problem occurs such as system crash, hardware failure. Backups take for disaster recovery purpose.
Here we take on the SQL server Database Backup for sample systems.
MS SQL database maintenance is easy and powerful tool for Microsoft community.
Here you can find the MS SQL database backup step by step with full screenshot.
Step 1: Open the SQL Server management console studio in your server.
Then click the tasks button.
Step4: Choose the backup type what you want and destination directory to store the data in that directory.
Finally add the Required path to store the data and choose enter to take the backup.
Step5: After some hours backup will be completed deepens upon the database size. then popup window will appear for completing the backup of the whole database.
That's all done it for the backup completed successfully.
No comments:
Post a Comment