SQL Express Database Backup Script

Can you provide a simple script that backs up a SQL 2012 Express database?
IDMAAsked:
Who is Participating?
 
Vitor MontalvãoConnect With a Mentor MSSQL Senior EngineerCommented:
I recommend you to use the one provided by Microsoft here. The article also shows how to schedule the script to run automatically.
0
 
Phillip MonkIT ManagerCommented:
Ola Hallengren's scripts are my personal go to when backing up SQL. They can be found here:
https://ola.hallengren.com/
1
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
Ola's script doesn't work on SQL Express. It needs SQL Agent, that's not exists in SQL Express.
1
Improve Your Query Performance Tuning

In this FREE six-day email course, you'll learn from Janis Griffin, Database Performance Evangelist. She'll teach 12 steps that you can use to optimize your queries as much as possible and see measurable results in your work. Get started today!

 
IDMAAuthor Commented:
I have been trying the MS script without luck.  I keep receiving this error:

Msg 102, Level 15, State 1, Line 1
Incorrect syntax near '/'.
0
 
Vitor MontalvãoConnect With a Mentor MSSQL Senior EngineerCommented:
Oh, remove those 3 first lines that starts with //. It's only a remark from Microsoft that's their script.
0
 
Phillip MonkIT ManagerCommented:
Closed due to inactivity
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.