SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


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

Author
Message
naga.rohitkumar
naga.rohitkumar
SSC Eights!
SSC Eights! (854 reputation)SSC Eights! (854 reputation)SSC Eights! (854 reputation)SSC Eights! (854 reputation)SSC Eights! (854 reputation)SSC Eights! (854 reputation)SSC Eights! (854 reputation)SSC Eights! (854 reputation)

Group: General Forum Members
Points: 854 Visits: 1378
How should i free up the space from the BACKUP Drive whcih is increasing Rapidly

Thanks
Rohit

Thanks
Naga.Rohitkumar
GilaMonster
GilaMonster
SSC Guru
SSC Guru (87K reputation)SSC Guru (87K reputation)SSC Guru (87K reputation)SSC Guru (87K reputation)SSC Guru (87K reputation)SSC Guru (87K reputation)SSC Guru (87K reputation)SSC Guru (87K reputation)

Group: General Forum Members
Points: 87681 Visits: 45272
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
naga.rohitkumar
SSC Eights!
SSC Eights! (854 reputation)SSC Eights! (854 reputation)SSC Eights! (854 reputation)SSC Eights! (854 reputation)SSC Eights! (854 reputation)SSC Eights! (854 reputation)SSC Eights! (854 reputation)SSC Eights! (854 reputation)

Group: General Forum Members
Points: 854 Visits: 1378
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
naga.rohitkumar
SSC Eights!
SSC Eights! (854 reputation)SSC Eights! (854 reputation)SSC Eights! (854 reputation)SSC Eights! (854 reputation)SSC Eights! (854 reputation)SSC Eights! (854 reputation)SSC Eights! (854 reputation)SSC Eights! (854 reputation)

Group: General Forum Members
Points: 854 Visits: 1378
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
GilaMonster
GilaMonster
SSC Guru
SSC Guru (87K reputation)SSC Guru (87K reputation)SSC Guru (87K reputation)SSC Guru (87K reputation)SSC Guru (87K reputation)SSC Guru (87K reputation)SSC Guru (87K reputation)SSC Guru (87K reputation)

Group: General Forum Members
Points: 87681 Visits: 45272
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
naga.rohitkumar
SSC Eights!
SSC Eights! (854 reputation)SSC Eights! (854 reputation)SSC Eights! (854 reputation)SSC Eights! (854 reputation)SSC Eights! (854 reputation)SSC Eights! (854 reputation)SSC Eights! (854 reputation)SSC Eights! (854 reputation)

Group: General Forum Members
Points: 854 Visits: 1378
THANKS AND MAY IKNOW UR PERSONEL MAIL ID AND UR DESIGNATION WHERE U WORK

Thanks
Naga.Rohitkumar
GilaMonster
GilaMonster
SSC Guru
SSC Guru (87K reputation)SSC Guru (87K reputation)SSC Guru (87K reputation)SSC Guru (87K reputation)SSC Guru (87K reputation)SSC Guru (87K reputation)SSC Guru (87K reputation)SSC Guru (87K reputation)

Group: General Forum Members
Points: 87681 Visits: 45272
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
Grant Fritchey
SSC-Forever
SSC-Forever (40K reputation)SSC-Forever (40K reputation)SSC-Forever (40K reputation)SSC-Forever (40K reputation)SSC-Forever (40K reputation)SSC-Forever (40K reputation)SSC-Forever (40K reputation)SSC-Forever (40K reputation)

Group: General Forum Members
Points: 40088 Visits: 32653
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

The Scary DBA
Author of: SQL Server Query Performance Tuning and SQL Server Execution Plans
Product Evangelist for Red Gate Software
naga.rohitkumar
naga.rohitkumar
SSC Eights!
SSC Eights! (854 reputation)SSC Eights! (854 reputation)SSC Eights! (854 reputation)SSC Eights! (854 reputation)SSC Eights! (854 reputation)SSC Eights! (854 reputation)SSC Eights! (854 reputation)SSC Eights! (854 reputation)

Group: General Forum Members
Points: 854 Visits: 1378
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
durai nagarajan
SSCommitted
SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)

Group: General Forum Members
Points: 1611 Visits: 2775
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
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search