MS SQL Server - Big log file in backup

Author

Big log file in backup

Johny

2006-02-12, 8:23 pm

I have backup of database which have log file (LDF file) big around 7GB. At
the moment it seem that I don't have enough space to restore it, Is it
possible that I some hove restore only MDF file or reduce size of LDF in
backup?

Uri Dimant

2006-02-13, 7:23 am

Johny

If you don't 'need' the LOG file , you can detach the database , remove the
log file and attach the database with the option as single file (only .mdf)

I'd recommed you to start perfoming BACKUP LOG file on regular period of
time so you will be able to manage the size of the log as well as having a
posibility to restore the data at point of time .

"Johny" <goky2002@beograd.com> wrote in message
news:%23VoAafBMGHA.532@TK2MSFTNGP15.phx.gbl...
>I have backup of database which have log file (LDF file) big around 7GB. At
> the moment it seem that I don't have enough space to restore it, Is it
> possible that I some hove restore only MDF file or reduce size of LDF in
> backup?
>
>

Sponsored Links