You shouldn't need the THEN in the IF, I think you had an extra END in there, also. This appears to be working:

CREATE TABLE Table1 (col1 varchar(50), col2 varchar(50), col3...

I would assume when you're selecting your backup, near the bottom in the files to backup, you have a trn backup in there. Put a check into your .bak file,...

Make sure when you decide on a backup plan you build a well documented restore strategy. Lets say you're doing a full backup every night at midnight, differential backup at...