Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 backup

Author  Topic 

lemondash
Posting Yak Master

159 Posts

Posted - 2005-04-27 : 11:00:40
Have a small issue i have few database's between 5GB and 25GB.
They all run on different servers but backup to the same file storage.
I get the small problem with all the database's
The problem i'm having is that they keep on failing.
Copying files are ok and all other running of the server's is fine.
The funny thing is that if you use the failed backup the database works perfectly.

Error message:
Executed as user: Domian\Administrator. 10 percent backed up. [SQLSTATE 01000] (Message 3211) 20 percent backed up. [SQLSTATE 01000] (Message 3211) 30 percent backed up. [SQLSTATE 01000] (Message 3211) 40 percent backed up. [SQLSTATE 01000] (Message 3211) 50 percent backed up. [SQLSTATE 01000] (Message 3211) 60 percent backed up. [SQLSTATE 01000] (Message 3211) 70 percent backed up. [SQLSTATE 01000] (Message 3211) 80 percent backed up. [SQLSTATE 01000] (Message 3211) 90 percent backed up. [SQLSTATE 01000] (Message 3211) Processed 1668872 pages for database 'Pioneer', file 'pioneerdata' on file 1. [SQLSTATE 01000] (Message 4035) 100 percent backed up. [SQLSTATE 01000] (Message 3211) Processed 11 pages for database 'Pioneer', file 'pioneerlog' on file 1. [SQLSTATE 01000] (Message 4035) BACKUP DATABASE is terminating abnormally. [SQLSTATE 42000] (Error 3013). The step failed.

Kristen
Test

22859 Posts

Posted - 2005-04-27 : 13:32:35
Are you backing up to some remote-ish filesystem, rather than a local-ish filesystem?

Kristen
Go to Top of Page
   

- Advertisement -