Log Shipping

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 7,2000 » In The Enterprise » Log Shipping

13 posts, Page 2 of 2

««1 2

Log Shipping

Rate Topic

Display Mode

Topic Options

Author

Message

r.sgsits

Posted Wednesday, September 22, 2010 8:28 AM

Forum Newbie

Group: General Forum Members
Last Login: Monday, April 02, 2012 7:32 AM
Points: 1, Visits: 92

Sugesh,

I am small doubt..i hv copied the tuf file in 2 location but my one original tuf file is updating in every 15Min(log is applying) this info is not updating in secondary tuf file coz i have made the copy in time when i configured the logshipping..
now someone has deleted the primary tuf file if i copy the older tuf file to primary location will it work ???

reagrds
sgsits

Post #991219

swaraj.saini

Posted Thursday, May 26, 2011 5:40 AM

Forum Newbie

Group: General Forum Members
Last Login: Thursday, April 18, 2013 5:41 AM
Points: 8, Visits: 43

you can not place old TUF file because each and every time when database get restored in Standby mode it Uses that Tuf file and Recreate it . because tuf file stands for Transaction Undo file it holds all the redo undo data related to transaction of current Restoration Trn file

Post #1115336

HARIANGEL

Posted Saturday, April 21, 2012 3:28 PM

Forum Newbie

Group: General Forum Members
Last Login: Friday, May 17, 2013 2:44 AM
Points: 4, Visits: 72

If tuf file missing makes logshipping does not work properly. Why can't we just take the full backup and restore on secondary and start the functionality as usual.

Let me know if it does not help much.

Post #1287673

« Prev Topic | Next Topic »

13 posts, Page 2 of 2

««1 2

Permissions