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)
 Simple backup

Author  Topic 

lemondash
Posting Yak Master

159 Posts

Posted - 2005-04-12 : 06:18:34
Guys really suggling with a problem here, trying to back up a database which is about 15gb big. I try it many way though enterprise moniter, query analzyer, locally on the machince, across the newtork. The server it sits on is quite highly spec and network is fine.
But the backup keeps failing on me. this is the error message.
10 percent backed up.
20 percent backed up.
30 percent backed up.
40 percent backed up.
50 percent backed up.
60 percent backed up.
70 percent backed up.
80 percent backed up.
90 percent backed up.
Processed 1842920 pages for database 'Pioneer', file 'pioneerdata' on file 1.
100 percent backed up.
Processed 1411 pages for database 'Pioneer', file 'pioneerlog' on file 1.
Server: Msg 3013, Level 16, State 1, Line 1
BACKUP DATABASE is terminating abnormally.

Hope that helps

kish
Starting Member

45 Posts

Posted - 2005-04-12 : 07:21:26
What is the OS and SQL Server veriosn you are using ? Also where are you backing your data -- on a local or a network drive ?
Go to Top of Page

lemondash
Posting Yak Master

159 Posts

Posted - 2005-04-12 : 07:40:11
Windows 2000 with service pack 4 backing up locally and over the network give me the same error message.
Go to Top of Page

jason
Posting Yak Master

164 Posts

Posted - 2005-04-12 : 11:20:13
What is the SQL version?

Have you seen this?

http://support.microsoft.com/kb/272093/EN-US/
Go to Top of Page
   

- Advertisement -