Home   |  Affiliate  |  Contact  |  Links
SQL Server  Backup software questions

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


download sql server backup

download sql server backupback up sql server 2005 express

View Screenshot

Walkthrough

Copyright @2008 by Databk.com, all rights reserved.