Copy MSSQL Database Between Accounts

B

bgriffin

Perch
Move MSSQL Database Between Accounts

I need to move a MSSQL database that I have in one of my Jodohost accounts across to another one of my Jodohost accounts.

I have tried opening a ticket and also speaking to the online support but they do not seem to be able solve my problem.

This is the information I have obtained from them so far:

I need to backup the database I want to move.
I then need to change the DBO permission (not sure what the DBO permission is).
I then need to restore the backuped database to the account where I actually want the database.

If anyone else has done this then please can you help by explaining how I do any of the above. I cannot find an import or export function in the online enterprise manager interface nor do I know how to change the DBO permission for the database.

I though it was quite a simple request but the support guys don't seem to be able to do it.

Any help much appreciated.

Bruce
 
The ticket number is 46651 in case you were wondering and I could post the online support conversation if you like.
 
I have gone through your conversesation with Ranjan and The existing user in backup which owns objects in backup can not be allowed for the new database so we need to remove that user,leaving your objects,And thus the restoration process will take some time.as illustrated to you on live chat.

Please give us some more time so that we can restore and perform all necessary task to make your new database available for the user in your control panel. :
 
Bruce

The issue isn't as easy as it may seem. The user for the database would have to be reassigned and HSphere wouldn't recognise it. I believe the support team was trying a different approach, will update you
 
You must log in or register to reply here.
Back
Top