Database Backup SP

Next I present you my implementation of an stored procedure for making backup to an database.

This stored procedure works very good on SQL Server 2005 Express Edition.

This stored procedure can be used like this:

The return value should be 0 in case of success, or -1 in case of error. 🙂

The output messages should look something like this:

 

Enjoy and feel free to modify it as you need. 🙂

Posted in MSSQL.