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 |
|
fanfan
Starting Member
3 Posts |
 Posted - 2007-01-15 : 12:36:13
|
| I'm a beginner user. I'd like to move the whole database from a work station to a server, how should I do it in a safe way? First of all, I have a very basic question: How could I save a database in SQL Server? Thanks in advance. |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2007-01-15 : 12:56:18
|
backup a database and restore it on the other server.look up backup and restore in BOL = books online = SQL server help.Go with the flow & have fun! Else fight the flow  blog thingie: http://weblogs.sqlteam.com/mladenp |
 |
|
|
madhuotp
Yak Posting Veteran
78 Posts |
Posted - 2007-01-15 : 23:25:18
|
| or you can detach database from work station and attach to the server or u can use copy database wizards etc. Madhu |
|
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2007-01-16 : 07:36:11
|
| Remember to sort out any datbase specific permissions after the move.... |
|
|
|
|
|
|
moving database from one machine to another