Alert :Disk is full ,As a DBA,What will you do?

1.Find out the free space in the drives by 

XP_FIXEDDRIVES


2.Check the free space in the mdf and ldf for all databases to shrink.
if free space available,shrink the mdf or ldf as like below image.



3.Check for any unarchived backup files available in the drive,if so,ask Archive team to fire a full backup.

4.Check which database has free space by 

or 



Thats'it

Hope you will clear the drive to get free space...


Comments

Popular posts from this blog

SSIS2008R2 Error: 0xC0209303 at Package:

SQL2008R2 Error: The remote copy of database "XXXXX" has not been rolled forward to a point in time that is encompassed in the local copy of the database log. (Microsoft SQL Server, Error: 1412)