Trying to backup table..to another table

Ok i'm a newb to query's and well heres what i have...

CREATE PROCEDURE proc_BackupUserData
@BackupType smallint,
@strUserId varchar(20)
AS
insert into Backup_GameUser select getdate(), @BackupType, * from gameuser where struserid = @strUserId
insert into Backup_UserItem select getdate(), @BackupType, * from UserItem where struserid = @strUserId
insert into Backup_Storage_01 select getdate(), @BackupType, * from storage_01 where struserid = @strUserId

GO

_____________________________________

it comes up an error not sure if its correct...trying to backup GameUser, Useritem and Storage_01...into there Backup_etcetc.