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 |
|
Amjath
Yak Posting Veteran
66 Posts |
 Posted - 2007-07-26 : 04:55:17
|
| Hi All,Im using Sql server Express 2005, in the client place.i want to copy the database with all data and put it in my sql server express 2005 in office.so plz help me how can i do thishow can i copy entire data from sql server express and put it in another sql server expressThanks for ur valuable helpWith RegardsAmjath |
|
|
jezemine
Master Smack Fu Yak Hacker
2886 Posts |
Posted - 2007-07-26 : 09:51:18
|
why not just restore a backup on your new server?
elsasoft.org |
 |
|
|
askmanojjain
Starting Member
10 Posts |
Posted - 2007-07-26 : 13:42:09
|
| You can copy .mdf and .ldf file from your clientand attach the .mdf on your server |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-07-26 : 23:03:00
|
| Have to stop sql or take db offline to copy db file, so I prefer backup/restore. |
|
|
|
|
|
|
coping data in sql server express