Wednesday, August 7, 2013

[MS SQL Server] master database corrupted after upgraded?

[MS SQL Server] master database corrupted after upgraded?

master database corrupted after upgraded?

Posted: 06 Aug 2013 07:52 PM PDT

Hi,Master database was corrupted after upgraded to enterprise edition and updated SP3.I had done IN-PLACE UP-gradation method as below steps..Old Edition1. Windows server 2008 enterprise edition with SP1(32 bit)2. SQL SERVER 2008 standard edition with SP1. (32 bit)new edition1. Windows server 2008 enterprise edition with SP1(32 bit)2. In place upgrade edition thru SQL 2K8 setup (which is enterprise edition), it was successfully completed then connected SSMS and checked Enterprise edition updated and all the SQL related services were running.3. Updated service pack 3, it was also successfully updated after that I took restart the server.4.After restart the server SQL Service not started due to master database corrupted and error message appear in the event viewer.5.Tried to rebuild that master database but it was not successful due to user SA existing password not accepted while rebuilding database.6.Finally I restored system image FULL backup and started working with old standard edition..(by taking 3rd party tool)I noticed that master database corrupted due to applying SQL SP3… also tried to uninstall SP3 that was not happed due to asking setup CD for removing SP3.All above steps done at Development server, it was working fine and there was no issues and errors.I am facing issues in production server.. how come issues was happened? Could you suggested me, how to resolve in feature?what are the steps need to be followed the Troubleshooting?1. I have verified startup parameter files location in configuration manager.2. Service account need to be check3. Rebuild the database thru command promptThanks & RegardsAnanda
Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Search This Blog