By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
464,813 Members | 1,080 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 464,813 IT Pros & Developers. It's quick & easy.

Log Shipping to two Databases on One Secondary Server

P: n/a
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?


Apr 26 '06 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.