dbTalk Databases Forums  

Log Shipping to two Databases on One Secondary Server

comp.databases.ms-sqlserver comp.databases.ms-sqlserver


Discuss Log Shipping to two Databases on One Secondary Server in the comp.databases.ms-sqlserver forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
AT
 
Posts: n/a

Default Log Shipping to two Databases on One Secondary Server - 04-26-2006 , 02:27 AM






Is it possible to do SQL log shipping to more than one
Databases on same Secondry Server WITH A DIFFERENT SCHEDULE for each
log shipping?
You can set up log shipping to go to as many servers as
you want, but you only get one schedule in the plan. If
you set up a second log shipping schedule, you get an
error because the server is already set up for log
shipping in the other plan.

Just wondering if this is possible.

For example. I have 2 servers.

The Main server needs to ship it's logs to two other
databases. (Server A)

I want the main server to ship the logs to Server A every
45 minutes for ClientDatabase1.

I want the main server to ship the logs to Server A every
60 minutes for ClientDatabase2.

Can this be set up?

Parveen


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.