Ask the Expert

Temporary database is full from a query

Our temporary database is full from a query, and we want to remove it without restarting SQL server. Is there any way to clear this? It is taking up 16 GB of disk space.

    Requires Free Membership to View

First off, evaluate your query and figure out why it is chewing up 16 GB of space. Rewriting it so that it doesn't do that is the first step. If you don't want the space in the file, just shrink the file.

This was first published in August 2004

There are Comments. Add yours.

 
TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: