Viewing 15 posts - 931 through 945 (of 991 total)
My guess is that someone took a copy of master at some point, moved it to your database's location and attached it under a different name. No database can be...
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
September 24, 2007 at 8:57 am
How are you trying to restore the database?
What happens if you try to restore it using T-SQL?
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
September 24, 2007 at 8:53 am
The problem is that they detached the database while it was suspect. Suspect means that recovery could not run for some reason. When you attach a database that has not...
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
September 23, 2007 at 12:02 pm
Can you do the following and let me know the output you get?
ALTER DATABASE PIS SET ONLINE -- this should try to run recovery, fail and put the database into...
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
September 19, 2007 at 11:49 am
Well, you have at least one corrupt page in the database that's being hit during recovery. This means you can't access the database unless you put it in emergency mode...
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
September 18, 2007 at 11:20 am
There will definitely be a SQL Server 2008 Express Edition.
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
September 12, 2007 at 7:24 pm
This is almost certainly a bug in DBCC CHECKCONSTRAINTS - please contact Product Support (http://support.microsoft.com/sql).
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
September 12, 2007 at 7:12 pm
Your sysindexes table is corrupt. From the call stack in the dump, its failing trying to delete a statistics blob column in sysindexes. You should run DBCC CHECKDB to find...
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
September 12, 2007 at 7:10 pm
Looks like you've got some corruption which is causing the server to misbehave. What's the output of "dbcc checkdb (yourdb) with all_errormsgs, no_infomsgs"?
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
September 12, 2007 at 7:07 pm
The only way for you to fix this is to restore from a backup as this type of system table corruption won't be fixed by CHECKDB in SQL 2000 (which...
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
September 12, 2007 at 7:04 pm
This is bad advice - if the non-clustered indexes are enforcing constraints, dropping them allows operations that could break the constraint and then you wouldn't be able to recreate 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
September 12, 2007 at 7:00 pm
That's terrible advice. You're advocating always choosing to lose data rather than restore from a backup. Why take backups if you're happy running repair?
Unless you have serious downtime constraints and...
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
September 12, 2007 at 6:58 pm
You need to detach the damaged MSDB before running the instmsdb.sql script. And yes, restoring from your backup would be the best 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
September 12, 2007 at 6:55 pm
You should restore from your backups. As the output from CHECKDB clearly states, REPAIR_ALLOW_DATA_LOSS is what's needed to repair these errors so its no surprise that none of the other...
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
September 12, 2007 at 6:54 pm
Can you post the exact command you issued and the exact error messages that were output?
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
September 12, 2007 at 6:45 pm
Viewing 15 posts - 931 through 945 (of 991 total)