|
| Set the Database to Single user mode. This can be done
through Enterprise Manager, by right clicking on the
databse you want to restore and selecting Properties. The
click on the Options Tab. You will see an option to
Restrict access. Choose single user.
>-----Original Message-----
>Hi,
>
>I am trying to create a copy of database: DBss From the
>production server into a development server. I managed
>to successfully execute this command on the production
>box:
>DUMP DATABASE DBss to DISK='C:\SQLDUMPS\DBss_Dump.bak'
>
>Over at the development box:
>LOAD DATABASE DBss FROM
DISK='C:\SQLDUMPS\DBss_Dump.bak'
>
>I get the error "Database in use. The system
>administrator must have exclusive use of the database to
>run the restore operation."
>
>I am fairly new to SQL SERVER - any help will be
>appreciated.
>
>Thank you.
>.
>
|
|