Options
Restore to test server
larbs
Posts: 3
I have 5 licenses .. all allocated to prod servers. About once every six months I need to restore a prod db to a test server (not allocated on one of my RG backup pro licenses).
Backups in prod are done with Full(weekly), diff(daily),trans(hourly)
Am I right in assuming that without buying a new license for my test server that I have to
1. take a full backup outside of RG backup pro ( so I get a non .SQB file)
2. restore from that to my test server
3. run another full backup with redgate so that red-gate backups have the latest full to run a diff off of? (seems like RG backup might get confused if I run backups outside of RG backup too.
Thanks
Backups in prod are done with Full(weekly), diff(daily),trans(hourly)
Am I right in assuming that without buying a new license for my test server that I have to
1. take a full backup outside of RG backup pro ( so I get a non .SQB file)
2. restore from that to my test server
3. run another full backup with redgate so that red-gate backups have the latest full to run a diff off of? (seems like RG backup might get confused if I run backups outside of RG backup too.
Thanks
Comments
You have a few options to achieve this :
Convert one of your weekly Full Backups to mtf format and restore it using SSMS/QA.
To convert the file you can use sqb2mtf (found in your SQL Backup Installation folder with instructions in the help file) or use the GUI version available from :
http://labs.red-gate.com/index.php/SQL_ ... _Converter
Alternatively you could take a Native Full Backup, SQL Backup differential and transaction log backups will run from the Native Backup but you should keep it at least until the next weekly full SQL Backup has completed successfully.
The 3rd option would be to use the COPY ONLY option as per you post update.
I hope this helps.
Redgate Foundry