How should i free up the space from the BACKUP Drive whcih is increasing Rapidly

  • How should i free up the space from the BACKUP Drive whcih is increasing Rapidly

    Thanks

    Rohit

    Thanks
    Naga.Rohitkumar

  • Delete or archive old backups that you don't need. Other than that, add more space to the drive.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass
  • Thanks for ta quick reply

    But we can't do so coz one [.Bak] file nearly 73 gb and free space available is 14 gb is there any possiblities that might cause next back file rapid increase and by which breakdown of logshipping chain

    Thanks
    Naga.Rohitkumar

  • another one in different server

    NEED to Reduce the space from the Drive in which Transactional log backups generates for every 10 mins in Tlbackup folder now it is occuping more space how to free the space from the Ls backup please gv reply

    Thanks

    Rohit

    Thanks
    Naga.Rohitkumar

  • Then you need to get more drive space. No miracle solutions, you need to either remove files you don't need or get extra space.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass
  • THANKS AND MAY IKNOW UR PERSONEL MAIL ID AND UR DESIGNATION WHERE U WORK

    Thanks
    Naga.Rohitkumar

  • No, not unless you're interested in hiring me.

    p.s. Your caps lock appears to be stuck

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass
  • naga.rohitkumar (8/11/2012)


    THANKS AND MAY IKNOW UR PERSONEL MAIL ID AND UR DESIGNATION WHERE U WORK

    Just curious, but that's a really odd question. Why do you need that in order to clean up disks?

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

  • 1.Actually the database backup drive which we use is occuping lost of space when the application team tryiing to crunch some records from [ex:abc database ]the table[nwe] then parelley the log which is scheduled for every 10 mins is 6 to 10 mb but at that time of crunching some records from the application the [.trn] Tlogbackups file size increasing rapidly upto 1.7 gb

    2. I tried to shrink the secondary file of "d:/nwe1.ndf" in size nearly 8gb in the drive totaly 15gb but free space is 1.58 gb

    3. I tried to shink the database online which is in fullrecovery model and performed manualy by right clicking it taken nearly 1hour bt not completed parllely i kkep a eye on E:\Tlogbackups (.trn) it is rapidly increased to 1gb in 30 mins for every 10mins

    4.Then i caused low disk space in E:\Tlogbackups drive i canceled the manual shrink window and tries to shink the log(.ldf) file then it succeed and then i chekd the primary(.mdf) performed shrink on it next on secondary (.ndf) file

    ----------------------------------------

    use [nwe]

    DBCC SHRINKFILE(nwe_Log, 0)

    GO

    -----

    DBCC SHRINKDATABASE with truncate_only

    ----

    DBCC SHRINKDATABASE (nwe);

    GO

    ----

    DBCC SHRINKDATABASE (nwe1,10);

    GO

    then is completed

    5. later informed the application team to put schedule job or trigger to delete the old records by that it cannot happen again

    Thanks

    Rohit

    Thanks
    Naga.Rohitkumar

  • why are you shrinking the DB which will cause the log to grow and index will be defragmented

    so you have to do reindexing after that which will again grow the log file.

    can you explain is log file backup is the one which is occupying 6 -10 MB as i coudnt get your explaination clearly sorry if it is my miss.

    what is the DB size and what is log file size on that and log backup and backup stratergy details.

    Regards
    Durai Nagarajan

  • I know it's been said that there are no magical solutions, but how about upgrading the server to use backup compression?

    PS. Could you avoid sms language?

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2
  • Need to increase the disk space.

    see what the retention period ,accordingly delete the .bkp file and free the space from the disk

    contact storage team to increased the space.

Viewing 12 posts - 1 through 11 (of 11 total)

You must be logged in to reply to this topic. Login to reply