Viewing 15 posts - 391 through 405 (of 991 total)
Try creating your own database snapshot of msdb and then run DBCC CHECKDB on that. I think you're still going to run into the same issue, but it's worth a...
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 29, 2009 at 10:41 am
Excellent! Another problem bites the dust.
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 27, 2009 at 7:00 pm
Hmm - weird. How long are the pathnames to the database files?
Could be a privilege issue. Does the SQL Server service account have privileges to create files in the data...
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 27, 2009 at 6:06 pm
Do you have any read-only files or filegroups in the database? That would stop it.
Also, did a previous CHECKDB get killed for any reason? There could be a hidden database...
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 27, 2009 at 2:29 pm
Hmmm. Are any of the following true:
- you're running on a file system apart from NTFS
- you have zero free space on the drive hosting the database
I can't...
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 26, 2009 at 8:54 pm
ok - it's nothing to do with your hardware. And yes, it uses a snapshot in all versions of SQL Server.
I wrote DBCC CHECKDB for 2005 - if you post...
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 26, 2009 at 8:16 pm
That whatever is causing the problem has a periodicity of more than 3 days. You need to wait to see if it happens again.
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 22, 2009 at 2:26 pm
Which database are you trying to run CHECKDB against when you get the failure? There are more errors which explain why the snapshot could not be created - can 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
May 22, 2009 at 8:28 am
Don't know - but it's something in the IO subsystem (whether virtual or physical)...
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 20, 2009 at 2:35 pm
Power down SQL Server and the IO subsystem, then power them up again.
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 20, 2009 at 10:05 am
You've got corruption, and that's a known bug with database snapshots (which underpin DBCC CHECKDB) when that corruption occurs (sometimes).
See CHECKDB bug that people are hitting - Msg 8967, Level...
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 20, 2009 at 9:37 am
I don't know - totally depends on your IO subsystem vendor and what tools they provide.
I asked a few other MVPs for opinions and they all say the same thing,...
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 20, 2009 at 9:06 am
ok - looks like you've got something wrong with msdb (obviously 🙂 and it's in the IO subsystem - all operations are stalling waiting for reads to complete.
If the db...
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 20, 2009 at 8:41 am
You can't do a WITH TABLOCK CHECKDB of msdb (or master or tempdb) as that requires an exclusive database lock to run the allocation checks (equivalent of DBCC CHECKALLOC).
If it...
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 20, 2009 at 8:23 am
Best practice to start a new thread for each problem.
What happened to the database?
Please post the output from:
select state_desc from master.sys.databases
where name ='yourdbname'
If this is a time-critical issue, you should...
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 19, 2009 at 1:44 pm
Viewing 15 posts - 391 through 405 (of 991 total)