INF: Starting with Minimal Configuration Removes Tempdb Fragment

• Microsoft SQL Server, version 6.5

SUMMARY

If you expanded tempdb from the default device (master device) on additional devices, only the 2 MB tempdb on the master device exists if you start SQL Server in minimal configuration (using the -f option). The additional fragments are removed.

Because the additional physical device files for tempdb still exist in SQL Server, you only have to expand tempdb again on these devices to get the former size.

MORE INFORMATION

The following illustrates the behavior. After the installation of SQL Server, you have a default tempdb with a size of 2 MB on the master device.

If you create an additional device of 10 MB and alter the size of the tempdb (dbid 2) on this device, you have the following entries in the sysusages system table:

   dbid       segmap       lstart       size       vstart
   ----------------------------------------------------

     2          7            0          1024       2564
     2          7            1024       5120       83886080

Now open a command prompt session and start SQL Server in minimal configuration mode with the following command:

   sqlservr -c -f

In the sysusages system table, the change is reflected. There is only one entry for the tempdb, indicating a size of 2 MB on the master device. This is exactly the default entry that also exists after a new installation of SQL Server.

   dbid       segmap       lstart       size       vstart
   ------------------------------------------------------

     2          7            0          1024       2564