Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Clustered SQL Server, Backup Device and Log Shipping

Status
Not open for further replies.

jkb17

Programmer
Nov 27, 2000
156
US
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top