I would use a slightly different method by moving/copying the entire CDR database to the new SQL server.
(this will allow you to keep your original CDR intact without any data deleted, for fall-back purposes)
You can do the following:
1) on the CCMPublisher, stop the CDR Insert service
Using SQL Enterprise Manager -
2) dismount the CDR database:
right-click on the database, choose AllTasks>TakeOffline;
right-click on the database, choose DetachDatabase
3) file copy the CDR database to the new SQL server; also any transaction logs for the db
4) on the new SQL server, use Enterprise Manager to mount the newly copied database:
right-click databases, choose newDatabase;
on the dataFiles tab, select the CDR database from its new location;
on the transactionLog tab, select the CDR db transaction logs/location
(use the 'initial size' and 'growth rate' from the original CDR SQL parameters)
5) apply appropriate permissions to the newly mounted database
(can copy from original CDR database permissions)
6) now point your CCMPub to the new CDR database location, if you need to; restart the CCMPub CDR Insert service
7) now point your call accounting software, if needed, to the new CDR database location
8) if required, 'AttachDatabase' and 'BringOnline' the original CDR database on the CCMPub to get it working again.
