March 27, 2009 at 7:45 am
can we restore a sql database from the .bak file without log. I dont want the full log file to be restored it has to be truncated as i expect log is very big.
March 27, 2009 at 7:52 am
IF it is a full database backup ..then why bother about restoring a logfile.
By all means you can just restore the .bak file(it has to be full database backup)
March 27, 2009 at 8:42 am
Actually i am trying ot save time for restore. The .bak file may also has log in it which is very big and so i want to truncate that file before restore so that i dont waste time restoring the log too.
March 27, 2009 at 8:51 am
The backup contains
- data
- log records that occurred during the backup process.
It doesn't contain the full log, but it does contain data about the size of the log. That file has to be rebuilt and you can't do anything about it. The only thing you can do is have a smaller log file when you run the backup.
March 29, 2009 at 10:42 am
Tara (3/27/2009)
The .bak file may also has log in it which is very big and so i want to truncate that file before restore so that i dont waste time restoring the log too.
The only operations you can perform against .bak files are:
Restore it
Compress it
Encrypt it
If the .bak file is huge it is huge you cannot do anything about it while restoring it
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply