RE: backup issue
From: Vikram Jayaram [MS] (vikramj_at_online.microsoft.com)
Date: 07/20/04
- Next message: Vikram Jayaram [MS]: "Re: Decrease a log file"
- Previous message: Vikram Jayaram [MS]: "RE: Remote Procedure Call Failed"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 20 Jul 2004 18:35:51 GMT
Josie,
Hello!
Looking at your problem, it appears to me that you could be looking at some
disk corruption. The best place to start would be the Event logs and see
if:-
1. You see any corruption or hardware errors
2. Did the backups actually complete successfully?
3. Is the database corrupt? (Run checkdb)
With SQL Server backups, we usually have commands such as RESTORE
VERIFYONLY and RESTORE HEADERONLY to verify the state of a backup device. A
backup can be deemed as successful only after it's been fully restored, and
a checkdb is run on it.
I'd suggest you look at the event logs, and maybe get your hardware vendors
engaged as well. Have you tried backing up the db to another drive?
Vikram Jayaram
Microsoft, SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.
- Next message: Vikram Jayaram [MS]: "Re: Decrease a log file"
- Previous message: Vikram Jayaram [MS]: "RE: Remote Procedure Call Failed"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
