SQL Database Backup Error - VERY STRANGE
Posted on 2005-03-05
Running MS Small Bus. Svr with SQL 2k, both with latest non-beta svc packs. Have about 8 databases. ALL show status as NORMAL.
ONE of the database will not complete a good backup - all others will.
Have tried numerous times (with Ent. Manager) to backup this database & verify the backup. I get the Backup Progress dialog but the blue PROGRESS BAR NEVER APPEARS. Dialog just sits there for about 20 seconds (which is not long enough to backup this database - it's about 2 gb), then it SAYS "Backup Completed Successfully". Then this error dialog appears:
Title bar of error dialog: "Miscrosft SQL-DMO (ODBC SQL State:42000)"
and this text in the detail box:
"Cannot open backup device (filename of my file). Device error or device off-line. See the SQL error log for more details. Verify database is terminating abnormally."
Here are the errors in the SQL error log:
"BACKUP failed to complete the command BACKUP DATABASE [GCF] TO DISK = N'D:\!Backups\SQL Backups\Manual\Databases\GCF' WITH NOINIT , NOUNLOAD , NAME = N'GCF backup', NOSKIP , STATS = 10, NOFORMAT"
"BackupDiskFile::OpenMedia: Backup device 'D:\!Backups\SQL Backups\Manual\Databases\GCF' failed to open. Operating system error = 2(The system cannot find the file specified.)."
It DOES create a file in the folder I specified, but it shows 0 kb (in Windows Explorer). I can right-click the file, choose Properties, & at first the properties window shows it has a size of 1.01 gb. I close the properties window, REFRESH the explorer window multiple times, it still shows filesize of "0k". I can go back to Explorer a minute or so later, & it NOW shows a filesize of 2.1 gb. I RClick the file & the NOW Properties window shows size now of 2.6 gb.
I went to Query Analyzer & did a manual backup (BACKUP DATABASE GCF TO DISK = 'c:\GCF.bak'), and got this result:
Processed 270672 pages for database 'GCF', file 'GPSGCFDat.mdf' on file 1.
[Microsoft][ODBC SQL Server Driver][Shared Memory]ConnectionRead (WrapperRead()).
Server: Msg 11, Level 16, State 1, Line 0
General network error. Check your network documentation.
Processed 9 pages for database 'GCF', file 'GPSGCFLog.ldf' on file 1.
I have backed this database up MANY times before with no problems at all, both manually & with Maint. Plan (which is failing now).