How to restore SQL Server System Databases from TDP SQL

Before starting the procedure make sure you have note down the port number and the Collation on which your SQL Server is running, this can be seen in TCP\IP properties and even in registry as well shown below.

Default Instance


Named Instance

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server (InstanceName) \ MSSQLServer\ SuperSocketNetLib\TCP

For Collation refer below key

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.1\Setup

  1. Copy the SQL Server 2000 setup files on the Local Drive of the server from Segotn10063
  2. Run the Rebuildm.exe command as shown below

When you run this command below shown window will open

Now specify the server name, the location of the setup and the collation.

Click on the rebuild button.

    When you click on rebuild a new window will open “Configuring Server” mentioned below.

    The configuration will take some time and executes many steps during this procedure, wait till it completes.

    1. Close all SQL Related application\windows
    2. When the process completes start your SQL Service in Single user mode.

    SQLServr.exe –c –m –T3608

    1. Check all files TDP SQL related files like “dsm.opt”, instance.bat, tdpsql.cfg etc
    2. Open TDPSQL GUI
    3. Now start the process of restoring Master Databases as mentioned below using TDP SQL

    Overwrite the existing Master Database by using restore into option

    1. When the Master Database restore will finish your SQL Server stops and comes out from Single User Mode.
    2. Now when you start SQL Server you can see all user databases in suspect mode, as their respective files are missing.
    3. Now Restore Model Database using TDP SQL from the last backup available
    4. Now Stop SQL Server Agent, and restore MSDB database using TDP SQL (No Need to start SQL Server in Single User Mode)
    5. After restoration of MSDB start SQL Server agent.

    At this point you have now restored all SQL Server Logins and Jobs

    1. Now start restoring the user databases one by one using point in time recovery and with replace option.

    When all user databases were restored make sure that all user databases are accessible and run some select queries randomly on some tables.

    Note: Make sure that if it’s a reinstall and you don’t have a password for the service account run the SQL Services by LOCAL SYSTEM ACCOUNT not with your account. 


    Leave a Reply

    Fill in your details below or click an icon to log in: Logo

    You are commenting using your account. Log Out /  Change )

    Twitter picture

    You are commenting using your Twitter account. Log Out /  Change )

    Facebook photo

    You are commenting using your Facebook account. Log Out /  Change )

    Connecting to %s