Comments
Sort by recent activity
Hi Tim,
If I understand correctly you are refering to using <ENCRYPTEDPASSWORD> in restore just like it is shown in backup script.
The issue is that when you schedule restores script similar to the following:
Code:
EXEC master..sqlbackup '-sql "RESTORE ... WITH PASSWORD = [password]..."'
The password is out in the open, in plain text. Regardless of how the password may be encrypted (different encryption scheme, different salt etc), as long as another user is able to access the script (via msdb, profiler, network sniffer etc), they can simply run the same script to run the restore without having to know the actual password. Thus you actually need to secure the script contained in the msdb table, and limit user rights to run Profiler.
SQL Backup 3 allowed the use of encrypted passwords, but this lead to a false sense of security. We had a lot of internal discussions regarding this. We thought that DBAs were not worried that the restore script was exposed, not realising that the encrypted password was as good as the actual password. By forcing the use of the password in plain text, DBAs become more aware of the need to secure the script. And for that reason we pulled <ENCRYPTEDPASSWORD> support away from restore script.
If you think there are better ways to encrypt restore script then please do suggest us. We would really appreciate it.
Thanks,
Priya / comments
Hi Tim,
If I understand correctly you are refering to using <ENCRYPTEDPASSWORD> in restore just like it is shown in backup script.
The issue is that when you schedule restores script similar to the...
Hi Dan,
Thanks for your feedback regarding the upgrade process. Sorry that you are encountering this other issue.
Can you please send the screen shot at this email id backup.prerelease@red-gate.com?
Thanks,
Priya / comments
Hi Dan,
Thanks for your feedback regarding the upgrade process. Sorry that you are encountering this other issue.
Can you please send the screen shot at this email id backup.prerelease@red-gate.com...
Hi,
This is the exact scenario we are are trying to support with our new Network Resilience capability. You can configure how long to wait when a network outage happens.
Do give it a try and let us know if it helps you in your case.
Thanks,
Priya / comments
Hi,
This is the exact scenario we are are trying to support with our new Network Resilience capability. You can configure how long to wait when a network outage happens.
Do give it a try and let us...
Hi lculley,
Using SQL Data Compare is the most flexible way to do row level restore, but I can let you know that a similar functionality is under strong consideration for the forthcoming major release. We’ll be able to post more info soon once plans are settled, so keep an eye out! [image]
Regards,
Priya / comments
Hi lculley,
Using SQL Data Compare is the most flexible way to do row level restore, but I can let you know that a similar functionality is under strong consideration for the forthcoming major rele...
Hi Chris,
This issue is still under review for V 6.0. We are not yet sure at this stage whether it will make into V 6.0 or later release.
Thanks,
Priya / comments
Hi Chris,
This issue is still under review for V 6.0. We are not yet sure at this stage whether it will make into V 6.0 or later release.
Thanks,
Priya
Hi Chris,
SQL Backup 6.0 is planned to be released in Q2.
There are certain bugs which we are still under review. SB-3550 is under this category... depending on development time and schedule for the project we would be able to decide about this. I will keep you updated about this issue.
Thanks,
Priya / comments
Hi Chris,
SQL Backup 6.0 is planned to be released in Q2.
There are certain bugs which we are still under review. SB-3550 is under this category... depending on development time and schedule for th...
Hi,
Please read this post: http://www.red-gate.com/MessageBoard/viewtopic.php?p=26995
Hope this helps.
Thanks,
Priya / comments
Hi,
Please read this post:http://www.red-gate.com/MessageBoard/viewtopic.php?p=26995
Hope this helps.
Thanks,
Priya
Hi,
Sorry for the inconvenience.
Can you please send me a screen shot at priya.sinha@red-gate.com?
Thanks,
Priya / comments
Hi,
Sorry for the inconvenience.
Can you please send me a screen shot at priya.sinha@red-gate.com?
Thanks,
Priya
Hi,
This is happening because you have run out of disk space. SQL Backup UI stores the cache (SQLite database) at this location:
%\Documents and Settings\<user name>\Local Settings\Application Data\Red Gate\SQL Backup\Server DataPlease free up disk space on the drive where your cache is located.
Thanks,
Priya / comments
Hi,
This is happening because you have run out of disk space. SQL Backup UI stores the cache (SQLite database) at this location:
%\Documents and Settings\<user name>\Local Settings\Application Data...
Hi,
Yes, if you use split file then SQL Backup will use one thread for each of the file.
Thanks,
Priya / comments
Hi,
Yes, if you use split file then SQL Backup will use one thread for each of the file.
Thanks,
Priya