Once you are started using SQL Server database for your applications, you also need to start taking database backups regularly. If it may be a development database or production database, you should take backups in a timely manner. Because if your information get loss, that brings you in loss. We cannot prevent the data loss due to disk failure, file corruption, code bugs, external factors, etc.
The best practice is to take database backup and store it in an external media like tape drive and keep it in a safe place. The easiest way to take database backup is by using SQL Server Management Studio (SSMS).
Step 1:
After open SSMS, expand database in object explorer. Right click the database and go to Tasks – Backup
Step 2:
After click Backup, Backup Database dialog will appear. Here we need to select source database from drop down box. Then it will automatically select Full as a default backup type. We can able to change the default backup set name. Then we need to select the destination to disk and then we need to add the location path & backup filename to save the backup file in that location. Usually backup file is a package of mdf, ndf & ldf and it has an extension of .bak.
Step 3:
In options, we can able to overwrite, verify & perform checksum before writing to media. We can also choose the backup compression. By default, it uses the default server settings. We can also choose compressed or normal backup options here.
Step 4:
Just click OK to start the execution of backup. SQL Server will check for a location path whether it is correct or not. Then It will check for available space in that drive is enough or not. If any of this condition fails, it will through you an error message. If it passes this, it will start the backup execution process and it completes successfully.
If you follow these 4 simple steps, then you can easily take the backup of your database. I think now you are getting prepared to secure your data by taking database backup.
Related Posts
- SQL Server 2005 database DBA Checklist for database administrator
- Split Backup Files while Backup and Restore SQL Server Database
- Backup SQL Server database using T-SQL
- Troubleshooting SSRS Error “The report server is not responding”
- How to Verify the SQL Server Backup
Tags: Database Backup, SQL Server, SQL Server 2008 Backup, SQL Server Backup, SQL Server Database Backup, SSMS
