June 27, 2008 at 10:51 am
Hi, we have run out of hard drive space on the server where we house our sql database. I have copied the databases onto a new server and would like to point the database location to the folder on a different server than where my instance of sql is running. Is this possible and if so how can I do it?
June 27, 2008 at 10:55 am
ALTER DATABASE (DBNAME)
MODIFY FILE (NAME='LOGICAL FILE NAME', FILENAME ='NEW FILE PATH')
Maninder
www.dbanation.com
June 27, 2008 at 11:01 am
This can be done, but is HIGHLY not recommended ... I've done it myself in the past and ran into lots of issues.
In order to attach a remote database file, you have to enable trace flag 1807.
June 27, 2008 at 11:14 am
Hi thanks for your help, if I repoint the location of my databases should I leave the master db on the server that sql is running on?
June 27, 2008 at 11:16 am
Marcus Farrugia (6/27/2008)
Hi thanks for your help, if I repoint the location of my databases should I leave the master db on the server that sql is running on?
If you take this route, most DEFINITELY leave your system databases on the source server ... I had many a issues with databases going corrupt when running them from a network location.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply