December 27, 2011 at 9:13 am
I have restored my live database into my test dbase with norecovery so that i can get to my transaction logs to restore at a point in time. when i choose restore from transaction logs and choose the backup to use i do not see any transaction logs on the screen under "select the transaction log backups to restore". Where are they to be found? are they within the backup file or are they a separate file? I need to restore some records that i mistakenly deleted.
December 27, 2011 at 9:23 am
Viewing Information About Backups
December 27, 2011 at 10:24 am
bill.akin (12/27/2011)
I have restored my live database into my test dbase with norecovery so that i can get to my transaction logs to restore at a point in time. when i choose restore from transaction logs and choose the backup to use i do not see any transaction logs on the screen under "select the transaction log backups to restore". Where are they to be found? are they within the backup file or are they a separate file? I need to restore some records that i mistakenly deleted.
Was the target database set to Full Recovery Model?
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.December 27, 2011 at 11:01 am
yes it was
December 27, 2011 at 11:51 am
bill.akin (12/27/2011)
yes it was
Check TLOG BACKUP script - it should include a "TO DISK=N'----location of the tlog trn files----' option.
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.December 27, 2011 at 11:55 am
Ok thank you. turns out i have not backup transaction logs. so i did that and now have a transaction file to restore from but when i try to restore it has this error "the process cannot access the file because it is being used by another process" the file is not being accessed from anywhere else that i can see.
December 27, 2011 at 12:59 pm
Is the back Tlog SQL Agent job/script still running?
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply