SQL Server 2005

Re: My Sql Server DIED

HemantgiriGoswami — Fri, 11 Jan 2008 09:37:58 GMT

YOu may also try re-building you Master database

Re: My Sql Server DIED

LouVega — Sat, 05 Jan 2008 03:42:20 GMT

For future reference - bookmark this Microsoft KB Article as it may shed some light on what's going on

http://support.microsoft.com/kb/940126

Hope that helps!

Re: My Sql Server DIED

KarlShifflett — Fri, 04 Jan 2008 19:04:48 GMT

Marlon,

Master file corruption is very uncommon. I've never even heard of this before.

You may want to keep your SQL Error logs along with the System & Application logs and see if you can piece together what happened.

Re: My Sql Server DIED

MarlonGrech — Fri, 04 Jan 2008 17:48:37 GMT

hello guys,

thanks for the help... i will re install and let you know how it all ends :)

Thanks for the help

Re: My Sql Server DIED

KarlShifflett — Fri, 04 Jan 2008 13:44:35 GMT

Marlon & Chandana,

Sorry if I wasn't clear in my post.

Marlon, I would not recommend copying the Master.mdf file from another server. This will be a disaster.

I would copy your databases (not the system databases) to another directory and after the reinstall, copy them back to the desired data directory and reattach them.

Again, setting up a maintenance plan to back up your system and user databases is the best plan.

Re: My Sql Server DIED

ChandanaAthauda — Fri, 04 Jan 2008 06:23:04 GMT

As Karl said you can copy Master database from another server (master.mdf and mastlog.ldf) or you can get the master template from Installation package. Anyway, be careful when you do this. Coz, it may lead to occur some errors on tempdb database.

Re: My Sql Server DIED

KarlShifflett — Fri, 04 Jan 2008 01:31:14 GMT

Marlon,

That is the best thing at this point. Just copy your other databases and reattach them when you bring the new server back up.

I've never seen this before. Do you remember what you or the server was doing when your master go fouled up?

I always set up maintenance plans for all my databases, even on test systems. May want to consider doing this also.

Cheers,

Karl

My Sql Server DIED

MarlonGrech — Thu, 03 Jan 2008 23:44:29 GMT

Hello guys,

Today I tried to start the Sql Server service on my machine so that I can continue working on some database yet Sql Server decided to not start any more... This is the error I got from Event Log

"The log scan number (203:152:1) passed to log scan in database 'master' is not valid. This error may indicate data corruption or that the log file (.ldf) does not match the data file (.mdf). If this error occurred during replication, re-create the publication. Otherwise, restore from backup if the problem results in a failure during startup."

any ideas on what could be the cause?

I am going to just re install Sql Server to be on the safe side....(well safe side, that's my only option so...)

Regards