|
| PORTAIL | ANNUAIRE | ARTICLES | COMPARATEUR HÉBERGEURS | DEVIS | FORUMS | RÉDUCTEUR D'URL |
|
31/03/2008, 17h44
|
#1 |
Messages: n/a
Hébergeur: |
LOG files
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 |
|
|
31/03/2008, 19h35
|
#2 |
|
Messages: n/a
Hébergeur: |
Re: LOG files
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. -- Tibor Karaszi, SQL Server MVP http://www.karaszi.com/sqlserver/default.asp http://sqlblog.com/blogs/tibor_karaszi "Raul" <rrego@njpies.org> wrote in message news:26041173-37E9-44E0-AA79-CFDFC093EC5B@microsoft.com... >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 |
|
|
 |
| Outils de la discussion | |
|
|
