Backup Stored Proc

By Scott Duncan, 2008/01/17

Total article views: 2386 | Views in the last 30 days: 492

Rate this |

Join the discussion |

Briefcase

This stored procedure was written to get around the lack of support for maintenance plans in MSDE. The user specifies the type of backup (FULL, LOG or DIFFERENTIAL), the db name, the folder to hold the backup file and the retention period in days (anything older in the backup folder for the specified backup type is deleted). See usage instructions in the code or run the procedure with no parameters.

It doesn't handle long filenames for some reason, so use 8.3 names for folders.

The stored procedure also has a parameter for debugging. Set to 1 to have commands printed out during the execution of the procedure.

By Scott Duncan, 2008/01/17

Total article views: 2386 | Views in the last 30 days: 492

Your response

Rate this |

Join the discussion |

Briefcase

Related tags

Check Instance Info

By Pedro Lopes | Category: SQL Server 2000

| 886 reads

A Failed Jobs Monitoring System

By TJay Belt | Category: SQL Server 2005

| 7,751 reads

Available bytes for row expansion (adding columns) in a table

By ruchir | Category: SQL Server 2005

(not yet rated) | 332 reads

Row count and space used for all tables in database (update)

By Rafal S. | Category: Miscellaneous

| 1,073 reads

Like this? Try these...

Stored Procedure Script Generation By Dependency

By Additional Articles | Category: Miscellaneous

Rate this | 846 reads

BackUp database

By BeoWulf . | Category: Backups

| 659 reads

Generate SQL Scripts from Database

By Absinthe | Category: DMO

(not yet rated) | 1,156 reads

Already registered?

Free registration required

To read the rest of this article, and access thousands of other articles, we ask you to register on the site and subscribe to our newsletters.

Register

E-mail address:
Password:
Password (confirm):

Subscriptions

We ask you to register on the site and subscribe to our newsletters. Subscribing to our newsletters gets you:

ALL of our content (thousands of articles, scripts, and forum postings)
A daily newsletter (example)
A weekly news round up (example)
The opportunity to ask and answer questions in our forums
A daily Question of the Day to test and help you increase your knowledge of SQL Server.

We ask that you give the newsletter a try for a week. Over 200,000 SQL Server Professionals a day find it entertaining and useful. If not, you are welcome to unsubscribe at anytime.

Steve Jones
Editor, SQLServerCentral.com