Windows Thread, Backing up SQL 2008 in Technical; Just a quick question,
What are people using to backup SQL 2008? we currently are using backup exec 12.0 which ...
3rd June 2010, 01:00 PM #1
Backing up SQL 2008
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?
IDG Tech News
3rd June 2010, 01:41 PM #2
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.
3rd June 2010, 01:59 PM #3
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.
7th June 2010, 09:38 AM #4
Microsoft DPM 2010 is pretty cheap and does a great job.
Backup exec really isn't the market leader any more.
7th June 2010, 07:36 PM #5
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.
you should be able to use managment studio express with SQL express to schedule a backup job in SQL itself
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.
6th August 2010, 01:19 PM #6
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
By Kamran7860 in forum Virtual Learning Platforms
Last Post: 23rd November 2010, 07:03 AM
By joe90bass in forum Windows
Last Post: 5th May 2010, 03:49 PM
By mrforgetful in forum MIS Systems
Last Post: 30th September 2009, 07:01 PM
By HodgeHi in forum Windows
Last Post: 20th February 2008, 05:37 PM
Last Post: 8th June 2006, 10:36 PM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)