Viewing 7 posts - 1 through 7 (of 7 total)
yes so sorry; it doesn't break the log chain, it breaks my diff chain. How quickly we forget sometimes. I will bury my head in the sand later.
August 13, 2014 at 10:05 am
App does not run as SA, but it does run with a db_owner permission of it's own database(cringe, I know) some developers just like to watch the world burn when...
August 13, 2014 at 9:44 am
Full backups that do not use the 'COPY_ONLY' option do indeed break the log chain; am I missing something here? It has always been that way as far as...
August 13, 2014 at 9:42 am
Yes I have the differentials. I have a very thorough backup strategy across the corporate infrastructure; Differentials every 6 hours, Log backups hourly. All sorts of maintenance.
August 13, 2014 at 9:21 am
Worst. Question. Ever.
Now I know that you toggle results to text with a simple CTRL-T. I also know that CTRL-G is going to bring up a goto line number...
June 6, 2014 at 9:01 am
Unless of course the rules for SSIS are different than TSQL...I haven't used it all that much.
May 28, 2014 at 9:10 am
The answer to this question is incorrect; technically speaking.
The double quote characters are going to throw a syntax error when this is run. The statement should be using single...
May 28, 2014 at 9:07 am