Those commands will be issues and the file sizes will be modified in the catalog in the master database. The next time the service restarts, TempDB will be the size specified in the resize statements.

Master files contain descriptive data, such as name and address, as well as summary information, such as amount due and year-to-date sales. Contrast with transaction file. See master data management.

In the Restore Database window, select the database and the backup sets to restore, and press OK. How to Restore a Backup Using T-SQL Alternatively, you can use the T-SQL commands to restore a ...