i'm using sql server 2008 r2, , need restore 36 .trn logs database. have restored first 4 using restore transaction log functionality in ssms (right-click database > tasks > restore > transaction log).
is there way restore them in order using tool or script? .trn files in folder on remote server. not not need restore files in folder, ones between specific dates.
i'm looking way automate don't have manually restore each individual log.
i access files using address 1 below.
\\remote server ip\sql_backup\lmsql02\tlog\file.trn
i suggest use restore gene : automating sql server database restores - written paul brewer
the restore gene stored procedure generates required restore scripts, including dbcc checkdb command, if required. useful tool, itself; in disaster recovery situations, can construct restore script, in seconds. optionally includes override options name of target database , move overrides data, log file locations, might recover lost data restoring temporary version of database same instance.
it has both tsql , powershell versions automation.
Comments
Post a Comment