Dual Log Shipping Restore Jobs

I have 2 SQL server 2000 servers, Server A, and Server B.
Server A is production. It has a log shipping restore job that updates the
database every half hour throughout the day automatically.
Server B is a reporting/test server, that has its log shipped restored
manually every 6 hours.
There is a job on Server A, that copies the transaction logs to a folder on
Server B every half hour.
We are manually restoring the transaction logs for Server B, that are copied
into this folder every 6 hours. So yeah, we have 6 hours worth of half hour t-
logs to restore every 6 hours.
I need to create a job, on server A, that will automatically restore the t-
log every 6 hours on Server B , AND keep its current half-hour log shipping
plan so we won't have to keep manually restoring the t-logs on Server B every
day?
So server A will continue to restore every half hour, and server b will be
restored with a big bulldog t-log file for the last 6 hours.
I hope that ws made clear.
Any insight would be wonderful, thanks in advance.
--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/200510/1Just a thought, have you considered replication every 30 mintues or so
instead of immediate updating? (I assume you aren't doing this with
immediate updating due to the load or something like that).
Shawn Mason
--
Shawn Mason
Customer Support
http://www.visualonline.net
"Frank N via SQLMonster.com" <u10790@.uwe> wrote in message
news:5687be0f857c0@.uwe...
>I have 2 SQL server 2000 servers, Server A, and Server B.
> Server A is production. It has a log shipping restore job that updates the
> database every half hour throughout the day automatically.
> Server B is a reporting/test server, that has its log shipped restored
> manually every 6 hours.
> There is a job on Server A, that copies the transaction logs to a folder
> on
> Server B every half hour.
> We are manually restoring the transaction logs for Server B, that are
> copied
> into this folder every 6 hours. So yeah, we have 6 hours worth of half
> hour t-
> logs to restore every 6 hours.
> I need to create a job, on server A, that will automatically restore the
> t-
> log every 6 hours on Server B , AND keep its current half-hour log
> shipping
> plan so we won't have to keep manually restoring the t-logs on Server B
> every
> day?
> So server A will continue to restore every half hour, and server b will be
> restored with a big bulldog t-log file for the last 6 hours.
> I hope that ws made clear.
> Any insight would be wonderful, thanks in advance.
>
> --
> Message posted via SQLMonster.com
> http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/200510/1