Restoring log & backup

Hi,
Our SQL server has a database with scheduled backups which backup the
database & the log file of our production site.
I would like to restore this backup to our test DB with the production
backup in order for it to resemble the production one. Should I uncheck the
log file backup when restoring or is it ok to restore it as well? Both files
come up in the restore as ticked. What are the implications of this?
Thanks very much for any ideas on this
AntThe log files will bring you closer to the most recent state of the original
DB.
--
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Toronto, ON Canada
"Ant" <Ant@.discussions.microsoft.com> wrote in message
news:DA827430-11D9-459D-A005-234C3F3035CF@.microsoft.com...
Hi,
Our SQL server has a database with scheduled backups which backup the
database & the log file of our production site.
I would like to restore this backup to our test DB with the production
backup in order for it to resemble the production one. Should I uncheck the
log file backup when restoring or is it ok to restore it as well? Both files
come up in the restore as ticked. What are the implications of this?
Thanks very much for any ideas on this
Ant|||Hello,
To bring the database up to latest you may need to restore the LOG backups
as well.
Perform below:-
1. Restore the lastest full database backup with NORECOVERY
2. Restore the subsequent log backups one by one with NORECOVER until last
log backup
3. Restore the last log backup with RECOVERY to make the database
operational.
Thanks
Hari
"Ant" <Ant@.discussions.microsoft.com> wrote in message
news:DA827430-11D9-459D-A005-234C3F3035CF@.microsoft.com...
> Hi,
> Our SQL server has a database with scheduled backups which backup the
> database & the log file of our production site.
> I would like to restore this backup to our test DB with the production
> backup in order for it to resemble the production one. Should I uncheck
> the
> log file backup when restoring or is it ok to restore it as well? Both
> files
> come up in the restore as ticked. What are the implications of this?
> Thanks very much for any ideas on this
> Ant