[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 266
  • Last Modified:

expanding tempdb & master

I would like to expand the database size of the Tempdb
and Master databases.  They both reside on the Master
device.  Do I need to start SQL Server in single user
mode to expand the Tempdb? Single user mode to expand
Master db?
0
jalymo
Asked:
jalymo
1 Solution
 
Victor SpiridonovCommented:
No you do not need single user mode to expand those databases, however if you want to shrink them, you will need to restart in single user mode. Also note, that tempdb can be expanded to any database device and master only if there is enough space on master device.
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now