![Sql management studio 2008 r2 scheduled backup](https://kumkoniak.com/17.jpg)
Enter the password of the server in Password field.ģ. Microsoft Server Management Studio window with Connect to Server dialog box appears (see Image-1 ).Ģ. Go to Start –> All Programs –> Microsoft Server 2008 R2 –> SQL Server Management Studio, Click SQL Server Management Studio.
- Users can schedule the backup copies to be deleted at a particular interval.ĭo the following tasks to take a backup of a database:ġ.
- Users can schedule the backup to be taken at a particular interval.
- Microsoft SQL server 2008 has made this task very easy.
It is very important to take backups for the database files on regular basis. Scheduling automated backup using SQL server 2008: