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 |
|
thanhtung2003
Starting Member
15 Posts |
 Posted - 2004-02-23 : 20:50:12
|
| Hi all,I have a database on a computer so data file and transaction log on the same, i want to change the path and file name of the data file and transaction log file on the other computer on network, please show me how to do it??Best regard,Hi all, |
|
|
rihardh
Constraint Violating Yak Guru
307 Posts |
Posted - 2004-02-24 : 02:31:32
|
| Hmmm... not sure if I understand what you mean!? |
 |
|
|
thanhtung2003
Starting Member
15 Posts |
Posted - 2004-02-24 : 03:33:38
|
| I mean my database, datafile, log file on the local computer, and now i wnat to change the path of data file and log file on the other computer on network.best regard,Hi all, |
|
|
|
rihardh
Constraint Violating Yak Guru
307 Posts |
Posted - 2004-02-24 : 04:21:44
|
| If I got that correctly is that you moved (copied) the .mdf and .ldf files to a remote computer but the instance of the server is on the local machine (or something like this)!? Now you want the local instance of the SQL server to connect to the files on the remote machine?Why would you want to do something like this?(My appologies if I got it wrong again.) |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-02-24 : 04:38:31
|
| To change the path, use sp_detach_db to release the files from SQL Server, then copy your files to the new location, then run sp_attach_db using the new location.Tara |
|
|
|
thanhtung2003
Starting Member
15 Posts |
Posted - 2004-02-24 : 20:54:40
|
| I did that but there is an error message 'File '\\192.168.89.25\BackupSQL\A_Data.mdf' is on a network device not supported for database files.' .I do not how to do, please show me.Best regardHi all, |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2004-02-24 : 22:06:20
|
| You cannot put data or log files on UNC paths. They must be kept on the server's local hard drives. |
|
|
|
thanhtung2003
Starting Member
15 Posts |
Posted - 2004-02-24 : 22:47:17
|
| thanks,Hi all, |
|
|
|
|
|
|
|
|
change the path and file name of the data file and