Comments
Sort by recent activity
anybody who can help? / comments
anybody who can help?
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, ...
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 ...
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.