• State Not Answered
  • Locked Locked
  • Replies 1 reply
  • Subscribers 12 subscribers
  • Views 2353 views
  • Users 0 members are here
Options
Related
This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

Automating backup restoration/conversion in a cloud environment.

tsokol
over 5 years ago

I have a vendor that is providing data to us in the form of a FTP server with Quest LiteSpeed backups that are updated on a daily basis. 

We only have macs and do most of our work in the cloud, so I'm trying to figure out how I can make the data accessible from these backups in an automated fashion. I hadn't heard about Quest before, but my understanding is that there is a (windows only) GUI utility that can restore or convert the backups as well as some kind of extension that you can install on/in/with MSSQL Server to allow you to backup from T-SQL and the command line. It isn't clear to me which product I would need to buy in order to have this functionality, or if there is some kind of free tool. 

I would love to find some kind of programming bindings that would allow me to convert the Quest LiteSpeed backups into native. Ideally I'd have some kind of cron job that would copy the backup file to cloud storage, then a lambda/cloud function to convert or restore the backup into something that I can access via code. 

I'm pretty new to the world of MSSQL, so any advice would be appreciated. 

Parents
  • 0 over 5 years ago

    Hello,

    I would suggest getting a trial version of Litespeed to do your restores. Using a  trial version of Litespeed has two benefits.

    One it would allow you to test using automated restore which is a feature of Litespeed that allows it to choose the correct backup to restore based on parameters you select. Once setup no further user actions are needed to perform the restore process. This is the tool that we most often recommend for customers who have a need to perform scheduled restores.

    The second benefit is that a trial version of Litespeed allows for restoring backups even after the trial period has expired. So you can keep using the Litespeed console or TSQL scripts to perform restores (But not backups or any function that requires a license such as automated restore. These will no longer work once the trial period has ended )

    You may also find a tool called the extractor ,which comes with Litespeed, useful. The extractor is a command line tool that extracts a native SQL backup  from a Litespeed backup. You could then use native tools to restore the extracted backup file.This process involves a few more steps than the one recommended above, but it is available to you and remains a free tool you can keep using after the trial period expires.

    Hope this helps,

    -Ben-

Reply
  • 0 over 5 years ago

    Hello,

    I would suggest getting a trial version of Litespeed to do your restores. Using a  trial version of Litespeed has two benefits.

    One it would allow you to test using automated restore which is a feature of Litespeed that allows it to choose the correct backup to restore based on parameters you select. Once setup no further user actions are needed to perform the restore process. This is the tool that we most often recommend for customers who have a need to perform scheduled restores.

    The second benefit is that a trial version of Litespeed allows for restoring backups even after the trial period has expired. So you can keep using the Litespeed console or TSQL scripts to perform restores (But not backups or any function that requires a license such as automated restore. These will no longer work once the trial period has ended )

    You may also find a tool called the extractor ,which comes with Litespeed, useful. The extractor is a command line tool that extracts a native SQL backup  from a Litespeed backup. You could then use native tools to restore the extracted backup file.This process involves a few more steps than the one recommended above, but it is available to you and remains a free tool you can keep using after the trial period expires.

    Hope this helps,

    -Ben-

Children
No Data