Jordan_WM
asked on
Attach a database SQL from network drive??
I have a database that mdf, ldf files that are not on the local machine but on a network drive such as X. When I try to attach the databases to the server I am only seeing the local drives C and D.
Is it possible to attach a database from another network drive or does it have to reside locally?
Is it possible to attach a database from another network drive or does it have to reside locally?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Take a look at this article by Brent Ozar.
ASKER
Thanks for the post that was exactly what I am looking for, I needed to move the DB because I am limited to size where the instance of SQL server is running.
Sorry forgot to post the article...
http://www.brentozar.com/archive/2012/01/sql-server-databases-on-network-shares-nas/
http://www.brentozar.com/archive/2012/01/sql-server-databases-on-network-shares-nas/
Warning! You should do that only for emergency or short-term operation! At least the transaction log should always be local, the data files might then be located on a network share - again, never in a production env!
The reason is that network I/O is unreliable, and doesn't allow for the necessary force-write commands to make write operations safe.
The reason is that network I/O is unreliable, and doesn't allow for the necessary force-write commands to make write operations safe.