Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations danielledunham on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Back up error

Status
Not open for further replies.

NotSQL

Technical User
Joined
May 17, 2005
Messages
205
Location
GB
Can anyone explain why the back up of this DB failed?

ERROR Message:

BACKUP failed to complete the command BACKUP DATABASE [DBNAME] TO DISK = N'G:\Folder\DBName\MAN_Data_db_200511201737.BAK' WITH INIT , NOUNLOAD , NOSKIP , STATS = 10, NOFORMAT

Regards
Dave
 
If you check your Error Log on the server it will give you a pretty good explanation of what the problem was.

1. Disk full?
2. Previous backup corrupted so INIT can't reset the file?
3. Don't have security access to G:?
4. Another job is also touching that same backup file?

As many reasons as you could think of, but the Error Log would lay it out much more clearly for you.

Enterprise Manager -> Server -> Management -> SQL Server Logs -> Current
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top