Hi all!
I am in need of writing a few stored procedures.

The first one is to create a stored procedure to recover a database
from backup and the second one is to create a stored procedure to
execute a transaction log backup (even though I know this can be done
through a maintainence plan). Any help would be greatly appreciated.

I know the commands to recover and backup -- but I dont know how to
formulate them into a stored procedure

Peanut044 (mbelli01@hotmail.com) writes:
[quoted text, click to view]

That should not be much different. Look up the syntax for the commands
in Books Online, to find out where you can use variables and where you
cannot not. If you need to use variables where the syntax does not
permit this, then use dynamic SQL.


--
Erland Sommarskog, SQL Server MVP, sommar@algonet.se

Books Online for SQL Server SP3 at