DBCC SHRINKFILE

Last Post 01 May 2008 09:53 AM by dbandee. 0 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
dbandee
New Member
New Member

--
01 May 2008 09:53 AM
Hi
i have MyDb in Full Recovery Mode

tlog grows into 10s of GB

i run backup log truncate only every 30 min on the server but it does not help

is it safe to run DBCC SHRINKFILE command

So the scenario is like this

some user run
begin transaction
--huge insert 500 mil record goes here
end transaction

the whole thing takes 1 hour and tlog is 25 GB

My question is would it be safe and what would happen if i run DBCC SHRINKFILE somewhere 30 min into the transaction?

Thanks



Acceptable Use Policy
---