Top
Connect
email: vic @ hong . com . au
mobile: +1 604-783-6519
office: +1 604-677-2829


Search
Twitter Updates

    Blog Categories
    Admin
    Section2
    « TweakUI + Win2k3 + icons change to 256 colors | Main | GPMC - Error Generating HTML Report »
    Wednesday
    Jul162008

    SQL Express 2005 - automate backups

    DateWednesday, July 16, 2008 at 10:53PM

    Using poor mans SQL "express", I used the following link to setup automated backups, using SQLCMD and scheduled tasks.

    http://blogs.orcsweb.com/jeremy/archive/2006/11/06/Automating-Database-Backups-with-Microsoft-SQL-Server-2005-Express-Edition.aspx

    I created 7 different .sql files and .cmd scheduled tasks to create a 7 day full database backup.

    CommentPost a Comment |
    tagged , , in

    PrintView Printer Friendly Version

    Reader Comments

    There are no comments for this journal entry. To create a new comment, use the form below.

    PostPost a New Comment

    Enter your information below to add a new comment.

    My response is on my own website »
    Author Email (optional):
    Author URL (optional):
    Post:
     
    All HTML will be escaped. Hyperlinks will be created for URLs automatically.

    Notify me of follow-up comments via email.