Backing up SQL 2008

[glennda]

Just a quick question,

 

What are people using to backup SQL 2008? we currently are using backup exec 12.0 which as far as i can see will not backup sql 2008. You cannot use NT backup AFAIK to backup sql.

 

is this something we are going to have to bite the bullet and upgrade exec to version 12.5? or is there an alternative?

[DMcCoy]

Scheduled backup to a file on the servers disk with the sql agent. Then that file is part of the normal backup. You just need the sql management studio to create the task. I assume this is possible in sql express, but mostly use sql standard here.

[SYNACK]

Agreed you should be able to use managment studio express with SQL express to schedule a backup job in SQL itself out to a known file location then just pick it up on the standard backup.

[zag]

Microsoft DPM 2010 is pretty cheap and does a great job.

 

Backup exec really isn't the market leader any more.

[PiqueABoo]

you should be able to use managment studio express with SQL express to schedule a backup job in SQL itself

 

You (or at least I) get that feature Management Studio Express, however you can go get ExpressMaint and use it in a simple scheduled task to create/trim-to-last-n backups/recreate indexes etc... it's a very, very handy little app.

 

Or if a DB doesn't have to run 24/7 shut it down as a backup job pre-backup command and start it up again as a post-backup command.

[glennda]

For Anyone looking at this thread looking for a backup solution, this is a walk through that i followed for setting this up Scheduling Automated Sql Backup