Solved

temp db in sql server

Posted on 2011-02-24
2
285 Views
Last Modified: 2012-05-11
Why will the TempDB become full, and what will you do if it
happens?
0
Comment
Question by:sqlcurious
2 Comments
 
LVL 13

Accepted Solution

by:
Rick earned 500 total points
ID: 34971164
0
 
LVL 9

Expert Comment

by:mayank_joshi
ID: 34978512
use the following script to shrink tempdb:-

USE [tempdb]
GO
DBCC SHRINKDATABASE(N'tempdb' )
GO
0

Featured Post

The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

821 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