Hello, I am familiar with setting up Log Shipping plans ans scenarios. I am also familiar with adding dump devices.
A new client has just asked that I setup a warm standby of their clustered SQL Server. I am not as familiar with clustered sql server but went in to take a look and setup (at the least) immediate backup devices to be posted (ie, copied to the standby server).
Problem is that when the SQL Server Agent on the cluster attempts to backup to these devices I get a failure. I have received a Backup Device does not exist error message. I dropped the device and re-added via QA with the sp_addumpdevice command. Now, the device was recognized.
When I tried to run from the QA, I received a db was not found in sysdatabases message.
I am attempting to have SQL Server Agent run and do a full db backup during the night. Then the backup is copied to the standby server for LS purposes. I will also backup the transaction logs during the day and post.
it seems that my problem is basic in that I am having issues backing up a clustered SQL Server Database to a device.
Any advice?
Jim
A new client has just asked that I setup a warm standby of their clustered SQL Server. I am not as familiar with clustered sql server but went in to take a look and setup (at the least) immediate backup devices to be posted (ie, copied to the standby server).
Problem is that when the SQL Server Agent on the cluster attempts to backup to these devices I get a failure. I have received a Backup Device does not exist error message. I dropped the device and re-added via QA with the sp_addumpdevice command. Now, the device was recognized.
When I tried to run from the QA, I received a db was not found in sysdatabases message.
I am attempting to have SQL Server Agent run and do a full db backup during the night. Then the backup is copied to the standby server for LS purposes. I will also backup the transaction logs during the day and post.
it seems that my problem is basic in that I am having issues backing up a clustered SQL Server Database to a device.
Any advice?
Jim