Solved

expanding tempdb & master

Posted on 1998-08-10
1
237 Views
Last Modified: 2010-03-19
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
Comment
Question by:jalymo
1 Comment
 
LVL 7

Accepted Solution

by:
spiridonov earned 10 total points
ID: 1089512
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

What Security Threats Are You Missing?

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

758 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now