Link to home
Start Free TrialLog in
Avatar of raffie613
raffie613

asked on

SQL express backup utility

Does anyone know of an easy,Free, SQL EXPRESS 2005 backup utility. The scripts seem a bit complicated for me.
Thanks.
Avatar of Aaron Tomosky
Aaron Tomosky
Flag of United States of America image

Do you just want a command line backup? You can do the with one command an put it in a batch file if you like.
Sqlcmd
Super easy. Let me know if you can't figure out the syntax.
Avatar of raffie613
raffie613

ASKER

I was hoping for a point and click application but if you think it is very easy, I can try it.
Oh, clicking is super easy. Open SQL server management studio, right click your db name, tasks, backup. Click file, choose file location and name (remember to add .bak). Click go.
but this is SQL express. I don't think it has that option or is that just an automated option?
Yes it does. If you downloaded the one without tools, you can get the tools separately from Microsoft. Free.
That is the first I have heard of that. Everything I am reading on sql express 2005 says it doesn't have a sql agent and therefore can't do auto backup scheduling. Can you show me these tools?
I gave you a cli option you can run with task scheduler. You asked for a clickable version so I told you how to do a manual backup with management studio.
If neither of these are what you need, Please clarify.
i missed the one with the task scheduler. You mentioned using the command prompt and giving me the syntax.
I would like to make an automated backup schedule so however I can do that without making a SQL script.
ASKER CERTIFIED SOLUTION
Avatar of Aaron Tomosky
Aaron Tomosky
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ok thanks.
Which are the variables that I need to change in here to fit the names of my database?

Also can I write this in notepad to save as a .bat file or something else?

Thanks,
yes, just make a new txt file, paste that stuff into it, save it, rename it as a .bat.
all you NEED to change is dbname to the name of your database.
right now it will put the backups in the folder you run the batch file from in a folder with today's date and name the file dbname.bak (until you change that).

 If you explain where you want the backups to be and the folder structure and how they are named I can make those changes for you.

note: I run this file on the computer with the sqlserver on it, thats why the string has "localhost" in it. If you are connecting to a different computer that's a little harder.
SSIS is the best way, If you have Full version of SQL on other server. You can create a SSIS package and in that you can schedule job for schedule backup at your desire location.
I do not have a full SQL version. that is my issue.
Does my batch file with task scheduler not work for you? Please explain why and we will come up with something better.