Viewing 14 posts - 16 through 30 (of 30 total)
I've verified that the system time on both are exactly in sync within one second or less. Also, there is no pausing of the jobs at an any time,...
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
One of the greatest tragedies in life is to lose your own sense of self and accept the version of you that is expected by everyone else.
August 25, 2016 at 9:25 am
yes, the result set from your posted query shows accurate information. It shows the same information the Log Shipping Monitor from Red-Gate shows.
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
One of the greatest tragedies in life is to lose your own sense of self and accept the version of you that is expected by everyone else.
August 24, 2016 at 3:58 pm
The Red Gate Shipping Monitor is just a monitoring software to inform me that log shipping is working in all its facets.
I'm using the native Log Shipping in SQL Server.
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
One of the greatest tragedies in life is to lose your own sense of self and accept the version of you that is expected by everyone else.
August 10, 2016 at 3:39 pm
Evil Kraig F (12/13/2010)
This will force the database to a single_user mode (the one running the process) and rollback all transactions when it...
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
One of the greatest tragedies in life is to lose your own sense of self and accept the version of you that is expected by everyone else.
May 20, 2016 at 11:46 am
I was pretty sure this job just updated the dbm_monitor_data table in MSDB. This job isn't configured to report if there are issues, so you'd have to employ another...
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
One of the greatest tragedies in life is to lose your own sense of self and accept the version of you that is expected by everyone else.
March 29, 2016 at 8:37 am
I've been waiting for the process to finish for several hours now. When I first ran the kill command after seeing the SPID in rollback status, I got the...
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
One of the greatest tragedies in life is to lose your own sense of self and accept the version of you that is expected by everyone else.
January 4, 2016 at 3:18 pm
Great link and info, but somewhat difficult to follow at certain points. It definitely needs proofreading as the punctuation is sub par 🙁
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
One of the greatest tragedies in life is to lose your own sense of self and accept the version of you that is expected by everyone else.
September 26, 2014 at 9:10 am
Strange, I used the URL editor and mine didn't make the link like yours is shown 🙁
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
One of the greatest tragedies in life is to lose your own sense of self and accept the version of you that is expected by everyone else.
September 26, 2014 at 8:13 am
Received an answer on another site, wanted to post in case someone else ran into this question.
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
One of the greatest tragedies in life is to lose your own sense of self and accept the version of you that is expected by everyone else.
September 25, 2014 at 2:02 pm
That is a cool trick that I didn't think of, thank you!
I'll use this for the time being to make sure I have good data, but I'm still concerned that...
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
One of the greatest tragedies in life is to lose your own sense of self and accept the version of you that is expected by everyone else.
September 17, 2014 at 8:34 am
Alright, posted this in twitter (#sqlhelp), linkedIn, and some other places....no one has an answer 🙁
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
One of the greatest tragedies in life is to lose your own sense of self and accept the version of you that is expected by everyone else.
September 15, 2014 at 1:58 pm
Thank you for your time Gail, I appreciate it!
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
One of the greatest tragedies in life is to lose your own sense of self and accept the version of you that is expected by everyone else.
September 10, 2014 at 3:17 pm
GilaMonster (9/10/2014)
1. Backup the TLOG
2. Change DB from Full to Simple
3. Change the initial size of the TLOG to something much smaller
4. Perform the log shrink
5. Change from Simple to...
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
One of the greatest tragedies in life is to lose your own sense of self and accept the version of you that is expected by everyone else.
September 10, 2014 at 2:54 pm
GilaMonster (9/17/2008)
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
One of the greatest tragedies in life is to lose your own sense of self and accept the version of you that is expected by everyone else.
September 10, 2014 at 1:35 pm
Viewing 14 posts - 16 through 30 (of 30 total)