October 15, 2007 at 8:04 pm
Hi Everyone,
We had some torn pages reported in one of our user databases, and now the master database is reporting I/O errors (torn pages and bad id pages). Problem is, when I try to start SQL Server in single user mode to restore the master database, I get the following error: "The system is older than SQL Server 7.0 RTM version and is not supported by this server". We are on S2k SP4. Any ideas on what to do? I don't really want to uninstall/reinstall SQL Server, but this might be my only option....
thanks.
October 15, 2007 at 9:11 pm
Check out this article on rebuilding and restoring the master DB.
http://articles.techrepublic.com.com/5100-1035_11-5025441.html
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
October 15, 2007 at 9:39 pm
You may want to do the following steps:
1) Stop the SQL services
2) Restore master database from the latest backup
3) Start the SQL services
4) sp_detach_db for all user databases
5) sp_attach_db for all user databases
October 15, 2007 at 9:48 pm
thanks very much for this article.....I'm sure this will work!
October 16, 2007 at 7:18 pm
One thing to do before restoring master - figure out why the errors happened in the first place. If you took a power failure and you have caching turned on in the drives then fair enough - you'll likely get torn pages. If not, then there's something more insidious going on and its likely to happen again if you just restore to the same hardware.
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
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply