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 |
|
hummy
Starting Member
32 Posts |
 Posted - 2007-02-05 : 07:31:39
|
| We are backing up a database and getting the following error message:Server: Msg 61500, Level 19, State 1, Line 1The number of retained days or expiration specified for the backup media has not passed yet.Expiration date: 2023-12-11 03:36:09It is a message that i have never seen before and wanted to find out if anyone else has ever experienced such a message and if you can help me to resolve what the cause could be. Thanks in Advance |
|
|
Kristen
Test
22859 Posts |
Posted - 2007-02-05 : 07:47:41
|
| If you are using a SQL Command: the BACKUP DATABASE command does allow for a RETAINDAYS attribute - although I'm not sure what it does with it (I'm not aware of any automated delete that removes stale files). Worth checking if you are using RETAINDAYS in your SQL commandIf you are using a Maintenance Plan: there is a field (on the set up screens) for the number of retention days (for the backup). Maybe a huge number has got in there by mistake?Kristen |
 |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2007-02-05 : 07:51:08
|
| You are getting this error most probably because you are trying to overwrite existing backup media which is not yet expired. If you are sure you want to overwrite it, you can use SKIP option of BACKUP DATABASE statement to skip expiration check.Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2007-02-05 : 08:32:05
|
| Ah ... that sounds much more likely, Harsh. |
|
|
|
|
|
|
Database Backup Problem