transfer SQL database to new host

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.

All Forums

General SQL Server Forums

New to SQL Server Programming

transfer SQL database to new host

Author

Topic

morrison5891
Starting Member

1 Post

Posted - 2009-01-31 : 01:35:16

Could someone please explain to me how I can take my current sql database and transfer all the data to a new host?

Thank you

bklr
Master Smack Fu Yak Hacker

1693 Posts

Posted - 2009-01-31 : 01:43:26

u can have a backup for current sql database and u can restore the this backup file in newhost database then u can get the data . i think so........

Rajesh Jonnalagadda
Starting Member

45 Posts

Posted - 2009-01-31 : 01:54:32

Use this query to take backup
BACKUP DATABASE Test_Forums TO DISK = 'D:\Test.bak'

Copy the backup file and place it in host machine
To restore use this query

RESTORE Test_Forums
FROM DISK = 'D:\Test.bak'

Rajesh Jonnalagadda
[url="http://www.ggktech.com
"]GGK TECH[/url]

Rajesh Jonnalagadda
Starting Member

45 Posts

Posted - 2009-01-31 : 01:58:02

Check these links
To take Backup :http://msdn.microsoft.com/en-us/library/ms187510.aspx
To Restore: http://msdn.microsoft.com/en-us/library/ms177429.aspx

Rajesh Jonnalagadda
[url="http://www.ggktech.com
"]GGK TECH[/url]

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2009-01-31 : 09:11:45

use Move option if drives are different in new host while restoring.

jackv
Master Smack Fu Yak Hacker

2179 Posts

Posted - 2009-02-01 : 06:52:38

Although I prefer the BACKUP\RESTORE method , if you are completely short of space , you could do a detach \ attach method

Jack Vamvas
--------------------
http://www.ITjobfeed.com

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources