August 7, 2013 at 2:52 am
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 Edition
1.Windows server 2008 enterprise edition with SP1(32 bit)
2.SQL SERVER 2008 standard edition with SP1. (32 bit)
new edition
1. 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 check
3. Rebuild the database thru command prompt
Thanks & Regards
Ananda
August 7, 2013 at 7:43 am
Is this production that's down now?
Do you have backups of all of your databases?
Do you have the ability to reinstall SQL if needed?
.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply