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
Friday, January 30, 2009
If your SQL 2005 log file is too big...
Subscribe to:
Post Comments (Atom)
Subscribe To This Web Site
Posts
Comments
No comments:
Post a Comment