5,852 reputation
1623
bio website devopsfu.com
location United Kingdom
age 35
visits member for 2 years, 8 months
seen Nov 23 at 22:41

Mar
23
awarded  Yearling
Mar
12
revised How should my hosting provider handle SQL Server transaction logs?
deleted 8 characters in body
Mar
12
comment How should my hosting provider handle SQL Server transaction logs?
@Sergey you need to be clear what you mean by 'truncating the logs after full backup'. If you mean BACKUP LOG WITH TRUNCATE ONLY then this WILL break the log chain, even if done immediately after a full backup. Just for the sake of people reading this thread, we need to make a clear distinction between 'backing up the log' (which also truncates) and 'truncating the log using TRUNCATE_ONLY' which breaks the log chain.
Mar
12
comment How should my hosting provider handle SQL Server transaction logs?
I think we're getting our wires crossed here. When you refer to "truncating the log" what exactly do you mean? To me, manually truncating a t-log means issuing a BACKUP command WITH TRUNCATE_ONLY which will lose your log chain regardless of when you do it - even immediately after a full backup of the database itself.
Mar
12
comment How should my hosting provider handle SQL Server transaction logs?
The log is truncated when you back up the transaction log
Mar
12
comment How should my hosting provider handle SQL Server transaction logs?
If they do not truncate the log after a full backup they are - "not smart" - (manually) truncating the transaction log after a full backup will break the log chain and render the rest of the t-log backups useless! I think perhaps the way you've phrased it is a little ambiguous. t-logs should never be manually truncated - the act of taking a backup will truncate them.
Mar
12
comment How should my hosting provider handle SQL Server transaction logs?
I still have issues with your answer here - you say that there is no reason to keep the full log after a full backup, but if they intend to use log backup to allow point-in-time restores then the transaction log should never be manually truncated.
Mar
12
answered How should my hosting provider handle SQL Server transaction logs?
Mar
12
comment How should my hosting provider handle SQL Server transaction logs?
Manually truncating the log is definitely a no-no when it comes to the full recovery model. I'd check your info, but manually truncating will lose your ability to do a point-in-time restore
Mar
12
comment How should my hosting provider handle SQL Server transaction logs?
Taking a full backup truncates the log automatically, does it not? Manually truncating a log of a SQL Server database that is in full recovery mode will cause you to lose the log chain. Or am I missing something?
Mar
11
comment RDP using Windows CE 7 to Server 2008 R2
On the Windows Server, have you disabled the requirement for Network Level Authentication?
Mar
8
revised “Virtual” shared storage for SQL Server 2008 R2 Cluster
Removed information that wasn't provided by me in the first place. The previous edit should have been a separate answer.
Mar
1
comment Remove WSUS on Server 2012
Ah, nothing like the problems I had then! Once you've uninstalled the role, have you checked to make sure that the Windows Internal Database feature has been removed? If it's still there, you can connect to the instance using SQL Server Management Studio - if you see a SUSDB there then try deleting that.
Mar
1
comment Remove WSUS on Server 2012
Out of interest, what is the problem you're having with the installation? I had some issues with WSUS on 2012.
Feb
27
comment Shrinking Database using the AUTO_SHRINK ON , helpful or is it consuming to many resources?
brentozar.com/blitz/auto-shrink-enabled
Feb
27
answered Shrinking Database using the AUTO_SHRINK ON , helpful or is it consuming to many resources?
Feb
25
comment How do I set up my office network so unqualified domain names resolve as if they have a default suffix added?
I see what you mean. Is there any reason why your web server cannot have the single-label names bound to the relevant sites? You could, for example, bind the host header "www" to the same site as "www.mydomain.com"
Feb
25
comment How do I set up my office network so unqualified domain names resolve as if they have a default suffix added?
Do you not have a default DNS suffix set on your client machines?
Feb
14
comment How do I disable server side code on iis 7.5?
He says he needs to allow code on some sites but not others. This won't work in that scenario.
Feb
13
comment NSLookup resolves to local DNS, but browser resolves to public
If the clients are Windows machines, they may also be using NetBIOS broadcast name resolution or LLMNR which won't hit the DNS server, and may also give different results from nslookup