Post reply

data recover

  • August 7, 2012 at 4:17 am

    #1522481

    All you need is the BACKUP and RESTORE commands, plenty of information in BOL or the internet

    BACKUP LOG dbname TO DISK = 'some path'

    RESTORE DATABASE dbname FROM DISK = 'some path to full' WITH NORECOVERY

    RESTORE DATABASE dbname FROM DISK = 'some path to transaction log' WITH RECOVERY STOPAT '2012-01-01 00:00:00.000'

  • August 7, 2012 at 4:30 am

    #1522486

    thanks. if i use the GUI to backup the transaction log, on the options tab i see:

    -truncate the transaction log

    -backup the tail of the log and leave the database in the restoring state.

    sorry this is my production database those i am litle to curious before i start the log backup.

  • August 7, 2012 at 4:34 am

    #1522488

    Use the scripts I have given you as a starting point, use Google (other search engines available) or Books Online to look at the syntax of the other options which you may want to apply to the command.

  • August 7, 2012 at 5:34 am

    #1522512

    Hi...please vet my script, if i am doing the right thing here:

    RESTORE DATABASE test

    FROM DISK='D:\BackupFiles\TestDatabaseFullBackup.bak'

    WITH NORECOVERY;

    RESTORE LOG test

    FROM DISK='D:\BackupFiles\TestDatabaseTransactionLog.trn'

    WITH NORECOVERY, STOPAT = 'May 19, 2012 12:00 AM';

    RESTORE DATABASE test WITH RECOVERY;

  • August 7, 2012 at 5:51 am

    #1522520

    Yep looks good.

  • August 12, 2012 at 9:35 pm

    #1524902

    Yes, there are some data recovery software available for SQL data recovery. You can recover your files easily.

    Lost data on your computer? Accidentally deleted files but want to get them back? Formatted the hard drive withou backing up your data? Don't worry, data recovery software can help you out. http://www.any-data-recovery.com

Viewing 6 posts - 16 through 20 (of 20 total)

You must be logged in to reply to this topic. Login to reply