Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Old Forums
 CLOSED - General SQL Server
 My Question

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2003-10-31 : 07:48:46
Jayram writes "I am trying to attach the mdf file,which has been taken from VSS,after changing read only status I tried attaching to SQL server2000.But not getting done giving error like Error:5173 Canot associate files with different databases.Can anybody shed some light."

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2003-10-31 : 11:35:01
Was the MSSQLSERVER service stopped when the MDF file was checked into VSS? If not, then the MDF file is probably bad.

I don't recognize the error, but which command are you running to use the MDF file? Hopefully, you are using sp_attach_single_file_db. If not, then try that one in case the MDF file is useable.

Tara
Go to Top of Page
   

- Advertisement -