Date: Oct 09
Product & Version: NetVault All
OS Version: All
Module & Version: SQL Server Plugin All
Application version:
Symptoms:
Restoring SQL Server Database to a different location fails with Multi-User Mode enabled. The errors within the Binary Log are:
Error 2009/10/21 07:07:33 7531 Data Plugin me400srd010 ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]To restore the master database, the server must be running in single-user mode. For information on starting in single-user mode, see "How to: Start an Instance of SQL Server (sqlservr.exe)" in Books Online.
With subtext:
ODBC Error Number:42000, MsgState=1, Severity=16, Servername=ME400SRD010, ProcName=, LineNumber=1, Message:[Microsoft][ODBC SQL Server Driver][SQL Server]To restore the master database, the server must be running in single-user mode. For information on starting in single-user mode, see "How to: Start an Instance of SQL Server (sqlservr.exe)" in Books Online.
Multi-User Mode is not supported, therefore the SQL Server needs to be set as Single-User Mode before restoring the SQL Master Database.
More information can be found from section 5.1.3.a of the SQL Server User Guide:
http://www.bakbone.com/support/product_documentation/default.asp
SFDC solution number:
English version available ID 5309
Version française disponible ID
Deutsche Version verfügbar ID
© 2025 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center