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.
| Author |
Topic |
|
delpiero
Yak Posting Veteran
98 Posts |
 Posted - 2005-03-08 : 02:50:02
|
| Is it possible?I have tried the network drive letter (e.g. V:\) and the UNC path (e.g. \\servername\sharename\path)but it both failed with error about device activation error.Many thanks,delpiero |
|
|
Kristen
Test
22859 Posts |
Posted - 2005-03-08 : 08:42:28
|
| You can't attach a database from a network drive, can you? Try copying it to a local drive on the server, and then attaching it.Kristen |
 |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
|
|
delpiero
Yak Posting Veteran
98 Posts |
Posted - 2005-03-08 : 23:52:01
|
| Thanks for the link.However, I tried to set the trace 1807 on. But the create database and the sp_attach_db commands still failed with the same error, no matter I use mapped drive or UNC path.delpiero |
|
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2005-03-09 : 00:49:10
|
| talk about playing with fire. I would not ever try to attach a database on a network drive. This is a recipe for disaster.It might be a good idea to update your resume if you are going to proceed with this :)-ec |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2005-03-09 : 01:01:26
|
| Is there a particular reason why you cannot mount the database on a LOCAL drive on the server?Kristen |
|
|
|
delpiero
Yak Posting Veteran
98 Posts |
Posted - 2005-03-09 : 01:28:46
|
| Well, the reason is that in our testing environment we need to share the same database files among several developers ... e.g. one may detach the database and another will attach it from the network shared drive.It is not a must to do so. I am just trying out different ways to share it. Anyway, I have read through several articles and this seems not a good way. I think I will have to change my recipe.Thanks for all your help!delpiero |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2005-03-09 : 03:29:42
|
| We get around that by having a development server that all the developers have connectiveity to - and then having various databases, for a given project, on that server. So the developers can connect their application to the appropriate database - FOOBAR_DEV, FOOBAR_TEST, FOOBAR_V1, FOOBAR_V2 ... etc.Kristen |
|
|
|
|
|
|
|
|
Attaching database from network drive