Reputation
6,161
Top tag
Next privilege 10,000 Rep.
Access moderator tools
Badges
5 17
Newest
 Yearling
Impact
~270k people reached

Feb
24
awarded  Yearling
Dec
2
comment How can I create notification on user's connecting to database?
Do you have a backup of msdb from before the "cleaning"?
Sep
30
awarded  Explainer
Sep
29
revised How to get more information from dm_exec_query_stats
added 259 characters in body
Sep
29
answered How to get more information from dm_exec_query_stats
Sep
24
awarded  Autobiographer
Jun
9
comment Create a result for a line chart with dates
The risk on 2/21 is not 26. Instead it is unknown. Therefore you should not plot a 26 either. Just plot the dates that the measurements were taken on and leave gaps for the other days.
May
23
comment Shrinking large DB file not working
It is the primary filegroup...
May
21
answered How to restore symmetric key on the new database?
May
18
comment Shrinking large DB file not working
@JamesAnderson, can't right now as a full backup is currently running. That will probably take until Tuesday... However. There is log shipping setup and we do not use any of the other log reuse preventing technologies, so this should not be an issue.
May
18
comment Shrinking large DB file not working
@swasheck, yes. In fact most of the files is BLOB data (including the last extent)
May
18
comment Shrinking large DB file not working
@MatanYungman, I did, to no avail. The last extent of the file is in use...
May
18
asked Shrinking large DB file not working
May
6
awarded  Nice Answer
May
2
answered DDL statements being commited within transaction
May
1
comment Restricting users to COPY ONLY backups
Well, I guess I did not read the question completely. The OP's concern is the log-chain, so your solution works.
May
1
comment Restricting users to COPY ONLY backups
Kin, you are incorrect. A full backup resets the differential pointers. If the full backup than is lost e.g. because it was only meant to be a temporary, differentials take afterwards cannot be restored. Full and Log backups do not in any way interact. (But a lost Log backup will still break the log-chain.)
Apr
21
answered Possibly tempdb out of space or a system table is inconsistent
Apr
15
answered Get first login-Hit on huge table
Mar
21
answered SQL Server sp_addrolemember in stored procedure for different database