Viewing 15 posts - 436 through 450 (of 991 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.
Paul Randal
CEO, SQLskills.com: Check out SQLskills online training!
Blog:www.SQLskills.com/blogs/paul Twitter: @PaulRandal
SQL MVP, Microsoft RD, Contributing Editor of TechNet Magazine
Author of DBCC CHECKDB/repair (and other Storage Engine) code of SQL Server 2005
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...
Paul Randal
CEO, SQLskills.com: Check out SQLskills online training!
Blog:www.SQLskills.com/blogs/paul Twitter: @PaulRandal
SQL MVP, Microsoft RD, Contributing Editor of TechNet Magazine
Author of DBCC CHECKDB/repair (and other Storage Engine) code of SQL Server 2005
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 -...
Paul Randal
CEO, SQLskills.com: Check out SQLskills online training!
Blog:www.SQLskills.com/blogs/paul Twitter: @PaulRandal
SQL MVP, Microsoft RD, Contributing Editor of TechNet Magazine
Author of DBCC CHECKDB/repair (and other Storage Engine) code of SQL Server 2005
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...
Paul Randal
CEO, SQLskills.com: Check out SQLskills online training!
Blog:www.SQLskills.com/blogs/paul Twitter: @PaulRandal
SQL MVP, Microsoft RD, Contributing Editor of TechNet Magazine
Author of DBCC CHECKDB/repair (and other Storage Engine) code of SQL Server 2005
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...
Paul Randal
CEO, SQLskills.com: Check out SQLskills online training!
Blog:www.SQLskills.com/blogs/paul Twitter: @PaulRandal
SQL MVP, Microsoft RD, Contributing Editor of TechNet Magazine
Author of DBCC CHECKDB/repair (and other Storage Engine) code of SQL Server 2005
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?
Paul Randal
CEO, SQLskills.com: Check out SQLskills online training!
Blog:www.SQLskills.com/blogs/paul Twitter: @PaulRandal
SQL MVP, Microsoft RD, Contributing Editor of TechNet Magazine
Author of DBCC CHECKDB/repair (and other Storage Engine) code of SQL Server 2005
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...
Paul Randal
CEO, SQLskills.com: Check out SQLskills online training!
Blog:www.SQLskills.com/blogs/paul Twitter: @PaulRandal
SQL MVP, Microsoft RD, Contributing Editor of TechNet Magazine
Author of DBCC CHECKDB/repair (and other Storage Engine) code of SQL Server 2005
April 30, 2009 at 5:01 am
Can you post the exact T-SQL you're running that generates the error please?
Paul Randal
CEO, SQLskills.com: Check out SQLskills online training!
Blog:www.SQLskills.com/blogs/paul Twitter: @PaulRandal
SQL MVP, Microsoft RD, Contributing Editor of TechNet Magazine
Author of DBCC CHECKDB/repair (and other Storage Engine) code of SQL Server 2005
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...
Paul Randal
CEO, SQLskills.com: Check out SQLskills online training!
Blog:www.SQLskills.com/blogs/paul Twitter: @PaulRandal
SQL MVP, Microsoft RD, Contributing Editor of TechNet Magazine
Author of DBCC CHECKDB/repair (and other Storage Engine) code of SQL Server 2005
April 30, 2009 at 4:14 am
All the scripts are designed for use directly in a query window or through osql/sqlcmd.
Paul Randal
CEO, SQLskills.com: Check out SQLskills online training!
Blog:www.SQLskills.com/blogs/paul Twitter: @PaulRandal
SQL MVP, Microsoft RD, Contributing Editor of TechNet Magazine
Author of DBCC CHECKDB/repair (and other Storage Engine) code of SQL Server 2005
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...
Paul Randal
CEO, SQLskills.com: Check out SQLskills online training!
Blog:www.SQLskills.com/blogs/paul Twitter: @PaulRandal
SQL MVP, Microsoft RD, Contributing Editor of TechNet Magazine
Author of DBCC CHECKDB/repair (and other Storage Engine) code of SQL Server 2005
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.
Paul Randal
CEO, SQLskills.com: Check out SQLskills online training!
Blog:www.SQLskills.com/blogs/paul Twitter: @PaulRandal
SQL MVP, Microsoft RD, Contributing Editor of TechNet Magazine
Author of DBCC CHECKDB/repair (and other Storage Engine) code of SQL Server 2005
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...
Paul Randal
CEO, SQLskills.com: Check out SQLskills online training!
Blog:www.SQLskills.com/blogs/paul Twitter: @PaulRandal
SQL MVP, Microsoft RD, Contributing Editor of TechNet Magazine
Author of DBCC CHECKDB/repair (and other Storage Engine) code of SQL Server 2005
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...
Paul Randal
CEO, SQLskills.com: Check out SQLskills online training!
Blog:www.SQLskills.com/blogs/paul Twitter: @PaulRandal
SQL MVP, Microsoft RD, Contributing Editor of TechNet Magazine
Author of DBCC CHECKDB/repair (and other Storage Engine) code of SQL Server 2005
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...
Paul Randal
CEO, SQLskills.com: Check out SQLskills online training!
Blog:www.SQLskills.com/blogs/paul Twitter: @PaulRandal
SQL MVP, Microsoft RD, Contributing Editor of TechNet Magazine
Author of DBCC CHECKDB/repair (and other Storage Engine) code of SQL Server 2005
April 28, 2009 at 7:20 pm
Viewing 15 posts - 436 through 450 (of 991 total)