Post reply

Maintenance package erors.

  • October 15, 2009 at 9:29 am

    #205639

    I have a maintenance package that is showing errors. It is happening on the DB integrity check (Step 1). The package seems to be running fine. Here is the message I get. Alter failed for Server 'gisserver'. I tried doing a DBCC CHECKDB from the query window and it seems to run fine on a couple DB's I tried it on. The backup files are there so the whole package doesn't seem to be failing. The size of the backup files seem to be consistent.

    Wht could be causing this to happen?

    Thanks.

    Quinn

  • October 15, 2009 at 9:53 am

    #1066365

    SQL 2005 or SQL 2000?

    Check the maint plan history, check the SQL error logs.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • October 16, 2009 at 8:43 am

    #1066942

    That error was in the history log. There were no erorrs in the sql log that I can find.

    Thanks

    Quinn

  • October 20, 2009 at 6:06 am

    #1068111

    please check id which sql server agent is configured for has full rights

  • October 20, 2009 at 8:00 am

    #1068213

    I am not sure how to check that. Maybe in configuration manager.

    Thanks

    Quinn

  • October 21, 2009 at 12:17 am

    #1068678

    SQL agent services may have some windows login id to start or log on you check the in SQL Agnet Service property window. Check what type what right it has on the SQL Server consult your domain admin or tell him give full right the id on the SQL Server by adding that id to local admin group of the SQL Server

  • October 26, 2009 at 10:16 am

    #1070808

    I was gone the end of last week sorry about the delay.

    I installed SQL server with the administrator user account for the server. I would think that has permissions for all.

    I will do some checking around on permissions on the administrator account.

    Thanks

    Quinn

  • October 27, 2009 at 12:19 pm

    #1071384

    I've seen this happen before. Deleting the maintenance package and re-adding it solved it for me.

  • October 27, 2009 at 1:40 pm

    #1071426

    It must be a good carma week. We haven't had any error yet this week.

    I did a restore of last nights backup to a db with a different name. Just to make sure that there are no errors in the backup. Is there a way to make sure that these two DB's are the same and my backup is working fine? Will one of the shareware db compare tools like opendbdiff show me the differences?

    Thanks for the help

    Quinn

Viewing 9 posts - 1 through 8 (of 8 total)

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