Transferring a database 1

[matevans]

Could someone help me regarding transferring a database to a different PC, also is it possible to transfer a 7.0 database to a 6.5 server?<br><br>Thanks

 

[deeparajesh]

There are two ways:<br><br>1. Use sp_detach_db and sp_attach_db(Transfers the entire db)<br><br>2. Connect to the new PC,by registering the IP address.<br>   To register, open SQL EnterpriseManager, Right Click on <br>   SQL ServerGroup and go in for New SQLServerRegistration. Give the IP address of the new PC and register it. Then take a back up of the existing db in yr PC and force restore file on the newly created db.This will help you restore a db to the new PC.<br><br>please do let me know if it works.

 

[matevans]

The two servers are not connected therefore I cannot use the second option.<br><br>Could you please expand on how to use sp_detach, sp_attach<br><br>Thanks

 

[deeparajesh]

Please refer to the mail that I have sent you