01-24-2014 01:42 PM - edited 03-14-2019 01:00 PM
We have a rogger and an admin server that have locally-hosted databases using MSSQL Enterprise Edition. Due to licensing concerns, we would like to change these to Standard Edition via uninstall and reinstall.
My questions is: Would the CGUpgradeBackup tool work for this task?
01-24-2014 01:44 PM
can't you just backup and restore the database again? i never used the cgupgrade tool before
Sent from Cisco Technical Support Android App
01-24-2014 01:59 PM
Eric,
I've done something similar, except my scenario was that I installed the wrong - unsupported - version of SQL Server. What I did was stop the ucce services and backup all my databases (logger, aw, hds, dialer) through SQL Server Mang. Studio. Once the back-ups were completed, I deleted the databases through ICMdba and then proceeded to uninstall SQL Server. Once the uninstall completed, I rebooted and then installed SQL Server by following the staging guide. Once SQL was up, I recreated the databases via ICMdba, restored the databases that I previously backed up, initialized the database, and then made sure my recovery keys and min-max datetime matched on the logger db's. If the recovery keys don't match, you can truncate the recovery table.
EDIT: One thing you definitely want to make sure of after the restoring the databases is that the sizing of the databases are still intact. If for example your HDS is sized for 300GB for data and 50GB for transaction logs, make sure that's what their initial size is post-restore. This can be found by going to the properties of the database and going to Files. Also, make sure autogrowth is enabled.
Your mileage may vary
Discover and save your favorite ideas. Come back to expert answers, step-by-step guides, recent topics, and more.
New here? Get started with these tips. How to use Community New member guide