Transaction Log Shipping

Question

Transaction Log Shipping

jacksonkleip

Newbie

Points: 6
More actions
April 29, 2010 at 4:17 pm

#140682

I have a question that I have not come across before and cannot try this as my primary / secondary db's are production only. I have a primary database set-up with transaction log shipping over to a standby/read only database. The user has requested for their upgrade process for me to take the primary database to read-only for a short period of time after they close their app and re-configure it and then switch backup the primary database to read/write.
The question I have as I confess I have done this ... is this possible with transaction log shipping or do I have to disable this and how does this affect my transaction logs and can it be re-configured without having to re-standby or DR my secondary server. I don't have a test environment to see what the outcome is ...

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Henrico Bekker One Orange Chip Points: 27652 More actions · Answer 1

No matter what the answers, testing on production servers is never a good idea.

-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle

Brandie Tarvin SSC Guru Points: 173108 More actions · Answer 2

Henrico Bekker (4/29/2010)
No matter what the answers, testing on production servers is never a good idea.

I have to whole-heartedly agree with this sentiment. Create a Dev server setup and test it there before you even touch your production servers.

Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

jacksonkleip Newbie Points: 6 More actions · Answer 3

thanks ... I found a way to do on a few test boxes ... the answer there are no ill affects to the primary database if you put it in read only which removes the connections ... once you put it back into read write mode make a change ... the change will happen on the standby once the logs are applied.

Thanks for the remarks ... just never had a request to do this and since I have 5 dbs to do as part of an upcoming project ... just wanted to make sure it would not disable or cause issues to the dr database and it the dr database would go back to applying once the primary went back to read write.