- Configure Database for Single User
ALTER DATABASE mydatabase SET SINGLE_USER WITH ROLLBACK IMMEDIATE - Restore Database
- Configure for Multi User
ALTER DATABASE mydatabase SET MULTI_USER
SQL Server 2005: Database Recovery
I'm hoping this code will work when I try disaster recovery after tonight's failed deployment:
Labels:
SQL Server 2005
Subscribe to:
Posts (Atom)