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 |
|
zhangn
Starting Member
29 Posts |
 Posted - 2010-02-22 : 16:55:34
|
| Hi all, I am newibe to SQL server 2008. Is there any chance i can copy the entire database from one server to anther sql?Is that just simply copy the database files and changing the login?Could any one suggest any useful link for me?Very appreciated!kind regards, Ning Zhang |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2010-02-22 : 17:01:27
|
It is possible to copy the database file but that needs to detach the database first so that the files are not in use.A better way is to have a backup and then restore it to the destination server.See BOL for backup and restore.
No, you're never too old to Yak'n'Roll if you're too young to die. |
 |
|
|
|
|
|
How can I copy the entire database from one pc