Move Database to archive Database
Warning Make sure the script version matches your UCCUCC stands for Unified Contact Center and consists of a queue that can be handled by Agents. Each UCC has its own settings, interactive voice response questions and Agents with specific skills. Agents can be member of, or sign up to, one or more UCCs. version. If not data loss will occur.
Note To keep your archive database version up to date, let a UCC run on the database.
Archive database already created
Tip You can copy the database to already have all the data in the archive.
This script will move all data from the current database to the archive database.
Then it will cleanup the current database, with records older then the retention.
Run Move to Archive
Request the "MoveToArchive" script from the support desk
Login to a machine / server with "Microsoft SQL Server Management Studio"
Connect to the Database engine, where the databases are located
Open the "MoveToArchive" script
Enable SQLCMD mode. (Menu > Query > SQLCMD Mode)
Change the variables
DatabaseName = Name of the current database
ArchiveDatabaseName = Name of the archive database
Change the Parameter
DaysRetention = The number of days you would like to keep data in the current database
Execute the script
Did you find this page helpful?
Sorry about that
Why wasn't this helpful? (check all that apply)
Thank you for your feedback.
Want to tell us more?
Email your feedback to our documentation team.
Thanks for taking the time to give us some feedback.