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
 General SQL Server Forums
 New to SQL Server Programming
 Attaching a database from a dedicated server....pr

Author  Topic 

Richy1
Starting Member

27 Posts

Posted - 2009-07-15 : 11:21:33
Hello, we are exporting some of our sites to a new dedicated server. As you can see from the pics, having a bit of trouble with our SQL database. Bascially i have copied the 2 files we need (files mdf and ldf) to the needed folder. We have installed SQL Server Management Studio Express and are using Remote Desktop Connection to transfer and connect to our new server. But as you can see......they just wont connect properly. Im a little stumped tbh - any ideas why this will not work? thx for any ideas there......

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2009-07-15 : 13:03:36
was the source sql express?
Go to Top of Page

afrika
Master Smack Fu Yak Hacker

2706 Posts

Posted - 2009-07-15 : 13:05:39
I would advice you backup and restore.

Also, is the name of the source and target db the same ?

Lastly, check the option overwrite existing db
Go to Top of Page
   

- Advertisement -