client licence question
Using standard SQL Server restore procedures on the laptops means that we don't have any licence costs to consider. However, what I would like to do is introduce something like Red-Gate SQL Backup on the central production SQL Server in order to benefit from speed and compression advantages. There is no requirement to improve the speed of restore to laptops as they are all LAN connected when they do the restores and they are satisfied with things as they are. However, the problem is that I can not justify buying a large number of licences for clients laptops when the requirement is to simply use Red-Gate SQL Backup on the single production server (an perhaps a few other central servers).
Therefore, can Red-Gate tell me if there is a zero cost option with regard to restoring backups that have been backed up using Red-Gate SQL Backup? It would have to be command line driven because we have to automate the process - sql server jobs.
By the way, I looked into this with regard to LiteSpeed and we couldn't choose that product because the implication is that we would have to buy many client licences. There is a free restore utility that comes with LiteSpeed called an 'extractor' but it is of no use to use because it is interderminate as to how many files will be extracted. This would make it difficult/messy to automate.
So, can Red-Gate offer something that would work for us?