Post reply

Backup and Restore with Restrict Access Option

  • November 12, 2004 at 7:49 am

    #162704

    I have been backing up and restoring test databases without restricting users access to the databases. Now I want to backup production databases and restore them to a new server and want to make sure no users are allowed to access the databases during this process. If I use the Restrict Access Database Option would this cause any problems with the Backup and Restore Process? I would like to restrict access to a "Single User" (verses "Members of db_owner, dbcreator, or sysadmin"). I think the "Single User" Option would be stricter. Is this true? (We are on SQL Server 2000, SP3.)

    Thanks in advance, Kevin

     

  • November 15, 2004 at 7:32 am

    #530101

    Since single-user means only one connection can exist, yes it is very restrictive. You should be able to restore using single-user mode without any problem.

    -SQLBill

Viewing 2 posts - 1 through 1 (of 1 total)

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