What are the challenges you face when working across database platforms? Take the survey
Options

Restore to test server

larbslarbs Posts: 3
edited September 22, 2008 1:16PM in SQL Backup Previous Versions
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

Comments

  • Options
    OK.. I see WITH COPY ONLY will help.
  • Options
    Hi larbs,

    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.
    Matthew Flatt
    Redgate Foundry
Sign In or Register to comment.