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=’
‘ />-1073548784) Executing the query "BACKUP DATABASE [SofTrack2] TO DISK = N’D:\Backup\SQL\UserDB\SofTrack2\SofTrack2_backup_200611161215.bak’ WITH NOFORMAT, NOINIT, NAME = N’SofTrack2_backup_20061116121502′, SKIP, REWIND, NOUNLOAD, STATS = 10<br />" failed with the following error: "The backup of the file or filegroup "sysft_ft" is not permitted because it is not online. BACKUP can be performed by using the FILEGROUP or FILE clauses to restrict the selection to include only online data.<br />The backup of the file or filegroup "sysft_ft1" is not permitted because it is not online. BACKUP can be performed by using the FILEGROUP or FILE clauses to restrict the selection to include only online data.<br />BACKUP DATABASE is terminating abnormally.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.<br /><br />Sachin<br />
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.
]]>