Cross Domain Log Shipping

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Backups » Cross Domain Log Shipping

12 posts, Page 2 of 2

««1 2

Cross Domain Log Shipping

Rate Topic

Display Mode

Topic Options

Author

Message

lijusmail

Posted Monday, February 16, 2009 9:08 AM

SSC Rookie

Group: General Forum Members
Last Login: Wednesday, May 11, 2011 12:44 PM
Points: 33, Visits: 179

Hi Robert

When doing transaction log shipping and choosing the Database Option as Standby/Readonly, the users will get disconnected when the last step of restore is being done.
I have tested this and had to restart the Portal Services and then everything works fine.
So i added another step in the Restore Job to restart the Portal Services and they do work fine.

I did set a time delay to run the restoration process every 4 hours and is working fine.

Now i have come to a situation.
Would i be able to use this read only database for doing some comparison against an oracle view and generate the result from that and insert it to an Oracle Database table.

Thanks
Liju

Post #657836

Robert klimes

Posted Monday, February 16, 2009 6:08 PM

SSC Eights!

Group: General Forum Members
Last Login: Friday, May 17, 2013 1:55 PM
Points: 888, Visits: 1,848

I would see why you couldn't. As long as you are only reading from the database anything should work.

Bob
-----------------------------------------------------------------------------
http://www.sqlservercentral.com/articles/Best+Practices/61537/

Post #658164

« Prev Topic | Next Topic »

12 posts, Page 2 of 2

««1 2

Permissions