Hi,
Include the below 2 scripts in your stored procedure and it will do the trick..it will take a backup and will restore it too.
BACKUP DATABASE [ReportServer] TO DISK = N'H:\Backup\ReportServer.bak' WITH NOFORMAT, NOINIT, NAME = N'ReportServer-Full Database Backup', SKIP, NOREWIND, NOUNLOAD, STATS = 10
GO
RESTORE DATABASE [ReportServer] FROM DISK = N'H:\Backup\ReportServer.bak' WITH FILE = 1, NOUNLOAD, REPLACE, STATS = 10
GO
Happy Coding..
regards
anurag