|
|||||||||
|
|||||||||
|
|||||||||
 |
|||||||||
| |
||
|
|
|
|
|||||||||
|
|||||||||
|
|||||||||
|
|||||||||
| |
||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
ASP Free Forums Sponsor:
|
|
|
|
#1
August 22nd, 2005, 12:09 AM
|
||||
|
||||
|
database transfer
hi......
i m changing my host....for files i dont have any problem.now i want to transfer my MS-SQLSERVER database to another host machine. can anyone give any suggestion how transfer database from one host machine to other host machine. thanx
|
|
#2
August 22nd, 2005, 12:40 AM
|
|||
|
|||
|
I would use DTS. If you have access to the source and target DB's from the Internet, and if you have DTS on your computer, you can initiate and verify the db transfer yourself.
Another option is to obtain a sql server backup file, upload it to the target server, and restore it to your new database.
__________________
====== Doug G ====== I didn't attend the funeral, but I sent a nice letter saying I approved of it. --Mark Twain
|
|
#3
August 22nd, 2005, 12:55 AM
|
||||
|
||||
|
hi....doug_c....thanx for reply......i had taken backup of my database.and i uploaded to it at target server....now for purpose of restore i have to use target server.right???
|
|
#4
August 22nd, 2005, 12:54 PM
|
|||
|
|||
|
Yes, you need to transfer the backup file to the target server and tell it to restore from file. See http://msdn.microsoft.com/library/d...backpt_15ro.asp for complete instructions.
__________________
Up the Irons What Would Jimi Do? Smash amps. Burn guitar. Take the groupies home.
|
|
| Viewing: ASP Free Forums > Database > Microsoft SQL Server > database transfer |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
|
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
