473,241 Members | 1,431 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,241 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 1502

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: ^CrAsH^ | last post by:
Hi to all, i've a "problem" with log shipping in sql server 2000 sp3. My log shipping works fine, but the task does not update log_shipping_primaries table on secondary server, and so log shipping...
2
by: Tim Groulx | last post by:
Hello, I am setting up log shipping between two SQL servers. Everything in the setup seems to work fine. The problem I am having is that the "Log Shipping Alert Job - Backup" job is failing,...
4
by: Jason Huang | last post by:
Hi, In the MS SQL 2000 Server, if the log shipping is set up right, does that mean data in primary server changed will mapped to secondary server later on? Thanks. Jason
1
by: Jennie | last post by:
I am implementing Log Shipping. I have the transaction logs copying to the standby server and applying to the standby database with no errors. However, I am having problems with the role...
1
by: GB | last post by:
Hello: I'm using MS SQL Server 2000 developer edition and trying to implement log shipping to the secondary server. I copied a database MDF and LDF files from primary to secondary server and all...
0
by: lovexueer | last post by:
when I set up log shipping in SQL SERVER 2000 I got the following error: 'Unable to copy the initialization file to the secondary server '%s' ' I know this is permission question about...
1
by: theSpinel | last post by:
Is it possible to failover a single or a selected number of databases onto a standby server? We're currently log shipping about 12 databases to a standby and I was wondering if it was possible to...
1
by: madzambonis | last post by:
I am in a 2 Database shop (DB2 and SQL Server) in which one of our larger clients use Log Shipping. We have need to tune a table on the primary server and ADDED a simple index to a table. ...
0
by: Axlin | last post by:
Hi. Could someone tell me what did i miss out in my steps when i configured our production database to our development database? I tried on 2 separate servers and also between 2 separate...
0
by: abbasky | last post by:
### Vandf component communication method one: data sharing ​ Vandf components can achieve data exchange through data sharing, state sharing, events, and other methods. Vandf's data exchange method...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 7 Feb 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:30 (7.30PM). In this month's session, the creator of the excellent VBE...
0
by: fareedcanada | last post by:
Hello I am trying to split number on their count. suppose i have 121314151617 (12cnt) then number should be split like 12,13,14,15,16,17 and if 11314151617 (11cnt) then should be split like...
0
by: stefan129 | last post by:
Hey forum members, I'm exploring options for SSL certificates for multiple domains. Has anyone had experience with multi-domain SSL certificates? Any recommendations on reliable providers or specific...
0
by: MeoLessi9 | last post by:
I have VirtualBox installed on Windows 11 and now I would like to install Kali on a virtual machine. However, on the official website, I see two options: "Installer images" and "Virtual machines"....
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...

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.