If it has a plug, it's IT stuff

May 16 2008   4:13PM GMT

[TLBAT] Microsoft SQL Express Edition automated backup

alessandro.panzetta Alessandro Panzetta Profile: alessandro.panzetta

An ERP application that the company where I work at the moment is selling, relies on Microsoft SQL databases but, obviously, most of the customers where this application is deployed yell as crazy when they do know the license cost for Microsoft SQL 2005.

So you are at a crossroad:

  1. Install a “friendly” copy that you own
  2. Install the Express/Advanced edition with limits

Seen that you’re a good guy you always install the Express/Advanced edition but you know that you are going to miss lots of functions and opportunities that you’d have with the Standard version…first of all the backup!!!

In order to have similar scriptable feature that you have in the Standard version you can use ExpressMaint that can be scheduled to run at night time so you can perform backups, reindex and so on.

Personally I prefer to have a full backup, compress it with WinRar and then, if no reliable backup device is present at the customer site, send it via ftp to our server.

Hereafter an sxample of a daily full backup of all user databases on a computer called PC01 that will be saved in the c:\backup folder:

c:\ExpressMaint.exe -S PC01 -D ALL_USER -B c:\backup -BU DAYS -BV 1 -T DB

1  Comment on this Post

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when other members comment.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Magnificus
    That really is a VERY handy tool! :D
    45 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to: