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?
jalymoAsked:
Who is Participating?
 
Victor SpiridonovConnect With a Mentor Commented:
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
All Courses

From novice to tech pro — start learning today.