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.
Subscribe to:
Post Comments (Atom)
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...
-
RAID Levels:- RAID 0:- RAID 0 is known as disk striping. This RAID 0 stripes data across disks in the array, means , data will be equ...
-
AlwaysON Availability Groups has been introduced with SQL Server 2012 and has been a very popular and most used feature as it provides both ...
-
Troubleshooting replication errors can be frustrating without a basic understanding of how transnational replication works. The first ste...
No comments:
Post a Comment