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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2006-06-21 : 09:55:55
|
| Indra Widjaja submitted "I confuse with server sql link from one computer to other computer, I have server sql instal [in] both computer. But time I will file attach of database [in] computer of client, my network place there is no existing only computer local drive ex c: or d:, last, me try database folder maping which is have ekstension *. mdf in server later;then I attach again but remain to cannot attach. help me please...." |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2006-06-21 : 21:04:07
|
| you cannot attach a file in a client computer unless it has a local server on itif you're trying to access the sql server, install the client tools like enterprise manager and query analyzerif you're trying to copy the database files from the server to your client machine with sql server on it, take a backup of the database from the server then restore it on your local machineor you can detach the databases on the server, copy the mdf and ldf files on your client machine (do not move them), then attach the files, server and client (both have copies of the db files)HTH--------------------keeping it simple... |
 |
|
|
|
|
|
question