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

Question

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

naga.rohitkumar

SSCertifiable

Points: 5738
More actions
August 11, 2012 at 2:44 am

#265814

How should i free up the space from the BACKUP Drive whcih is increasing Rapidly
Thanks
Rohit
Thanks
Naga.Rohitkumar

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

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

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 1

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

naga.rohitkumar SSCertifiable Points: 5738 More actions · Answer 2

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

naga.rohitkumar SSCertifiable Points: 5738 More actions · Answer 3

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

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 4

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

naga.rohitkumar SSCertifiable Points: 5738 More actions · Answer 5

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

Thanks
Naga.Rohitkumar

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 6

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

Grant Fritchey SSC Guru Points: 398882 More actions · Answer 7

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

naga.rohitkumar SSCertifiable Points: 5738 More actions · Answer 8

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

durai nagarajan SSCoach Points: 15778 More actions · Answer 9

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

Luis Cazares SSC Guru Points: 183706 More actions · Answer 10

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

shrishasqldba SSC Journeyman Points: 83 More actions · Answer 11

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.