tempdb full, and how can I prevent this from happening?

16 Dec

This beginning of week a Server with SQL 2000 the 20.0 GB available suddenly disappears without leaving a trace after some time seen the scenario we notice that tempdb.mdf it’s 17.0 GB of disk space.

Ref:http://sqlserver2000.databases.aspfaq.com/why-is-tempdb-full-and-how-can-i-prevent-this-from-happening.html

–evick

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: