June 25, 2002 at 9:28 am
Hi All,
I recently have problem to back up one application database on a SQL Server (2K) Cluster which has 8 other databases. This database cannot be backed up using Database Maintenance Plan or using regular backup job with a backup device. I was able to do the backup properly before. The only method I can now back this database up is manually to perform a full backup to a physical file. The db is about 17 MB.
SQL Server Logs prompted errors such as, "Internal I/O ... m_errcode:64" and "Operating System error 64 (The specified network name is no longer available)", and "write failure on backup device '...'".
Please advise!
Thank you for your help!
Yichang
June 25, 2002 at 9:44 am
Where are you backing up to? Local or remote drive?
Also can you manually run a backup in Query Analyzer?
Steve Jones
June 25, 2002 at 3:09 pm
A local drive with about 7 GB empty space.
June 25, 2002 at 3:18 pm
It sounds like a security issue. Is the server running as local system? Or a lcoal account? Is it a local administrator.
Is this truly local or a virtual drive for the cluster?
Steve Jones
June 26, 2002 at 10:07 am
The backup is back to normal.
The disk is a true local drive. I specified the server's IP address as part of the physical backup files in both backup device and maintenance plan, which caused backup failure. I removed the IP address and the backup performs normally.
My question is why the IP address does not cause problem with other database backups in the same cluster server.
Thanks!
Yichang
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply