dcsimg
Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2012
    Posts
    6

    Cannot create MS SQL Server 6.5 database from DAT file

    I have a SQL servver 6.5 DAT file from a client's computer. I need to create a new database off this DAT file. I have SQL server 6.5 installed on a server. However, when I select the DAT file to restore, I get the error "[SQL server] Cannot load any database other than master when server in "single user" mode when restoring the database. I am open to ideas.

  2. #2
    Join Date
    Sep 2002
    Posts
    5,938
    Did you start sql service in single user mode? Is it valid sql db backup file? Tried restore with t-sql command?

  3. #3
    Join Date
    Aug 2012
    Posts
    6
    Yes, I was able to create a database and do a restore. I turned off single user mode by changing the server properties and stop/restarting the server. This thread can be closed.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •