Backup Database syntax question, retain 5 days before overwriting
Posted on 2007-11-26
What is the proper syntax for creating a backup job that will keep the last 5 days before overwriting the file in SQL2000? I believe I need to add the expiredate and noskip arguments but not sure of the proper way to do this. Below is my current scheduled job backup statement.
BACKUP DATABASE [fms_prod] TO DISK = N'D:\MSSQL\DATA\MSSQL\BACKUP\fms_prod.BAK' WITH INIT, DIFFERENTIAL , NAME = N'fms_prod', STATS = 5, NOFORMAT