Activity overview
Latest activity by BigAndy
Ok, I blame fat finger syndrome, and the other developer. Had 0 (zero) in to. Changed everything to lower case to remove the proplem. Thanks rlindsay. / comments
Ok, I blame fat finger syndrome, and the other developer. Had 0 (zero) in to. Changed everything to lower case to remove the proplem. Thanks rlindsay.
Yes I did test with the same set of inital files.
Full backup:
FULL_(local)_Mariana_20050805 142652.sqb (used GUI create/restore)
this is located @ E:\ on the secondary server.
Here is a short list of the trx logs.
E:\TransLogsLOG_(local)_Mariana_20050805 154418.sqb
LOG_(local)_Mariana_20050805 161254.sqb
LOG_(local)_Mariana_20050805 164836.sqb
LOG_(local)_Mariana_20050805 170001.sqb
LOG_(local)_Mariana_20050805 171500.sqb
LOG_(local)_Mariana_20050805 173002.sqb
LOG_(local)_Mariana_20050805 174504.sqb
This is the code the I have running on the primary machine to create the trx logs. (modified from red-gate's site) "C:\Program Files\Red Gate\SQL Backup\SqlBackupC.exe" -SQL "BACKUP LOG [Mariana] TO DISK = 'E:\TransLogs\<AUTO>' WITH COPYTO = '\\mos\translogs\'"
Thanks again,
Andy / comments
Yes I did test with the same set of inital files.
Full backup:
FULL_(local)_Mariana_20050805 142652.sqb (used GUI create/restore)
this is located @ E:\ on the secondary server.
Here is a short list...
Problem Restoring Logs
ok, I'm setting up log shipping using SQLBackup. I have the backup job running."C:\Program Files\Red Gate\SQL Backup\SqlBackupC.exe" -SQL "RESTORE LOG [Mariana] FROM DISK = 'E:\TransLogs\*...