Help with Stored Procedures needed -- URGENT

[Peanut044]

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

Thanks in advance!

[Erland Sommarskog]

Re: Help with Stored Procedures needed -- URGENT

Peanut044 (mbelli01@hotma il.com) writes:[color=blue]
> 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[/color]

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

http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp