Post reply

Optimization job on Read-only database fails

  • December 6, 2005 at 9:25 pm

    #90166

    Hi all,

    I have a question. Can we run optimization job for db maintenacne on Read -only databases. I get the following error (This is scheduled maint job)

    The job failed.  Unable to determine if the owner (XX_A\sQL_useer) of job Optimizations Job for DB Maintenance Plan 'Acc' has server access (reason: Could not obtain information about Windows NT group/user 'XX_A\sQL_useer'. [SQLSTATE 42000] (Error 8198)).

     

    Any help/suggestions


    Helen
    --------------------------------
    Are you a born again. He is Jehova Jirah unto me

  • December 7, 2005 at 9:23 am

    #608203

    I don't think you can. Read only means that no transactions are allowed to the database, either user transactions or maintanence transactions like reorgnize data pages, defrag index etc.

     

     

  • December 8, 2005 at 4:18 am

    #608365

    to do any of this type of work you'll need to take the database into read/write. Use the alter database command either side of your optimisation job.

    [font="Comic Sans MS"]The GrumpyOldDBA[/font]
    www.grumpyolddba.co.uk
    http://sqlblogcasts.com/blogs/grumpyolddba/

  • December 8, 2005 at 8:13 pm

    #608573

    Hi,

    Big thanks to both of you.

     


    Helen
    --------------------------------
    Are you a born again. He is Jehova Jirah unto me

Viewing 4 posts - 1 through 3 (of 3 total)

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