October 23, 2007 at 3:42 am
Hello all,
I'm a newbie to all this SQL server stuff so please bare with me...
I'm backing-up a database from an MSSQL 2005 server to a NAS server. Access permissions are set as everyone full access on the NAS box and there are hundreds of gigabytes free on the drive. When I try to run a differential backup, it gets to 100% complete then fails. If I look on the NAS server, the backup file is there (and it looks about the right size). I also have the transaction logs backing up hourly to the same place with no problem. The last full backup of the same DB over the weekend failed with the same problem - the file is there but it says it failed.
Any ideas would be much appreciated.
Stu
October 23, 2007 at 7:56 am
What is the size of the backup file? The next thing is to try to restore from the backup file (on another server or to another DB on the same server), to try to see if the backup is really okay.
You only mention running Differential and Transaction log backups, are you running full backups? If so are they running okay? If not you cannot restore the database because differential and transaction log backups need a full backup as a starting point.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
October 23, 2007 at 10:35 am
I've just tried running a full backup and I get the same thing. The files appears and is about the right size but it says the backup failed. I will try and do a restore and see if it works.
October 23, 2007 at 12:12 pm
What's the exact error message you're getting?
Paul Randal
CEO, SQLskills.com: Check out SQLskills online training!
Blog:www.SQLskills.com/blogs/paul Twitter: @PaulRandal
SQL MVP, Microsoft RD, Contributing Editor of TechNet Magazine
Author of DBCC CHECKDB/repair (and other Storage Engine) code of SQL Server 2005
October 24, 2007 at 2:04 am
Here is what our error-forwarding system picks up from the event log:
EVENT #1187405
EVENT LOGApplication
EVENT TYPEError
SOURCESQLISPackage
EVENT ID12291
USERNAMENT AUTHORITY\SYSTEM
COMPUTERNAME OHG21
TIME24/10/2007 00:28:17
MESSAGEPackage "OHGPackaging Differential Backup" failed.
EVENT #1187406
EVENT LOGApplication
EVENT TYPEWarning
SOURCESQLSERVERAGENT
CATEGORYJob Engine
EVENT ID208
COMPUTERNAME OHG21
TIME24/10/2007 00:28:19
MESSAGESQL Server Scheduled Job 'OHGPackaging Differential Backup.OHGPackaging Differential Backup' (0xB196279F94068146906895F8043FAB0D) - Status: Failed - Invoked on: 2007-10-24 00:00:00 - Message: The job failed. The Job was invoked by Schedule 8 (OHGPackaging Differential Backup-Schedule). The last step to run was step 1 (OHGPackaging Differential Backup).
October 24, 2007 at 3:55 am
I've done a bit of digging and found that it's not the database backup that's failing - it's the notification it tries to send me afterwards to let me know if the backup was a success/failure that's not working and so generating the job failed message.
Thanks for everyone's help.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply