I do agree with you but the second server is in different domain. And the second server is a DR\UAT server. there is no domain level server in between these...

Hi All,

My requirement is to pick the TRN's automatically and restore them in the right sequence keeping the DB in stand by mode. I used this but it is not...

xxxdb_backup_2014_02_06_073328_1849272.trn

this is the format foll all my backups now

can you let me know what changes need to done in sub string

currently it is showing SUBSTRING (Col1, 1, 20)

to...

I am using the script which was posted early in this link.. the script is below

I made only 2 changes

1. SET @DBToRunOn = 'ab1'

2. SELECT @FilePath = 'D:\SQL SERVER\TEST\AB1BACKUP\'

apart from...

while trying those scripts i am getting some error like the below

Msg 241, Level 16, State 1, Line 49

Conversion failed when converting date and/or time from character string.

currently my LSN's...

HI,

I am in need of a script. Which have to pick the latest LSN with sequence automatically and restore it "XXXDB" in no recovery mode. can any one help me...