SQL Server Performance Forum – Threads Archive
SQL 2005 Backup Failed:(-1073548784)
hello,<br /><br />I am using sql 2005 on widnows 2003 i configured on maintenency job for taking backup for user databases. out of 7 it backup 4 and for three database it gives below error.<br /><br />SQL Version<br /><br />Microsoft SQL Server 2005 – 9.00.1399.06 (Intel X86) <br />Oct 14 2005 00:33:37 <br />Copyright (c) 1988-2005 Microsoft Corporation<br />Developer Edition on Windows NT 5.2 (Build 3790: Service Pack 1)<br /><br />Error<br /><br />Microsoft(R) Server Maintenance Utility (Unicode) Version 9.0.1399<br />Report was generated on "sachin".<br />Maintenance Plan: UserDB_BACK<br />Duration: 00:00:01<br />Status: Warning: One or more tasks failed..<br />Details:<br />Back Up Database Task (sachin)<br />Backup Database on Local server connection<br />Databases: All user databases<br />Type: Full<br />Append existing<br />Task start: 11/16/2006 12:15 PM.<br />Task end: 11/16/2006 12:15 PM.<br />Failed<img src=’/community/emoticons/emotion-6.gif’ alt=’![Frown :( :(](styles/default/xenforo/smilies/frown.png)
I tried to take backup with Quries (Manually) and it works but i trying the same with scheduller it won’t work any idea ? Sachin
Are you using any FULLTEXT catalog on thos instance? Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing.
]]>