Working on Disk space issue...

Working on Disk space issue...

1. login into the server.

verify below options..

Disk space issue
==============
1. old installation files and service pack files
2. data and log files has to be verify.
3. backup files.
4. error log size
5. sqlagent.out files.

suppose LDF files taking more space
=======================
in 2000, 2005
-------------------
option 1:
-------------
1. we can truncate the log and then shrink it.(urgency)
backup log dbname with truncte_only.
dbcc shrinklog(filename,300).

full backup database.

2008,2005,2000
=============
option 2:best option
-------------
1.take the log backup.
2.shrink.
in 2008 truncate option is not availble.

old backps are there in the disk
========================
1. delte od backup or move it another folder where space availble.