Friday, January 30, 2009

If your SQL 2005 log file is too big...

We can reduce log file size by using shrink process.

DBCC SHRINKFILE (DB_LOG(Log file Logical name) ,1000(desired Log file size (MB) )

If log file size does not reduce after applying these steps, backup transaction log and try again the command above

No comments:

Post a Comment

span.fullpost {display:inline;}