SQL Server: Hidden risks of using DBCC SHRINKFILE

sql-server sql-server-2008 dbcc
SDReyes picture SDReyes · Sep 8, 2010 · Viewed 8.3k times · Source

We're getting a huge LDF file by using a full recovery mode in a SQL Server DB. so we're planning to shrink the log file.

Is there any performance penalty for using DBCC SHRINKFILE to reduce the database log file size (LDF)?

and what about applying it to the data file (MDF)?

Answer

Sidharth Panwar picture Sidharth Panwar · Sep 8, 2010

I think this should be helpful: http://www.mssqltips.com/tip.asp?tip=2055

Related questions

Currently running query inside a stored procedure

I have a stored procedure that is currently running, and seems to hang/lock on a specific query. How can i see which query? Preferably without modifying the proc. Using DBCC Inputbuffer (65) gives me Language Event 0 EXEC mySP;

Read More
How can I get column names from a table in SQL Server?

I want to query the name of all columns of a table. I found how to do this in: Oracle MySQL PostgreSQL But I also need to know: how can this be done in Microsoft SQL Server (2008 in my case)?

Read More
How to Delete using INNER JOIN with SQL Server?

I want to delete using INNER JOIN in SQL Server 2008. But I get this error: Msg 156, Level 15, State 1, Line 15 Incorrect syntax near the keyword 'INNER'. My code: DELETE FROM WorkRecord2 INNER JOIN Employee ON EmployeeRun=EmployeeNo WHERE Company = '1' …

Read More