Problem Restoring Logs

BigAndy

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\*.sqb' WITH MOVETO = 'E:\TransLogs\Processed\'"

will restore the logs but no leave the DB in read-only mode for future log restores.

Modified the code to

"C:\Program Files\Red Gate\SQL Backup\SqlBackupC.exe" -SQL "RESTORE LOG [Mariana] FROM DISK = 'E:\TransLogs\*.sqb' WITH MOVET0 = 'E:\TransLogs\Processed\', STANDBY = 'E:\MSSQL\BACKUP\UNDO_Mariana.DAT'"

and ran in a command window which returned the following

SQL Backup 3.2.0, (c) Red Gate Software Ltd 2004 - 2005
Trial - 13 days remaining

Syntax error: MOVET0 after ,

I've looked in the help file, and even had a developer look over the code and have not found where my error is.

Would some one please take a look and give me some insight as to what is going on. I have not found where the UI generates the MOVETO code along with the STANDBY code, so at this point I'm just beating my head against the wall.

Thanks in Advance.

BigAndy

petey

I'm guessing that one or more of the trx log backup files has a name that contains characters that confuses the SQL Backup syntax parser.

When you were testing with and without the STANDBY command, were you testing with the same set of files?

If it's ok and not too large, perhaps you could post the list of files here?

BigAndy

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

rlindsay

It looks like you have WITH MOVET0 (with a zero) instead of WITH MOVETO in your mofidied code.

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.