SQL Express Backups ?

  • Without a 3rd party tool, what's the best way to backup SQL Express, not having SQL Agent ?

    A Windows Task Scheduled to run a backup script, and delete old backups ?

  • You have to be able to schedule 'something' - so you need a tool that schedules and runs jobs.  Since SQL Server Express does not have the agent then you are left with Task Scheduler in windows.

    As to what can be used to run that code - Powershell would be a good option, and better yet - download dbatools (https://dbatools.io/) and use their components in a PS script to handle backups.

    Jeffrey Williams
    Problems are opportunities brilliantly disguised as insurmountable obstacles.

    How to post questions to get better answers faster
    Managing Transaction Logs

  • Could you use SQL Developer Edition?  If it's business prod, you can't, but if it's just something you're doing on your own, you can.  And that edition has full capabilities.

    SQL DBA,SQL Server MVP(07, 08, 09) Prosecutor James Blackburn, in closing argument in the Fatal Vision murders trial: "If in the future, you should cry a tear, cry one for them [the murder victims]. If in the future, you should say a prayer, say one for them. And if in the future, you should light a candle, light one for them."

  • Powershell and a Windows Scheduled Task is one method yes. Some prefer to use a different scheduling tool that is more "user friendly"; there are plenty out there if you have a search.

    As for using Powershell, as Jeffrey mentioned, DBA Tools is a really nice 3rd party module. The SqlServer module also has the Backup-SqlDatabase command, if you prefer non-third parties modules.


    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.

  • Open SQL Server Management Studio Express and connect to the SQL server.

    Expand Databases.

    Right-click on the database you want to back up, then select Tasks > Back up.

    On the Back Up Database window, make sure the Database field contains the name of the database you want to back up.

    Select the Backup Type.

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

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