Re: Absolutely Bizarre - Backup reference database that doesn't exist
From: smithy (smithy.16316y_at_mail.mcse.ms)
Date: 05/11/04
- Next message: jjlm: "sqlmaint.exe failed. [SQLSTATE 42000] (Error 22029). The step failed."
- Previous message: Tibor Karaszi: "Re: Backup"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 11 May 2004 02:16:48 -0500
In Enterprise Manager, expand to Management > SQL Server Agent > Jobs,
and look for your job that is backing up to your tape drive (you may
also try under Management > Database Maintenance Plans).
Have a look in the Steps tab of this jobs Properties, and there should
be a Step referring to model4IDR.ckp.
Alternatively, if your maintenance plan gets its instructions from a
text file, find that text file and search it for references to your
erroneous database.
I have the same error right now, but it's for databases that do exist.
It turns out that when we had a crash the other week, the CD ROM was
removed from my server, resulting in my secondary HDD moving from F:\
to E:\. Obviously the files for some of my existing databases cannot be
found. It just shows that this error message usually means exactly what
it says.
If you cannot find the file it is looking for, I suggest creating a
text file of the same name and location (it couldn't hurt!!), and let
it find that.
Lastly, that DB name looks TOO MUCH like the model db that all SQL
Servers have, so exercise CAUTION. Cheers.
-- smithy ------------------------------------------------------------------------ Posted via http://www.mcse.ms ------------------------------------------------------------------------ View this thread: http://www.mcse.ms/message599918.html
- Next message: jjlm: "sqlmaint.exe failed. [SQLSTATE 42000] (Error 22029). The step failed."
- Previous message: Tibor Karaszi: "Re: Backup"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
