Tuesday, December 5, 2006

SQL Server : Scheduled backup

SQL server 2000 has facility to schedule jobs. One of them is scheduled backup.
This can be done through database maintenance planner wizard.
We can specify how recurrent the backup will take place and how long the old backup file reside until it is overwritten.
However, I do not find a place where I can specify how the file name format would be.

No comments:

Post a Comment