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.
1
-
2I understand why you want to do this, but don't use production for test.– Robert KaucherCommented Mar 14, 2014 at 17:39
Add a comment
|
1 Answer
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.
answered Mar 14, 2014 at 18:03
-
@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 :)– udogCommented Mar 14, 2014 at 18:17