System tables deleted

  • HI

    I am working at a client site and they have found that someone has deleted the system tables MASTER, MODEL, etc for a SQL Server 8.00 running service pack 2.

    Does any one have ideas oin how to get the server up and running again.

    We do have backups from the night before of the SQL Server backup files but are having difficulties getting the master database created again and the SQL Server online.

  • Try rebuildm.exe utility . this should help you restore your master db.

    i would suggest you to check "startup options" in BOL.

  • Please do read about RebuildM before using it!

    Andy

    http://www.sqlservercentral.com/columnists/awarren/

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply