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
 SSIS and Import/Export (2005)
 Datatching DB .mdf and .ldf files

Author  Topic 

ajsredtech
Starting Member

1 Post

Posted - 2009-07-28 : 10:14:43
Hi there,

I am attempting to detach the database and log files from one of my databases on SQL 2005 to an external storage server on the same network. After doing so i would like to be able to reattach the log and database files for that specific database when required from the storage server to the system.

I have tried mapping the network location locally on the system and have ran a script to reattch the files, but SQL does not seem to like me trying to attach files from another system.

Is it possible to detach/attach database files from a system to a storage server cross network?

If so how can i achieve this?



Thanks,
Andy

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2009-07-28 : 13:51:37
That is not possible.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

"Let's begin with the premise that everything you've done up until this point is wrong."
Go to Top of Page
   

- Advertisement -