Solved

temp db in sql server

Posted on 2011-02-24
2
256 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

Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

Join & Write a Comment

     When we have to pass multiple rows of data to SQL Server, the developers either have to send one row at a time or come up with other workarounds to meet requirements like using XML to pass data, which is complex and tedious to use. There is a …
Hi all, It is important and often overlooked to understand “Database properties”. Often we see questions about "log files" or "where is the database" and one of the easiest ways to get general information about your database is to use “Database p…
This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're looking for how to monitor bandwidth using netflow or packet s…
In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're interested in additional methods for monitoring bandwidt…

760 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

20 Experts available now in Live!

Get 1:1 Help Now