Viewing 15 posts - 15,421 through 15,435 (of 39,921 total)
First, even if you uncheck that box, I'm not sure SQL Server keeps an unlimited number of logs. I haven't found documentation and don't really want to restart an instance...
August 12, 2011 at 5:40 pm
Sorry, didn't realize you're posted that. Just so we're clear, you have log shipping set up on a primary and secondary server. The primary server (source) has logs set to...
August 12, 2011 at 12:41 pm
Brandie Tarvin (8/12/2011)
Steve Jones - SSC Editor (8/12/2011)
- work in a complex development environment that does automated builds at high volumes (> 1x...
August 12, 2011 at 11:27 am
I wouldn't think log shipping would require a restart. If you check the log shipping tables, are your settings changed?
August 12, 2011 at 11:26 am
Ray K (8/12/2011)
Steve Jones - SSC Editor (8/12/2011)
lots of the food isn't as great as what you can get a block or two outside the stadiums.
After that game at...
August 12, 2011 at 10:21 am
Have you checked the times on the servers? Make sure they're the same? I might look for some timing differences that cause things to delete. Even a few minutes over...
August 12, 2011 at 10:20 am
It sounds like you are on the ball with this one. I'd do the copy, and not add the complexity or possible issues from the open file read.
August 12, 2011 at 10:08 am
Is anyone here working with, or struggling to
- work in a complex development environment that does automated builds at high volumes (> 1x day)
- handle complex continuous development or...
August 12, 2011 at 10:07 am
Roy Ernest (8/12/2011)
Steve Jones - SSC Editor (8/12/2011)
Once again I feel like I've let too much time go without writing a book 🙁
Planning to write a book then? If so,...
August 12, 2011 at 10:02 am
OK, this has gotten slightly out of hand and away from the purpose of the thread, which is discussion the question.
I am closing the thread. The question had been edited,...
August 12, 2011 at 9:46 am
If you have it working, I'd go with the copy and then read. Especially if it's out of your control to change the process.
Alternatively, could you just read the data...
August 12, 2011 at 9:43 am
Note that the SQL files should still be consistent after a restart, but it might take some time for them to come online, for the reasons Gail outlined.
August 12, 2011 at 9:42 am
Lynn Pettis (8/11/2011)
I was going to wait until tomorrow night, but it is close enough.
I am resigning...
August 12, 2011 at 9:37 am
I would agree with Elliot. You are potentially asking for trouble here. How can you know what you're read, or more importantly, if anything's changed?
I'd make a copy, if only...
August 12, 2011 at 9:36 am
Brandie Tarvin (8/11/2011)
August 12, 2011 at 9:30 am
Viewing 15 posts - 15,421 through 15,435 (of 39,921 total)