December 11, 2002 at 2:23 pm
I am using backup devices for backup and it was working fine untill yesterday. I got this message:
The medium on device 'E:\Data\..\MasterBackup' expires on Dec 13 2002 3:00:00:000AM and cannot be overwritten. [SQLSTATE 42000] (Error 4030) BACKUP DATABASE is terminating abnormally. [SQLSTATE 42000] (Error 3013). The step failed.
I searched for this information on BOL, but there is nothing available for the expiration period of backup devices.
I also tried to do it the other way by just providing where the database should be backed to and the error I got after ysterday was:
The medium on device 'xyz' expires on Dec 11 2002 12:00:06:000AM and cannot be overwritten. [SQLSTATE 42000] (Error 4030) BACKUP DATABASE is terminating abnormally. [SQLSTATE 42000] (Error 3013). The step failed.
This is urgent...
Please help me out...
Thanks Much.
December 11, 2002 at 2:30 pm
You can a database backup you can specify how long to retain it by using the RETAINDAYS clause on the BACKUP DATABASE clause.
Basically you are getting this error because you are trying to overwrite a database backup where you told the BACKUP DATABASE command to retain the backup beyond the current date.
Read up on the RETAINDAYS clause in books online for more details.
Gregory Larsen, DBA
If you looking for SQL Server Examples check out my website at http://www.geocities.com/sqlserverexamples
Gregory A. Larsen, MVP
December 11, 2002 at 3:03 pm
From BOL
quote:
Important If EXPIREDATE or RETAINDAYS is not specified, expiration is determined by the media retention configuration setting of sp_configure. These options only prevent SQL Server from overwriting a file. Tapes can be erased using other methods, and disk files can be deleted through the operating system. For more information about expiration verification, see SKIP and FORMAT in this topic.
Run sp_configure 'media retention' to see what the running value is.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply