Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

How should i free up the space from the BACKUP Drive whcih is increasing Rapidly Expand / Collapse
Author
Message
Posted Saturday, August 11, 2012 2:44 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Thursday, July 10, 2014 11:09 PM
Points: 549, Visits: 1,181
How should i free up the space from the BACKUP Drive whcih is increasing Rapidly

Thanks
Rohit


Thanks & Regards
NAGA.ROHITKUMAR
Post #1343762
Posted Saturday, August 11, 2012 3:17 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 10:05 AM
Points: 42,829, Visits: 35,961
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 2008, MVP
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

Post #1343768
Posted Saturday, August 11, 2012 4:05 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Thursday, July 10, 2014 11:09 PM
Points: 549, Visits: 1,181
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 & Regards
NAGA.ROHITKUMAR
Post #1343773
Posted Saturday, August 11, 2012 4:06 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Thursday, July 10, 2014 11:09 PM
Points: 549, Visits: 1,181
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 & Regards
NAGA.ROHITKUMAR
Post #1343774
Posted Saturday, August 11, 2012 4:33 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 10:05 AM
Points: 42,829, Visits: 35,961
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 2008, MVP
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

Post #1343779
Posted Saturday, August 11, 2012 4:47 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Thursday, July 10, 2014 11:09 PM
Points: 549, Visits: 1,181
THANKS AND MAY IKNOW UR PERSONEL MAIL ID AND UR DESIGNATION WHERE U WORK

Thanks & Regards
NAGA.ROHITKUMAR
Post #1343783
Posted Saturday, August 11, 2012 5:08 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 10:05 AM
Points: 42,829, Visits: 35,961
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 2008, MVP
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

Post #1343786
Posted Monday, August 13, 2012 4:29 AM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Today @ 7:55 AM
Points: 15,662, Visits: 28,055
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 2012 Query Performance Tuning
SQL Server 2008 Query Performance Tuning Distilled
and
SQL Server Execution Plans

Product Evangelist for Red Gate Software
Post #1344060
Posted Tuesday, August 14, 2012 5:49 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Thursday, July 10, 2014 11:09 PM
Points: 549, Visits: 1,181
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 & Regards
NAGA.ROHITKUMAR
Post #1344626
Posted Tuesday, August 14, 2012 7:27 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, May 30, 2014 8:15 AM
Points: 1,056, Visits: 2,687
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
Post #1344695
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse