Viewing 15 posts - 226 through 240 (of 991 total)
eh.shams (2/27/2010)
Hello , Please Help me to solve problem
First off - this is a volunteer forum, not a service you're paying for - so don't hassle people to hurry up...
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
February 28, 2010 at 9:36 am
Note: This question was written by Kimberly.
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
February 28, 2010 at 8:22 am
CHECKDB of tempdb on 2000 doesn't really do much - so unsurprising it doesn't show any errors.
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
February 26, 2010 at 6:48 am
No problem. I really need to get around to writing a really detailed, comprehensive guide to corruption - nothing out there right now.
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
February 25, 2010 at 7:34 am
For the page latch message - when the final PFS page at the end of the file is damaged (which could be the case here), I couldn't tell how many...
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
February 25, 2010 at 6:39 am
Ah - forgot we were in the 7.0/2000 forum. Indeed - I rewrote most of that code for 2005 - removing all kinds of weird behavior.
No workaround I'm afraid, except...
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
February 22, 2010 at 9:08 am
Hmm - it works perfectly well for me on an SP3 system...
create database foo
go
use foo
go
create table t1 (c1 int identity, c2 int)
go
insert into t1 values (1)
insert into t1 values (2)
go
alter...
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
February 20, 2010 at 10:41 am
Repair_rebuild fixes problems with non-clustered indexes, including forcing index rebuilds to rescan the base table.
What are the corruptions? (i.e. output from DBCC CHECKDB (yourdb) WITH NO_INFOMSGS, ALL_ERRORMSGS
Thanks
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
February 19, 2010 at 5:15 pm
But that is expected behavior - the RESEED has to update the system catalogs to reflect the new next-identity value - which it can't do on a read-only databaase.
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
February 19, 2010 at 3:21 pm
nilmov (2/18/2010)
Restoring a old master and dropping the DB or rebuild system database is a good option
Why on earth would you advise doing that? You don't even know why the...
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
February 18, 2010 at 7:05 pm
I just created your scenario and I had no problem dropping the database using a DROP DATABASE command. 2005 SP3.
What method are you trying to use and what error do...
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
February 18, 2010 at 6:23 pm
Well, the output from sys.databases tells you why the log can't clear. For instance, if it says LOG_BACKUP it means you've got to take a log backup before the log...
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
February 17, 2010 at 12:10 pm
No idea. At this point you should call Product Support to help 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
February 16, 2010 at 4:38 pm
Here's the link you need to rebuild them: http://msdn.microsoft.com/en-us/library/dd207003.aspx
Never, never, never detach a suspect 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
February 16, 2010 at 4:08 pm
Automatically creating a new log file is only possible when the database is cleanly shutdown - otherwise the database knows that it needs the log file to run crash recovery.
If...
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
February 15, 2010 at 12:31 pm
Viewing 15 posts - 226 through 240 (of 991 total)