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.