471,073 Members | 1,385 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,073 software developers and data experts.

Log Shipping to two Databases on One Secondary Server

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

Apr 26 '06 #1
0 1415

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

4 posts views Thread by Jason Huang | last post: by
1 post views Thread by Jennie | last post: by
1 post views Thread by GB | last post: by
1 post views Thread by theSpinel | last post: by
1 post views Thread by madzambonis | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.