Metabase Log

We are using MSCRM and my SQL Metabase Log file is 21.3GB and my Metabase
Database file is 18.7MB. How do I clear out the Metabase Log File?Check the recovery model of the database. If it is in full mode, the
database log file will keep growing, unless you take periodic transaction
log backups.
If you don't need transaction log backups, but simply want to backup the
database once a day or so, switch the database to simple recovery mode.
This can be done from the database properties dialog box in Enterprise
Manager.
--
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"KMD" <KMD@.discussions.microsoft.com> wrote in message
news:9D0CA478-2FAA-4AEA-97B7-C4608637D1F8@.microsoft.com...
We are using MSCRM and my SQL Metabase Log file is 21.3GB and my Metabase
Database file is 18.7MB. How do I clear out the Metabase Log File?|||My backup strategy is set to Simple for quite some time now. How can I
regain the space that is used in the Metabase Log, it is 21GIG. To backup
the Transaction Log is greyed out, is this because the recovery model is set
to Simple. Any ideas to regain this space.
"Narayana Vyas Kondreddi" wrote:

> Check the recovery model of the database. If it is in full mode, the
> database log file will keep growing, unless you take periodic transaction
> log backups.
> If you don't need transaction log backups, but simply want to backup the
> database once a day or so, switch the database to simple recovery mode.
> This can be done from the database properties dialog box in Enterprise
> Manager.
> --
> HTH,
> Vyas, MVP (SQL Server)
> SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
>
> "KMD" <KMD@.discussions.microsoft.com> wrote in message
> news:9D0CA478-2FAA-4AEA-97B7-C4608637D1F8@.microsoft.com...
> We are using MSCRM and my SQL Metabase Log file is 21.3GB and my Metabase
> Database file is 18.7MB. How do I clear out the Metabase Log File?
>
>|||Try shrinking the file (DBCC SHRINKFILE).
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"KMD" <KMD@.discussions.microsoft.com> wrote in message
news:06A1E21B-0CD9-49E7-A93B-6E50D104D8BC@.microsoft.com...[vbcol=seagreen]
> My backup strategy is set to Simple for quite some time now. How can I
> regain the space that is used in the Metabase Log, it is 21GIG. To backup
> the Transaction Log is greyed out, is this because the recovery model is s
et
> to Simple. Any ideas to regain this space.
> "Narayana Vyas Kondreddi" wrote:
>