SQL Backup/Restore License

mandersonmanderson Posts: 3
edited November 15, 2016 11:55AM in SQL Backup
I'm a DBA in a Microsoft Dynamics AX environment. We have multiple development and testing servers each with their own sql instances. We're still currently on SQL Sever 2005 for now.

I have 1 license of SQL Backup. In order for me to backup our production database and restore to a multiple sql development/testing instances, do I need a license for each server I'm restoring to?
· Share on Twitter

Comments

  • peteypetey Posts: 2,358 New member
    You have 2 options with regards to restoring the backups:

    1 - convert the SQL Backup file to native SQL Server backup file, then restore the database
    The SQL Backup converter does not require a license. Disadvantage is that you will need more disk space to store the native SQL Server backup file prior to restoring the database.

    2 - use SQL Backup to restore the database directly
    You will require SQL Backup licenses to do this, but do contact sales@red-gate.com, who might be able to set you up with restore-only licenses.
    Peter Yeoh
    SQL Backup Consultant Developer
    Associate, Yohz Software
    Beyond compression - SQL Backup goodies under the hood, updated for version 8
    · Share on Twitter
  • mandersonmanderson Posts: 3
    Thank you. I'll try those suggestions.
    · Share on Twitter
  • arunsahu2468arunsahu2468 Posts: 1 New member
    Yes Manderson its better to convert DB to Microsoft based one so that the compatibility issue will be cleared so that your can perform any action in smooth way. Its better to take back up of data before you go ahead. Better to do such kind of operations in the presence of Dynamics AX Developers so that if you face any complexity they will resolve immediately. all the best.
    · Share on Twitter
Sign In or Register to comment.