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
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 Attach database file over the network.

Author  Topic 

umatur
Starting Member

1 Post

Posted - 2007-04-25 : 08:08:15
Hello,

I have Sql Server in one pc and I want to attach one databse that is in another computer that doesnt have SQL Server. Sql Server doesnt permit UNC path when attaching database files. Is there anyway to workarounf this. Is Trace Flag 1807 of any use?

Thanks

harsh_athalye
Master Smack Fu Yak Hacker

5581 Posts

Posted - 2007-04-25 : 08:21:35
Try Create Database...For Attach while setting trace flag 1807 on.

Harsh Athalye
India.
"The IMPOSSIBLE is often UNTRIED"
Go to Top of Page

mcrowley
Aged Yak Warrior

771 Posts

Posted - 2007-04-25 : 09:21:14
This setup is not supported by SQL Server, I believe. The database must be local to the machine that hosts it.
Go to Top of Page

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-04-25 : 10:21:35
Why don't copy db files over?
Go to Top of Page
   

- Advertisement -