Viewing 15 posts - 436 through 450 (of 994 total)
Are you running 64 or 32 bit? And what Edition of SQL Server? Standard?
I'm wondering if you're getting memory paged out while CHECKDB is running.
May 8, 2009 at 7:19 pm
Which SP level of 2005 are you at? There was a bug that could possibly cause this: http://kbalertz.com/949199/Error-message-queries-database-SNAPSHOT-isolation-level-enabled-Server-deallocate.aspx
In terms of why it takes a long time to run - what...
May 7, 2009 at 6:05 pm
Well first off, you only need to run the CHECKDB part - it does all the other stuff too.
By running too long, you mean it's running longer than usual -...
May 7, 2009 at 8:13 am
Neat - but ATTACH_REBUILD_LOG only works if the databases wasn't cleanly shutdown - so your msdb must have been. I wonder why it thought it was suspect then - suspect...
May 1, 2009 at 7:15 am
Nope - it doesn't take locks in 2000 either and your description of the algorithm is way off - it scans the transaction log for changes and reconciles them with...
April 30, 2009 at 1:33 pm
That syntax should work fine on SQL 2005. Can you do a select @@version in the same script and send all the results?
April 30, 2009 at 5:12 am
That tells me you're not running on SQL Server 2005 - as does the name of your backup file.
There are two corruption forums - one for 2005+ and one for...
April 30, 2009 at 5:01 am
Can you post the exact T-SQL you're running that generates the error please?
April 30, 2009 at 4:32 am
It never checks the log file - there isn't anything in SQL Server that you can run that will check the log file in the same way as DBCC CHECKDB...
April 30, 2009 at 4:14 am
All the scripts are designed for use directly in a query window or through osql/sqlcmd.
April 29, 2009 at 9:49 am
Hmm - that's right - msdb can't be put into emergency mode using the ALTER DATABASE syntax. To get it to work you'll need to update the system tables manually...
April 29, 2009 at 8:34 am
Basically no. Unless you can force it to restore using WITH CONTINUE_AFTER_ERROR - that's your last option.
April 29, 2009 at 8:30 am
Nope - just be aware that when you restore it, the database will be in the same state as when you backed it up - i.e. it will be in...
April 29, 2009 at 6:12 am
Well, first off you probably are going to lose some data from the database being suspect - that's what backups are for. You've probably already realized this, but if you...
April 28, 2009 at 7:23 pm
Btw - you've got corruption in your database and you may be looking at data loss. Why are you waiting for a maintenance window to run CHECKDB? You need to...
April 28, 2009 at 7:20 pm
Viewing 15 posts - 436 through 450 (of 994 total)