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 |
|
rajeevsarawat
Starting Member
2 Posts |
 Posted - 2009-01-10 : 06:22:10
|
| how can we send database created in sql server 2005 from one computer to another computer(using backup and restore or by another method)and how? please send me step wise. |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2009-01-10 : 10:29:51
|
http://www.linglom.com/2008/01/12/how-to-backup-and-restore-database-on-microsoft-sql-server-2005/
No, you're never too old to Yak'n'Roll if you're too young to die. |
 |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-01-10 : 10:32:01
|
| Like webfred has shown, you need to copy bak file to other server after full backup. |
|
|
|
darkdusky
Aged Yak Warrior
591 Posts |
Posted - 2009-01-12 : 04:34:50
|
| If this is not just a one-off job there are script options to automate this process. Or are you happy doing it manually? |
|
|
|
lionofdezert
Aged Yak Warrior
885 Posts |
Posted - 2009-01-12 : 05:49:54
|
| Three valid methods to move database :1.detach/attach (fastest)2.Backup/restore (reliable, specially when you want to keep database online while shifting)3.Copy Database using SMO (slowest)you can also create script and manually shift database. |
|
|
|
|
|
|
sending database to another computer