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