none
SQL Server rebuild RRS feed

  • Question

  • We are rebuilding SQL Server: same name, same ip address. We are reinstalling Windows 2008 R2 and SQL Server 2005. DPM is currently installed. How do we retain existing backups and continue with the new ones after the rebuild completes? Should we uninstall the DPM agent before we rebuild the server? Will we be able to install the agent on a server of the same name after the reinstall?

     

    Thanks,

    Tom

     


    Tom Morris
    Friday, September 9, 2011 4:20 PM

Answers

  • Hi Tom,

    This is probably a little late but I'd suggest the following if you are not restoring the system state of the SQL server (even though the name and IP address will be the same the server ID will change).

    Stop protection of the existing SQL data sources but retain recovery points. This will enable you to restore from existing disk based recovery points.

    Try uninstalling the DPM agent from the DPM server, it may error indicating you still have recovery points. If it does you can manually uninstall the agent from the SQL server, then run the install from the DPM console, it will prompt for removal of the record of the server from DPM but will still retain recovery points.

    Install the new SQL server, Install DPM agent and configure protection. This will allocate new replica and recovery point volumes. When you no longer need the older disk based recovery points remove them from inactive protection and this will free up disk space in the DPM storage pool.

    You could restore the databases from the DPM server inactive protection to the new SQL server after installation of the agent if you needed to.

    Hope this helps

    Wednesday, October 19, 2011 3:40 AM