Forum Replies Created

Viewing 7 posts - 16 through 22 (of 22 total)

  • RE: stuck with restore

    Again let me explain :

    1. A dtabase sists in a prod environment

    2. This db does not have a master backup

    3. On 6/18 data was deleted accidently.

    4. I copied the mdf...

  • RE: stuck with restore

    Hello

    Getting a copy of the original transaction log is no problem.

    It is not trunacted. I can always get a copy from the prod server.

    The size of my transaction log...

  • RE: stuck with restore

    Sorry it did not work. Throws an error. See the command I use and the msg below.

    RESTORE DATABASE Reporting

    FROM DISK = 'C:\Reporting\Reporting.BK'

    WITH STOPAT = N'06/18/2008 5:23:36 PM'

    I get...

  • RE: stuck with restore

    Thanks

    See whether you would agree with the following ?

    RESTORE DATABASE Northwind

    FROM DISK = 'C:\Backups\Northwind_Full_20080623.BAK'

    WITH NORECOVERY

    RESTORE LOG Northwind

    FROM DISK = 'C:\Backups\Northwind_Log_20080623.BAK'

    WITH STOPAT = N'06/18/2008 6:23:36 PM'

    Note: I...

  • RE: stuck with restore

    So basically, here is what I got.

    1. Look for a SQl server log parser.

    2. Download, install and run against the live database.

    3. Use the tool to extract data from the...

  • RE: stuck with restore

    Sorry folks:

    I guess I have not explained this properly. Lets put it this way.

    1. DB created on June 1 2008.

    2. Users add data, modify do what ever.......

  • RE: stuck with restore

    Thanks

    1. I do have the original mdf file

    2. I have the original ldf file.

    Regerdless of the backup status, I can recreate the databse ( I mean by using the for...

Viewing 7 posts - 16 through 22 (of 22 total)