Re: POINT IN TIME RESTORE
From: Vadim Mitin (vadimmitin_at_mail.ru)
Date: 03/23/04
- Next message: Dan Dapkus: "Running profiler on busy 8-cpu Sql Server"
- Previous message: New World Order Pigs: "recover master database questions"
- In reply to: Tim: "Re: POINT IN TIME RESTORE"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 24 Mar 2004 00:16:03 +0300
Try like this
http://www.sql-server-performance.com/lockwoodtech_log_navigator_spotlight.asp
> Sorry to jump in, I have read the thread and it is close to what I
> would like to accomplish but not quite.
>
> I have a perfefctly good database with a .mdf and a .ldf file. The
> recovery model is FULL. It was a new database a few weeks ago for
> developing a new product.
>
> We entered all kinds of info into it before we realized we were not
> backing it up. Today we erased all the data...oops..
>
> So I have a good .mdf and a full .ldf, I do a backup of both (wrong
> thing)? And I try to restore using the cdoe I have seen here before..
>
> RESTORE DATABASE mydatabase FROM DISK='c:\mybackup\pnedata' WITH
> NORECOVERY;
>
> RESTORE LOG PNEBilling FROM DISK='c:\mybackup\pnedata' WITH RECOVERY,
> STOPAT = 'Mar 18, 2004 10:00 AM';
>
> This runs without error but restores the database to its CURRENT state
> which is empty of data!
>
> If I run the same from Enterprise Manager and I check the "Point in
> time" it will not allow me to select anything but today.
>
> It seems that I should be able to do this since I have a full .ldf
> file but the method is beyond my technical skills.
>
>
> Any ideas?
>
> Thanks
>
> Tim
- Next message: Dan Dapkus: "Running profiler on busy 8-cpu Sql Server"
- Previous message: New World Order Pigs: "recover master database questions"
- In reply to: Tim: "Re: POINT IN TIME RESTORE"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
