Tuesday, March 10, 2015

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.

No comments:

Post a Comment

COMMON SQL SERVER BACKUP FAILURE ERRORS AND ISSUES

  One of the most common task for a DBA’s are to perform installation of new SQL Server versions and installing patches. Most often or not e...