LOG files

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Raul - 31 Mar 2008 17:44 GMT

I moved all my data files from mssql2000 to mssql2005.

problem is that my log files are GB's bigger than the MDF file.

Can I delete the LOG files? IF not, can I reduced the size?

How?

Thanks,
Raul Rego
NJPIES

Reply to this Message

Tibor Karaszi - 31 Mar 2008 19:35 GMT

Do you mean transaction log files (typically .ldf) or something else? If you mean transaction log
files, then do not delete them (unless you are prepared to restore the databases from backups). You
can shrink the file size using DBCC SHRINKFILE.

Bu the fact that these are so large is an indication that you or your dba haven't thought out a
suitable backup plan for your database and set the recovery model accordingly.

Signature

Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi

>I moved all my data files from mssql2000 to mssql2005.
>
[quoted text clipped - 7 lines]
> Raul Rego
> NJPIES

Reply to this Message