Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
microsql
Starting Member
9 Posts |
 Posted - 2007-06-06 : 05:08:47
|
| I've created a backup job which overwrites my previous backup from the week before. However my job is failing with the following message:The number of retained days or expiration specified for the backup media has not passed yet.Expiration date: 2036-10-13 01:47:51I'm not sure why this message is occuring and how to fix it. I use the INIT and SKIP options within my backup script. Does anyone have any ideas how to resolve this. |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2007-06-06 : 05:40:48
|
| You have an expiration date on the backup.Do you set it in the backup? If not loko at the media retention value in sp_configure.It's a lot easier to backup to files with the datetime in the fielname and run a separate process to delete old files.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
microsql
Starting Member
9 Posts |
Posted - 2007-06-06 : 07:08:39
|
| I use the same script to backup other databases and there is no problem with the other databases. It is just this one database which gets run on a certain day (Monday). It is always failing with this message. How can i check the backup retention and what i set. I haven;t intentionally set anything. The media_retention value is 0. |
|
|
|
microsql
Starting Member
9 Posts |
Posted - 2007-06-06 : 07:24:55
|
| also..as i have the SKIP option set surely it should ignore the expiration date if there was any. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-06-06 : 10:21:57
|
| Possible to post your script? Do you backup to disk or tape? |
|
|
|
microsql
Starting Member
9 Posts |
Posted - 2007-06-07 : 07:50:35
|
| Backup database pubs to disk = 'C:\Pubs.bak'with name = 'Database Backup - Monday', description = 'Database Backup on Monday', init, skip, stats = 10To Disk. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-06-08 : 01:22:02
|
| Don't need skip. |
|
|
|
|
|
|
Backups Failing