HOW TO MIGRATE DPM SRT (Microsoft Data Protection Manager – System Recovery Tool)
1. Stop DPM System Recovery Tool DataStore service
2. Stop MSSQLSERVER$SRT service
3. Disconnect and Reconnect to the new server the iscsi LUN if you have one, otherwise you have to use robocopy.exe (with parameter “/COPYALL”) to copy the source driveletter:\RPStore to the new server maintaining the same directory name.
4. Install DPM SRT on the target server and set the folder RPStore as the backup folder you had previously copied.
5. When the installation is finished, stop the MSSQLSERVER$SRT service.
6. Go to C:\program files\Microsoft SQL Server\MSSQL.1\MSSQL\Data and rename the following files:
DPMSRT.mdf
DPMSRT_log.ldf
RMFileStore.mdf
RMFileStore_log.ldf
7. Copy the following files from the source server to the target server:
pub.key *.rsd \Tasks\*.* %windir%\Tasks\*.job
8. Move all the files sorted on point 6 from the new server to another folder of the new server (or take a backup of the 2 databases if you want)
9. Copy all the files sorted on point 6 from the old server to the new server
10. On the new server start SQL Server 2005 Surface Area Configuration à Surface Area Configuration for Services and Connections à Remote Connections then choose “Use TCP/IP only”
11. Start SQL Server Browse Service and MSSQLSERVER$DPMSRT services on the new server and connect the instance named newserver\dpmsrt to a valid SQL Management Studio and execute this command:
Use DPMSRT
Update dbo.FilestoreTable
Set Name = --insert here the netbios name of the new server
Set ComputerName = --insert here the FQDN of the new server
Set RepositoryPath = --insert here the repository path of the new server
12. Set the correct password on all scheduled tasks of Windows and on the DPM Recovery Schedule Console
13. Reboot the new server and check if all of the services are running and if the DPM SRT is working correctly trying to submit a job for test purpose
Enjoy :-)
