Post reply

SQL Server 6.5 in Single User mode

  • December 12, 2007 at 8:01 am

    #182006

    Hi,

    We need to restore historical database that is in SQL Server 6.5. We installed SQL Sever 6.5 and trying to restore the database. But it gives an error saying the "Cannot load any database other than master when server is in Single-user mode".

    Can anyone let me know how to start instance of SQL Server 6.5 in multi-user mode so that the database can be restored.

    Thanks in advance.

    Regards,

    Rohit

  • December 12, 2007 at 9:37 am

    #759483

    You must have started it with the -m (or -g) parameter. Check the settings for the service. Or if someone started it from the command line with this switch, shut it down (CTRL-C) and then start the service.

  • December 12, 2007 at 11:40 pm

    #759695

    Thanks for the reply. Since I am not very much familiar with SQL 6.5. Can you give me any idea as how to convert the instance to multi-user mode.

  • January 1, 2008 at 8:59 pm

    #763902

    Check the service (control panel) to see if there is a parameter.

    Otherwise, check and see if there is a command window open. close that.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply