March 23, 2009 at 8:41 am
Hi Guys,
I am implementing logshipping in sqlserver 2000.i want some consistency in 2 of the databases.can anyone help me on how to insert a markers in transactions in sqlserver 2000?
Thx
March 23, 2009 at 9:51 am
I'm not sure what you mean by "markers".
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
March 23, 2009 at 10:03 am
My thoughts exactly. What are makers?
Log Shipping is moving the tlog backups. They will be consistent. That's what a relational database does is ensure consistency based on the transaction logs.
March 23, 2009 at 12:53 pm
I think he might be referring to the MARK function in the "BEGIN TRANSACTION"; which can be used for recovery and such.
However I have never tried to set MARK while using T-Log shipping...
Thanks.
Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
Microsoft FTE - SQL Server PFE
* Some time its the search that counts, not the finding...
* I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply