Forum Discussion
masters db corrupt
Hi, i install sp3 against a sqlserver 2016 .. at the end, i don't knnow why, the engine doesn't start because master db is corrupt .. It's not a pain because it's a simply test server but what is the best practice for recovery .. i have backup but how to restaure in a engine stop ?
Thanks
DAsnar13 , restoring the system database "master" is possible, but take some much more efforts. In the article Restore the master database (Transact-SQL) - SQL Server | Microsoft Learn is a step-by-step guide.
If everthing fails the the last ressort is to rebuild the system databases (first), to get SQL Server on the start again, see Rebuild system databases - SQL Server | Microsoft Learn
