Posted by Parveen.Beniwal.Daffodil on 04/26/06 10:27

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

• Next in forum: Re: query hheeelp
• Prev in forum: Re: SQL in Access Report
• Thread view: Log Shipping to two Databases on One Secondary Server

[Reply to this message]