Viewing 8 posts - 1 through 8 (of 8 total)
Passing in a comma separated list of recipients is good and well if you were hard-coding them, but it would become more work if it were queried from a table....
July 12, 2013 at 2:51 pm
Actually you need to run a full backup AFTER truncating the transaction log in order for the tlog backups to run because you have broken the log chain.
July 26, 2012 at 3:19 pm
As mentioned in previous posts the methods described in the article are quite drastic and the article IMHO should caution readers and describe possible unintended side affects. "Resetting" replication...
July 26, 2012 at 3:12 pm
Great question. If I wanted to start performing tlog backups on a database yesterday I would automatically run a full backup after setting to full recovery model. Today...
June 28, 2012 at 4:05 pm
Great question! You'd be surprised to know how many SQL developers think if any error is encountered within a transaction it automatically gets rolled back like when XACT_ABORT is...
May 24, 2012 at 11:16 am
Good question. Didn't know about the WITH TIES clause.
April 13, 2012 at 10:59 am
My 2 cents... The question is either ambiguous or the answer is wrong. I know that you can't a FK constraint across databases. My interpretation of a...
April 9, 2012 at 9:08 am
Viewing 8 posts - 1 through 8 (of 8 total)