Restore Database ....

Hi,
I want to restore database from my backup. This backup contains 2 files
-
1. database which is one day old and
2. transaction log which was taken one hour back
Can I do this using Enterprise Manager? Please let me know.
Thanks,
DJ
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!Hi,
In Query analyzer,
Restore database dbname from disk='c;\backup\dbname.bak'
with move 'logical_data_filename' to 'physical_data_filename',
move 'logical_log_filename' to 'physical_log_filename', NORECOVERY
(Ignoremove option if it is not required)
go
Restore log dbname from disk='c;\backup\transname.bak' with RECOVERY
In Enterprise manager,
1. Select the dbname, right click -- All tasks -
2. Select Restore database option
3. Select the full database backup device
4. Click options tab and select the "Recovery complete state" ,- Leave
database readonly able to restore transaction logs"
5. CLick ok and wait till completion
6. Again click all tasks, Restore database
7. Select the transaction log backup device file
8. Click options tab and select the "Recovery complete state" ,- Leave
database operational . No additonal transaction log can be restored".
9. CLick ok and wait till completion
Thanks
Hari
MCDBA
"Dave Jones" <Dave@.nospam.com> wrote in message
news:eb2wO1HAEHA.1600@.tk2msftngp13.phx.gbl...
> Hi,
> I want to restore database from my backup. This backup contains 2 files
> -
> 1. database which is one day old and
> 2. transaction log which was taken one hour back
> Can I do this using Enterprise Manager? Please let me know.
> Thanks,
> DJ
>
> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it!