up vote 4 down vote favorite
share [g+] share [fb]

I accidently deleted mssqlsystemresource.mdf and mssqlsystemresource.ldf.

I undeleted them both, but the .ldf file is corrupted (bad FGID), and because of this I can no longer start up my database instance.

There have never been any backups of the system databases. I have a database with a ton of data on it within this instance. I do have a week old backup of that data, but would rather not restore it.

Any advice on how to quickly get my instance up and running again?

link|improve this question
This is probably not ideal, but I copied the model and resource mdf and ldf files from another machine which had the same installer run on it and thing 'seem' to be working properly – cwyers Jan 29 at 16:55
Copying the resource DB (MDF+LDF) from the distribution media (the CD) should work, as well as copying it from an identical installation (same version). – Remus Rusanu Jan 29 at 20:58
If you can't get your instance back up then you can always reattach your database to a new instance using the data and log files. – squillman Jan 30 at 1:48
feedback

Know someone who can answer? Share a link to this question via email, Google+, Twitter, or Facebook.

Your Answer

 
or
required, but never shown
discard

Browse other questions tagged or ask your own question.