Post reply

Automated Backups for SQLServer Express

  • May 14, 2010 at 7:05 pm

    #221104

    Where can I find information on setting up automatic backups for SQLServer Express?

  • May 15, 2010 at 5:21 am

    #1167899

    with a non-express version of SQL, the SQLAgent is used to perform jobs on a schedule, like backups and other maintenance tasks.

    since Express doesn't include the SQL Agent, you'll need to use Windows Scheduled Tasks, and write something in a programming language that connects to the database and calls the backup commands, ; other alternatives are maybe a vbs script, or maybe powershell (is that included with Express?), which i haqve not played with yet.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • May 15, 2010 at 8:22 am

    #1167927

    Yes Powershell is included.

  • May 15, 2010 at 5:59 pm

    #1167973

    Maybe, by using the schedule you can do it periodically.

    But, If you use the MS SQL Server Express Edition, I recommend

    you to create a service application to do that.

    So, from this application you can do execute strored procedure that

    execute the script for back up then to the folder that you want.

    FYI, I'm not familiar with Perl. But, by using delphi I can do that so

    simple.

    Regards,

    Eko Indriyawan

  • May 15, 2010 at 9:21 pm

    #1167984

    This actually looks promising.

    http://www.winblogs.net/index.php/2009/11/22/automating-backup-of-databases-in-sql-20052008-express/

  • May 17, 2010 at 8:40 am

    #1168300

    This works really well....

    "Scheduling Backups for SQL Server 2005 Express"

    http://www.mssqltips.com/tip.asp?tip=1174

    Tim White

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply