Results 1 to 2 of 2

Thread: Backup maintenance Plan

  1. 03-21-2002, 10:21 AM #1
    Ken Nicholson Guest

    Backup maintenance Plan


    I have a maintenance plan where I backup the system databases and my application databases every night. Once a week I do a Check Database Integrity. For the Master and MSDB databases, it errors out telling me that the database must be in single user mode. I thought that the maintenance plan would switch the DB to single user mode when it needed to perform its checks. Any suggestions on how to get this to work successfully?

    Thanks,
    Ken Nicholson

    Reply With Quote Reply With Quote
  2. 03-21-2002, 11:40 AM #2
    Jim Guest

    Backup maintenance Plan (reply)

    System databases can not be put in single user mode.


    ------------
    Ken Nicholson at 3/21/2002 10:21:23 AM


    I have a maintenance plan where I backup the system databases and my application databases every night. Once a week I do a Check Database Integrity. For the Master and MSDB databases, it errors out telling me that the database must be in single user mode. I thought that the maintenance plan would switch the DB to single user mode when it needed to perform its checks. Any suggestions on how to get this to work successfully?

    Thanks,
    Ken Nicholson

    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules