Restore leads to (very) large log file. -- sql server msde

Johan Bouwhuis
4/18/2005 6:27:04 AM

Hello,

We are using MSDE and I would like to know the following:
- Our MDSE database is set to recovery model Simple but after restoring the
backup set the log file increases to 800/900 MB; I'm puzzled about this,
because I always thought that 'Simple model' leaves the log file(s) alone;
- MSDE has a size limit of 2 G; does this mean that if the log file grows
beyond 2 G (after a restore) the database can't be used?

MTIA,

Kind regards,

Hari Prasad
4/18/2005 9:06:25 AM

Hi,

The actual LDF file from which you took the backup should be 900 MB. That is
the reason restore operation created the LDF with 900 MB.

2 GB limitation is only for MDF file. LDF will not be added into 2 GB

Thanks
Hari
SQL Server MVP

[quoted text, click to view]

sql server msde : Restore leads to (very) large log file.