Viewing 15 posts - 8,146 through 8,160 (of 49,571 total)
Yes they are, but they're very well tested and very comprehensive
August 12, 2014 at 7:23 am
Do you have every single transaction log backup from the Monday full backup up to now? Every single one without a gap?
Has the database been set to simple recovery at...
August 12, 2014 at 7:22 am
To be honest, I'd say ditch your custom script and just use the one at http://ola.hallengren.com/
August 12, 2014 at 7:02 am
I thought you meant it was still running. No, there isn't any history of that kind of thing. After the fact it's near-impossible to figure out why something ran long...
August 12, 2014 at 6:55 am
All the comments I made in the previous thread still stand.
This should be an INSTEAD OF trigger, not an AFTER
The trigger as written will not handle any insert or update...
August 12, 2014 at 6:54 am
Any blocking? What's the process waiting for?
August 12, 2014 at 6:29 am
A little old, but still mostly valid
August 12, 2014 at 5:12 am
- Win (8/12/2014)
Log file size did not changed, it is the same size...
No, it won't, because checkpoint doesn't shrink log files.
It may however have freed some space internally
Can you please...
August 12, 2014 at 4:44 am
- Win (8/12/2014)
Making offline and online DB helps ?
NO!
Never take a DB offline if it's showing any kind of errors like this.
Making DB to Full, backup, then revert to...
August 12, 2014 at 3:08 am
Beatrix Kiddo (8/12/2014)
You know everybody can read this thread, right? It was an honest mistake and I apologised immediately. Is this really necessary?
Is what really necessary?
August 12, 2014 at 2:58 am
Beatrix Kiddo (8/12/2014)
Try increasing the autogrowth then trying the backup again.
When the drive the files are on is full? How would that help?
August 12, 2014 at 2:50 am
The log could have grown for any number of reasons. Large transaction, replication, CDC, lack of a checkpoint, active backup, couple of others.
Can you shrink the log a little?
If not,...
August 12, 2014 at 2:48 am
So three days after implementing replication, I have a pile or replication-related errors on my desk (cannot truncate table because it's replicated, lob size exceeds max replicated text size)
How the...
August 12, 2014 at 2:45 am
The temp table will be dropped as soon as the procedure that created it ends, whether it ends successfully or not does not matter. There's nothing you need to do,...
August 12, 2014 at 2:41 am
No.
The NoCheck option means that the old data is not checked for compliance with the constraint and therefore cannot be trusted. If you want the constraint trusted, you need to...
August 12, 2014 at 1:13 am
Viewing 15 posts - 8,146 through 8,160 (of 49,571 total)