Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 


 
     
Recent Posts
   
Popular Topics
Home   
Search
    Members    Calendar    Who's On

Home » SQL Server 2005 » Administering » How should i free up the space from the...
Add to briefcase
12 posts, Page 1 of 2
12»»

How should i free up the space from the BACKUP Drive whcih is increasing Rapidly Expand / Collapse
Rate Topic
Display Mode
Topic Options
Author
Message
naga.rohitkumar
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: Yesterday @ 3:57 AM
Points: 529, Visits: 1,042
How should i free up the space from the BACKUP Drive whcih is increasing Rapidly

Thanks
Rohit

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


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: General Forum Members
Last Login: Today @ 8:31 AM
Points: 38,083, Visits: 30,377
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
naga.rohitkumar
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: Yesterday @ 3:57 AM
Points: 529, Visits: 1,042
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
naga.rohitkumar
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: Yesterday @ 3:57 AM
Points: 529, Visits: 1,042
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
GilaMonster
Posted Saturday, August 11, 2012 4:33 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: General Forum Members
Last Login: Today @ 8:31 AM
Points: 38,083, Visits: 30,377
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
naga.rohitkumar
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: Yesterday @ 3:57 AM
Points: 529, Visits: 1,042
THANKS AND MAY IKNOW UR PERSONEL MAIL ID AND UR DESIGNATION WHERE U WORK

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


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: General Forum Members
Last Login: Today @ 8:31 AM
Points: 38,083, Visits: 30,377
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
Grant Fritchey
Posted Monday, August 13, 2012 4:29 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 9:49 AM
Points: 13,436, Visits: 25,281
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
naga.rohitkumar
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: Yesterday @ 3:57 AM
Points: 529, Visits: 1,042
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
durai nagarajan
Posted Tuesday, August 14, 2012 7:27 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: 2 days ago @ 10:16 AM
Points: 863, Visits: 2,135
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 posts, Page 1 of 2
12»»

Permissions Expand / Collapse

 
 
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.