Re: Disk space usage
- From: "luna" <luna_s@xxxxxxxxxxx>
- Date: Wed, 22 Aug 2007 16:37:00 +0100
It sounds like you have a few different things you need to configure.
To answer your initial question, you can use the performance monitor
to alert you when you're low on disk space. Run PERFMON, then use the
"Performance Logs and Alerts" Tab. The counter you'll want is
LogicalDisk/% Free Space. Perfmon doesn't allow you to send emails by
default, but you can use a simple command line mail program if you
need. The rest is fairly self explanatory.
Your log files sound like they've never been shrunk and have just been
growing for the life of the database. You have a couple options here
- At this point, you're probably best backing up the database itself
and running a Backup Log with NO_LOG statement to truncate the log.
If you need to save the transaction log for recovery purposes, then
you can specify a backup location and exclude the NO_LOG statement,
but you've got quite a space hog right now.
Afterwards, run a DBCC SHRINKFILE on the name of the log file and
specify a size, in megabytes, the reduce the actual physical size of
the log.
thanks for the tips, ill see how i get on
-mark
.
- References:
- Disk space usage
- From: luna
- Re: Disk space usage
- From: Jeff
- Disk space usage
- Prev by Date: Re: Script to Generate Create Table DDL
- Next by Date: Re: Script to Generate Create Table DDL
- Previous by thread: Re: Disk space usage
- Next by thread: Re: Fix - Service Broker is disabled.
- Index(es):
Relevant Pages
|
