Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Orioles
Starting Member
2 Posts |
 Posted - 2009-02-09 : 04:04:23
|
I know that ms sql 6 is a obsolete sql software. The reason why I used this sql in WinNT OS is because we have an enrollment system application that work in this machine and can only support this type of version as what Ive known.Before, this machine was working properly for more than 5 years and never been reformatted. Time has come that it crash the whole OS even due to often brown outs. I tried to fix or recovered but things was going worst.I only covered the folder on drive c:\mssql and other some database late backup files.Since the os wont boot to normal. I decided to re-install the WinntOS 4.0 using other Hard Drive. Fresh installation with sql 6.5. I was thinking that the backup database is easily to restore in sql 6.5 but it was not.During the restoring, I got this message " The database you are attempting to laod was dumped running on this server sort order (41) than the one currently running on this server (51) at least one of them s not binary sort order"I read how to rebuild database, change the file name database to database.srt and start rebuilding database as it's instructed. While on process I received an error "The master database could not be successfully rebuilt charset.exe could not be executed. Please check the relevant. out file.I installed the SQL correctly. But why i can't even restore the database ? and I still getting this error My head really aching for weeks. Search the internet to find any luck, chat with friends but still didn't find any solution.Now I am begging for those experts to please give some advice or ideas to figured out and solve my problem. I know how it feels doing things that you think that there no more hope.Thanks in advance. |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-02-09 : 16:14:32
|
| See this:http://www.dbforums.com/microsoft-sql-server/503296-sort-order-sql-server-6-5-a.html |
 |
|
|
Orioles
Starting Member
2 Posts |
Posted - 2009-02-10 : 09:35:02
|
sodeep, Your sooooo brilliant helping me finding a good suggestion and solution..I never thought that's i can solved this problem. I really owe you this helped...how i wish i could give you a complement for this big help for me and my entire career. I was about to give up due to lack of manual i gathered and info i get to this web. But thanks God that there are really good in searching and finding ways where we can find a good solution..and your one of them!Thanks a lot dude, I was really happy after i successfully restored the database and used the system.  I will be hanging here around to see some more tips. Thanks again for the link. |
|
|
|
paulrandal
Yak with Vast SQL Skills
899 Posts |
Posted - 2009-02-10 : 09:53:51
|
| And as soon as you can, upgrade to a supported version - unless you have an app that absolutely can't be changed to run on a later version, things are much easier.Paul S. Randal, Managing Director, SQLskills.com (www.SQLskills.com/blogs/paul)SQL Server MVP, Contributing Editor of TechNet MagazineAuthor of SQL 2005 DBCC CHECKDB/repair codeAuthor & Instructor of Microsoft Certified Master - Database course |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-02-10 : 10:25:40
|
quote:
Originally posted by Orioles
sodeep, Your sooooo brilliant helping me finding a good suggestion and solution..I never thought that's i can solved this problem. I really owe you this helped...how i wish i could give you a complement for this big help for me and my entire career. I was about to give up due to lack of manual i gathered and info i get to this web. But thanks God that there are really good in searching and finding ways where we can find a good solution..and your one of them!Thanks a lot dude, I was really happy after i successfully restored the database and used the system. I will be hanging here around to see some more tips. Thanks again for the link.
You are most Welcome |
|
|
|
|
|
|
|
|
How to Restore sql 6 database