Go to ...

Techpository

A Better Technical Repository

RSS Feed

MSSQL: Restoring a DB


MSSQL Restoring a DB

 

Sometimes this requires setting the DB into Single User mode.
Open SQL Query Analyzer

Single User: alter database db-name set SINGLE_USER
Multi User: alter database db-name set MULTI_USER

If the database will not restore do to someone being in it.
Goto Management – Current Activity – Process Info
Sort by BD name
Highlite the user that is locking you out – Right click and Kill Process