You can use a RESTORE DATABASE command inside the stored proc:
CREATE PROCEDURE ...
...
SET @db_name_to_restore = ...
SET @backup_file_to_restore = 'x:\full\path\to\backup\file\backup.bak'
RESTORE DATABASE @db_name_to_restore
FROM DISK = @backup_file_to_restore
How to restore using S.P
Posted - 03/14/2013 : 01:38:04
