Newbie Maint. Plan Error troubleshooting

  • My DB Maint plan returns this on a Transaction Log backup

    Backup can not be performed on database 'WCRSync'. This sub task is ignored.

    What does this error mean, and how can I trouble shoot it?

    My integraty checks fail with

    Database state cannot be changed while other users are using the database 'WCRSync'

    Repair statement not processed. Database needs to be in single user mode.

    I have a system backup that fails on MASTER and MSDB with the single user mode also.

    Since there are applications using this, is there a way to force them out, or some other way around this error?

  • Are you set to repair the dbs? If so, remove this.

    check the maintenance plan logs as well and post anything you find.

    Steve Jones

    sjones@sqlservercentral.com

    http://www.sqlservercentral.com/columnists/sjones

  • The Backup can not be performed, is the only line in the LOG, there is one succesful one in front and behind it, but just this line on this one and one other DB.

    This is the whole portion of the integraty check log:

    [1] Database master: Check Data and Index Linkage...

    [Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 7919: [Microsoft][ODBC SQL Server Driver][SQL Server]Repair statement not processed. Database needs to be in single user mode.

    The following errors were found:

    [Microsoft][ODBC SQL Server Driver][SQL Server]Repair statement not processed. Database needs to be in single user mode.

    ** Execution Time: 0 hrs, 0 mins, 1 secs **

  • Hi,

    I think that there is some consistency error in Master & MSDB dbs . To perform these check u can execute DBCC CHECKDB , DBCC CHECKALLOC , DBCC CHECKCATALOG commands. Maybe these commands can solve the problem and then u can backup those dbs.

    SaNaZ

  • OK, I ran the DBCC CHECKDB , DBCC CHECKALLOC , DBCC CHECKCATALOG but no errors were returned. I think this error is because there is a 24X7 application attached to one of the databases. The maint plan has fix any errors, so the help for these DBCC commands says the DB needs to be in single user mode (I didn't know that until you gave me those commands). It can't go into single user mode because the database is in use. So it would appear I could take the fix any errors off the job, or figure a way around putting the DB in single user mode. I don't know if it is any help but this seems to be what it is executing: EXECUTE master.dbo.xp_sqlmaint N'-PlanID EF28F67E-BCA2-11D4-B17B-00508BEE21A3 -Rpt "d:\sqldata\LOG\Proposal Maintenance Plan2.txt" -DelTxtRpt 7DAYS -WriteHistory -CkDBRepair ' on DB Master

    I still would like to know what that first error means however (see original post).

  • Thanks, that explains that. Now what about my issue with the transaction log backup?

    Anyone? see first post.

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply