A local temporary database can be accessed only by the local instance. Other server instances within the cluster cannot access this temporary database.
To view the temporary databases:
Select the Server Instances folder
Select the name of the instance.
Select Local Temporary Databases
Right-click the temporary database name to configure and maintain your local temporary database. Select the option to:
Open Interactive SQL – start a session with Interactive SQL.
Check Consistency – follow the instructions on the wizard to run the database consistency checker (dbcc) on the temporary database.
Checkpoint – select Yes to run a checkpoint on this database. Select Preview to view the currently running SQL.
Display Statistics – follow the instructions on the wizard to run optdiag on the temporary database.
Generate DDL – select Create Database DDL to view the currently running DDL. Select Exclude DDL to view of list of objects that you can exclude from the DDL. Check the objects to exclude and select OK.
Delete – select Delete to drop this temporary database. Select Yes to confirm. Because you cannot delete the last system temporary database, the Delete option is disabled if this is the only temporary database left.
Properties – select the appropriate pane for information about:
General – describes the type of database, the database owner (select Change to change the database owner), the date the database was created, the last time the transaction log was dumped, whether the database has a guest user, the type of data cache, the default database location, and whether to resynchronize the proxy tables.
Devices – lists the currently configured database devices. Select:
Add – to add a device. Select Data or Transaction Log on the Device Size window, and specify the device size. Click OK to confirm.
Remove – remove the device.
Edit – configure the device. The Device Size window lists the currently configured name, size, unused portion, current allocation, total space allocation, and allows you to add space to the device.
Move Log – specify a new location for the log device.
Properties – includes four panes describing general information, mirror device status, databases located on this device, and segment information.
Usage – details the space the database uses. Select the unit in which to display the information: Pages, KB, MB, or GB.
Transaction log – allows you to configure the bindings, log IO size, and segments that use last-chance thresholds.
Options – lists the database options you can set for this database. Check or uncheck the options and click OK.
Active sessions – displays SPID and login information for the sessions assigned to this database.