I'm using the Backup-SPFarm PowerShell cmdlet to backup our SP 2010 Server farm and all of its associated databases. We want to test our restore process, and I'm wondering if it's possible to restore the farm databases (using the Backup-SPFarm backup files) to the same SQL Server instance, but with all different database names, so that our restoration test doesn't conflict with or overwrite the live farm databases. If not, we can stand up another instance of SQL Server for our restoration testing.

  • 2
    I understand why you want to do this, but don't use production for test. Mar 14, 2014 at 17:39

1 Answer 1


I dont do this, even you can rename the DB while restoring the from backup but still you are on your production server.

Just think, more pressure on the SQL Server, resource fighting, and just a single mistake blow up your production Data.

I would go for separate SQL server for this test.

  • @Robert and Waqas, you are both right; we'll use the "NewDatabaseServer" parameter for Restore-SPFarm to point to a new SQL instance. Thanks for the reminder to keep it safe and simple :)
    – udog
    Mar 14, 2014 at 18:17

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.