August 7, 2012 at 4:17 am
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
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
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
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
Yep looks good.
August 12, 2012 at 9:35 pm
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