|
|
How to start SQL Server in single-user mode?
|
|
|
Restoring master database requires the SQL Server running in single user mode. To start SQL Server in single user mode :
- Open "Control Panel->Administrative Tools->Services"
- Mouse right click on specified SQL Server
instance service and select "Properties" menu to bring up following configuration window:

- Specify start parameters as following:
-s{ Instance name } -m
(for Named instance , -sSQL2000
-m)
or
-m
(for Default instance ,
-m)
- Restart the SQL Server instance service
|
|
|
|
Free Download |
|
|
- Microsoft SQL Server 7.0 , 2000 , 2005 , SQL Server 2005 Express , MSDE , WMSDE supports
- Supports SQL Server database full backup and differential backup, transaction log backup
- Data compression and encryption supports
- Convert DataBK backups to Microsoft SQL Server raw backups
- Restore database to point of failure
- Email notify after job


View Screenshot
Walkthrough
|
|
|
|
|
|
|