How to configure Logshipping across the two forests

Hi,
I have configured Log shipping in my organisation which has two forests. One
forest has primary server and monitor server while the other forest has
secondary server. While configuring the Log shipping, read only database was
created successfully on the secondary server. Primary server is taking
transaction log backup on the specified time interval but it is not being
restored on the secondary server. What is the problem? How can I proceed?
Please guide me.
With regards,
Rajendra
You mentioned the secondary server is set to read only. Are there users in
there while you're trying to restore logs? If so, then the database is
already in a fully recovered state. From books online:
"It is not possible to apply a transaction log backup:
Unless the database or differential database backup preceding the
transaction log backup is restored first.
Unless all preceding transaction logs created since the database or
differential database were backed up are applied first.
If the database has already recovered and all outstanding transactions
have either been rolled back or rolled forward."
If you're trying to create a secondary reporting database, you might want to
try using replication instead. Depending on how you set it up, the secondary
data set can be kept more "up to date", and users can get in and out. Of
course, the database can't be read only, as replication will be writing to
it, but you can set all the users in the db_DataReader database role.
"Rajendra" wrote:

> Hi,
> I have configured Log shipping in my organisation which has two forests. One
> forest has primary server and monitor server while the other forest has
> secondary server. While configuring the Log shipping, read only database was
> created successfully on the secondary server. Primary server is taking
> transaction log backup on the specified time interval but it is not being
> restored on the secondary server. What is the problem? How can I proceed?
> Please guide me.
> With regards,
> Rajendra
|||Users Can be in the database on a secondary server if the
database has been restored using STANDBY which is an
option in the maintenance plan wizard. This is why there
is also the option to remove the users before a log
restore.
Rgds,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
|||Hi friends,
Thanx for the reply. But I was asking whether it is possible to configure
Log shipping across the forests or not?I think share name acorss the forests
is creating some problem because I am not able connect SQL server with server
name if forests is other than the forest where my computer resides. That's
why I am connecting SQL server using IP address.
With regards
"Rajendra" wrote:

> Hi,
> I have configured Log shipping in my organisation which has two forests. One
> forest has primary server and monitor server while the other forest has
> secondary server. While configuring the Log shipping, read only database was
> created successfully on the secondary server. Primary server is taking
> transaction log backup on the specified time interval but it is not being
> restored on the secondary server. What is the problem? How can I proceed?
> Please guide me.
> With regards,
> Rajendra
|||Rajendra,
do you have a forest trust? If so, this should be possible. Can you see the
share at all? If not, perhaps you need to edit the hosts file for it to be
accessible.
HTH,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)