Activity overview
Latest activity by garga1
Hi Eddie,
I followed your directions to add sql backup agent as a clustered source - it did not get added automatically when I installed the service using command line. However, when I failed over the sql service to another node, the sql backup agent did not come online on the other node. The service finally came back online on the node it was installed on. What could be the reason?
Thanks.
Ajay / comments
Hi Eddie,
I followed your directions to add sql backup agent as a clustered source - it did not get added automatically when I installed the service using command line. However, when I failed over ...
Some progress. Removed the parenthesis from around the instance name (even though the only example uses them), and now the installation is successful. However, all the settings for PATH, DATAPATH, and LOGPATH were ignored and setup proceeded with the default locations on the C: drive. Also, don't see the service as a clustered resource.
Any ideas? This is needed to save issues when we failover an instance to another host. Our backups start failing because the default locations are on the C: drive and C: drive is not a clustered disk. I want to put the binaries and the datafiles on a clustered source. / comments
Some progress. Removed the parenthesis from around the instance name (even though the only example uses them), and now the installation is successful. However, all the settings for PATH, DATAPATH, ...
anybody who can help? / comments
anybody who can help?
redgate backup installation from command line
Hello,
I am having some issues with trying to install backup tool using command line. It gets installed successfully using the GUI though. But I want the command line option. This is what I am runn...
Thanks for your reply. As you can see in the backup code I posted below, I passed the value for password as abc12defLHG. I think what you are saying is that since this value is enclosed between <ENCRYPTEDPASSWORD> and </ENCRYPTEDPASSWORD> tags, this is the encrypted form of the password. Well, in that case, I don't have the non-encrypted password. So, to fix my code for future, this is what I need to run to take backup:
EXECUTE master..sqlbackup N'-SQL "BACKUP DATABASE AjayDB TO DISK = ''Z:\WrkFolder\AjayDB_201304011011_full.bak'' WITH COMPRESSION = 1, THREADCOUNT = 4, KEYSIZE = 256, PASSWORD = ''abc12defLHG''"'
And then use abc12defLHG as password to restore when needed. Is my understanding correct?
Ajay / comments
Thanks for your reply. As you can see in the backup code I posted below, I passed the value for password as abc12defLHG. I think what you are saying is that since this value is enclosed between <EN...
Perfect solution. Thank you so much. / comments
Perfect solution. Thank you so much.
Is RedGate backup tool activated?
Hi,
We use RedGate backup tool in our environment to backup giant databases. Our entire team has permissions to install the tool on the servers they are responsible for. When the license limit is r...