October 11, 2012 at 10:08 am
I got issue with sql server services stopped state and found master.mdf file was missed in the drive. Is it possible to up the server if we place the same master.mdf to the same location?
Please give me suggestion on this because this server is in production environment. And tell how to rebuil/reconstruct the sql server in this situation.
Thanks in advance.
October 11, 2012 at 11:24 am
You'd have to replace the master.mdf and master.ldf, and if you do so you will lose all logins, server-level permissions, linked servers and a bunch more. Got a backup of master?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply