Log Shipping in multiple databases

I am trying to configure Log_Shipping in multiple databases on different
servers.
I tried to add it but it has to use the same destination copy folder, is
that true ?
i am using SQL2005.I haven't used the 2005 log shipping. Log shipping in general works under
the following model. There are two virtual jobs that run consecutively; the
first virtual job would be to create a log for a given time frame on the
source server and write it to the local disk and subsequently send a copy of
that log file to the destination server. The second virtual job is to read
the log file sent from the source server and when it reads the log file, it
can either delete it or more commonly, the file is saved for a given time to
another folder that consists of logs that have been read.
Example:
Write log to \\mysourceserver\backup\mylog_date_time.log
Copy mylog_date_time.log from \\mysourceserver\backup to
\\mysdestserver\backup
Read log \\mysourceserver\backup\mylog_date_time.log
Store log by moving \\mysourceserver\backup\mylog_date_time.log to
\\mysourceserver\storage\mylog_date_time.log
Finally there may be a purge time set to delete logs older than a set time.
--
Regards,
Jamie
"Mahmoud Amin" wrote:
> I am trying to configure Log_Shipping in multiple databases on different
> servers.
> I tried to add it but it has to use the same destination copy folder, is
> that true ?
> i am using SQL2005.
>
>|||Thanks Jamie for help,
I am already running Log Shipping from one server to another one, but i am
going to buy a new server with a highly configuration and want this new one
to be the main database and the old one be another log shipping database ( 1
main db and 2 log shipping db).
I tried it on a test server but any adding new server, has to change the
copy folder into the old server by force.
"thejamie" <thejamie@.discussions.microsoft.com> wrote in message
news:786DB259-3386-4E4E-9A0A-FFE03BC5557B@.microsoft.com...
>I haven't used the 2005 log shipping. Log shipping in general works under
> the following model. There are two virtual jobs that run consecutively;
> the
> first virtual job would be to create a log for a given time frame on the
> source server and write it to the local disk and subsequently send a copy
> of
> that log file to the destination server. The second virtual job is to
> read
> the log file sent from the source server and when it reads the log file,
> it
> can either delete it or more commonly, the file is saved for a given time
> to
> another folder that consists of logs that have been read.
> Example:
> Write log to \\mysourceserver\backup\mylog_date_time.log
> Copy mylog_date_time.log from \\mysourceserver\backup to
> \\mysdestserver\backup
> Read log \\mysourceserver\backup\mylog_date_time.log
> Store log by moving \\mysourceserver\backup\mylog_date_time.log to
> \\mysourceserver\storage\mylog_date_time.log
> Finally there may be a purge time set to delete logs older than a set
> time.
> --
> Regards,
> Jamie
>
> "Mahmoud Amin" wrote:
>> I am trying to configure Log_Shipping in multiple databases on different
>> servers.
>> I tried to add it but it has to use the same destination copy folder, is
>> that true ?
>> i am using SQL2005.
>>|||Hi Amin,
You have 1 server which has primary db and you configure it
for log shipping to 2 different secondary servers....i guess this is what
you want....
but i think you are trying to configure log shipping from 1 st primary to 1
st secondary
and from the 1st primary to the same secondary server...so you'll have 2
copies of your log shipped db in your secoindary server......but that will
not server the purpose of log shipping as in case the seconday server is down
you won't have backup of primary server.......
but you can configure like that but you'll have only 1 shared folder which
conains both the logs from primary server
refer the below link for configuring log shipping just a sample
http://deepakinsql.blogspot.com/2007/06/how-to-configure-log-shipping-in-sql.html
Thanxx
Deepak
"Mahmoud Amin" wrote:
> I am trying to configure Log_Shipping in multiple databases on different
> servers.
> I tried to add it but it has to use the same destination copy folder, is
> that true ?
> i am using SQL2005.
>
>