Service Desk Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

SD 5.1 backup and restore.

SOLVED
Go to solution
Highlighted
Fady Bassyouni
Regular Collector

SD 5.1 backup and restore.

Dear All,

I am having this problem that seems to be common with many SD users. I simply need to backup my SD database in order to restore it on a new installation of SD (to be used in case of system failures for example) but as you know it is not as simple as using the SQL Backup/Restore utility.
I am using SD 5.1 patch 7, SQL 2000 SP4 on windows server 2003 SP1.
The problem appears to be with giving ownership of the DB to the new SQL account instead of the old account.
I tried the following steps as advised by a friend but i still unable to connect to the DB and the owner didn't change!:


1-Run ovc -kill
2-start sql server and create a db and restore dump from other machine
3-now run these two scripts against the DB (they make the db owner SA and they link the dbuser to a login):

•exec sp_changedbowner 'sa'

•sp_change_users_login ‘update_one’, ‘’,’

4-Run ovc –start

Can anyone tell me the correct steps of doing this task from your experience? or any hints that might be useful.

Thanks,
Fady

3 REPLIES
Fady Bassyouni
Regular Collector

Re: SD 5.1 backup and restore.

Guys,
I am waiting for your contributions, good points for every valid suggestion!

thanks,
Fady
Err_1
Honored Contributor
Solution

Re: SD 5.1 backup and restore.

Hi Fady,

take a look at this document, it might help you with your restore using MS SQL.

Hope it helps you!
http://support.openview.hp.com/selfsolve/document/LID/OV-EN022569

Regards;
Randall Barrantes
SW Support Delivery Manager
Fady Bassyouni
Regular Collector

Re: SD 5.1 backup and restore.

thank you Err, it seems like a very good document and it is relative to the problem. i'll test and get back to you with the results.

fady
//Add this to "OnDomLoad" event