• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 601
  • Last Modified:

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.
0
raffie613
Asked:
raffie613
  • 8
  • 6
1 Solution
 
Aaron TomoskyTechnology ConsultantCommented:
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.
0
 
raffie613Author Commented:
I was hoping for a point and click application but if you think it is very easy, I can try it.
0
 
Aaron TomoskyTechnology ConsultantCommented:
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.
0
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 
raffie613Author Commented:
but this is SQL express. I don't think it has that option or is that just an automated option?
0
 
Aaron TomoskyTechnology ConsultantCommented:
Yes it does. If you downloaded the one without tools, you can get the tools separately from Microsoft. Free.
0
 
raffie613Author Commented:
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?
0
 
Aaron TomoskyTechnology ConsultantCommented:
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.
0
 
raffie613Author Commented:
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.
0
 
Aaron TomoskyTechnology ConsultantCommented:
this is a generic version of the batch file I use. Save this as a dobackups.bat or something and use windows task scheduler to run it automatically. I use it for daily backups so it puts it in a folder with the date.
@ECHO OFF

rem sets date as yyyymmdd
for /f "tokens=2,3,4 delims=/ " %%a in ('DATE /T') do set date=%%c%%a%%b

SET FOLDERNAME=%DATE%

sqlcmd -S LOCALHOST\SQLEXPRESS -Q "Backup database dbname to disk = N'%CD%\%FOLDERNAME%\dbname.bak' WITH INIT"
pause

Open in new window

0
 
raffie613Author Commented:
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,
0
 
Aaron TomoskyTechnology ConsultantCommented:
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.

0
 
Aaron TomoskyTechnology ConsultantCommented:
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.
0
 
Alpesh PatelAssistant ConsultantCommented:
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.
0
 
raffie613Author Commented:
I do not have a full SQL version. that is my issue.
0
 
Aaron TomoskyTechnology ConsultantCommented:
Does my batch file with task scheduler not work for you? Please explain why and we will come up with something better.
0

Featured Post

Microsoft Certification Exam 74-409

VeeamĀ® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

  • 8
  • 6
Tackle projects and never again get stuck behind a technical roadblock.
Join Now