Posts
Sort by recent activity
DBCC TRACEOFF 3604 messages going to the errorlog
Hi guys,
DBCC TRACEON / TRACEOFF 3604 messages are going to the error log every couple of seconds. It is a nightmare if you need to look for something in the error log. Is there anyway to prevent t...
Cache management
In version 3.9 we used to have a cache management (or something of that kind) where we could setup witch SQL instances to ignore and other cache related settings.
In version 4 I only see "Refresh S...
My 5 cents tip (you might know it already, but just in case)
I like to combine the SQL Prompt code snippets with the SQL Server Management Studio templates. I always liked the template (kind of the same idea of snippets) but SSMS lacks the ability of "callin...
Restore Backup failed on a Active-Passive Cluster
Firstly I was very impressed with the speed and level of compression (300GB database was compressed into 45GB in just 20 minutes.
Then I tried to restore but after about 10 minutes it failed with a...
WITH COPY_ONLY option
Where on the wizard is this option? I can't find it when creating a backup.
At the last step of the wizard it does show the script but it is read-only, so I have to copy it and paste to SSMS, add t...