Step 4: Re-create device allocations for master

If more than one row for dbid 1 appears in your hard copy of sysusages, you need to increase the size of master so that you can load the dump. You must duplicate the vstart value for each allocation for master in sysusages. This is easiest to do if you have a copy of sysusages ordered by vstart.

In the simplest cases, additional allocations to master require only the use of alter database. In more complicated situations, you must allocate space for other databases to reconstruct the exact vstart values needed to recover master.

In addition to the master database, tempdb (dbid = 2 ) and model (dbid = 3) are located wholly or partially on the master device.