Error during backup, please help! 
Author Message
 Error during backup, please help!

SQL Server7.0 SP2 , WNT4.0 SP6a

I-m doing backup thru EM. It starts and stops around 30% with message:

window title: Microsoft SQL-DMO (ODBC SQLState: 42000)
window content:     Write on 'backup_device' failed, status = 112. See the
SQL Server error log for more details.
                              Backup or restore operation terminating
abnormally

How can I view error log and where is it?

BTW, it's not a security problem and it's not a space problem.

Thanks,
Zarko



Mon, 29 Dec 2003 16:07:54 GMT
 Error during backup, please help!

The error log can be read using master..xp_readerrorlog.

--
Tony Rogerson SQL Server MVP
Torver Computer Consultants Ltd
www.sql-server.co.uk [UK SQL Server User Group - FAQ, SQL Tutorials etc...]


Quote:
> SQL Server7.0 SP2 , WNT4.0 SP6a

> I-m doing backup thru EM. It starts and stops around 30% with message:

> window title: Microsoft SQL-DMO (ODBC SQLState: 42000)
> window content:     Write on 'backup_device' failed, status = 112. See the
> SQL Server error log for more details.
>                               Backup or restore operation terminating
> abnormally

> How can I view error log and where is it?

> BTW, it's not a security problem and it's not a space problem.

> Thanks,
> Zarko



Mon, 29 Dec 2003 17:57:37 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. Error during process - please help?

2. TNS-12560 error during db creation - Please Help!

3. I/O error during ONUNLOAD --Please HELP !!!

4. I/O error during ONUNLOAD --Please HELP !!!

5. Error during Runtime Install on Win95B - Please Help

6. BACKUP ERROR, please help

7. Error on Backup - Help Please!

8. Transaction Log backup Error. Please help

9. operating system error during sql backup

10. Error 22029 sqlmaint.exe during backup

11. Error during backup

12. Error 3266 during disk backup


 
Powered by phpBB® Forum Software