Recommend Backup Solution

jamoor · 3 Dec 2009 at 23:37

Essentially I am after a backup software for backing upto tape/hdd/usb stick.

I have read up on acronis, but it seems quite expensive, I have SBS 2003 w/SQL server.

I obviously need to backup data and the SQL server.

It looks to me like you have to buy acronis for small business and a SQL backup thingy seperate.

Anyone have any other recommendations?

Showboat · 4 Dec 2009 at 09:18

*Not a SQL guru by any stretch***

Can you not configure SQL to do its own backup to file, and then use SBS to backup itselft with the included software?

I aint used NTbackup since NT4.0, but once you get it working it's quite good!

http://www.microsoft.com/smallbusiness/support/articles/backup_restore_sbs2003.mspx

namnoc · 4 Dec 2009 at 11:07

If you use the 30 day Acronis trial, they do email you an offer to buy it with a fiver off.

bledd · 4 Dec 2009 at 11:20

A fiver is a small dent when it costs £500-1000

jamoor · 4 Dec 2009 at 12:28

bledd. said:
A fiver is a small dent when it costs £500-1000

Exactly LOL
If they call me I will try to talk them down,

I have downloaded it anyway and will install later.

bledd · 4 Dec 2009 at 12:54

Call them up for a better quote, they may give you one

jamoor · 10 Dec 2009 at 11:08

Hmm, Installed acronis and their Normal product seems ok, their SQL server barely works, gives me a chance to test out tech support

Sin_Chase · 10 Dec 2009 at 11:21

Yes you can configure SQL to do schedules backups to file. You can then dump this to whatever media/drive you are backing up to without an SQL agent.

BackupExec and Arcserve are enterprise level backup solutions with add-on agents and options.

Ntbackup will do the job though, depends how complex a site it is really. If it's all on the SBS box then Ntbackup is normally sufficient and will do System State quite happily using VSS.

raycarmody · 10 Dec 2009 at 13:28

Hi,

What I tend to do (unless the client as a desire to purchase the open file agent)

Is as the guys above say use SQL server to backup to a file ( make sure you select backup all databases, this wil take system / model and any databases you add in future)

I use SQL Agent to run this export and at the end kick off a dos script to move the backup either to a shared server that gets backed up or then allow the standard backup to take this file.

I move the file because SQL server will just keep adding to the file ( you can set to overwrite all backup sets but I have had trouble with SQL not doing this and being onsite for short periods of time the move has provided a quick fix).

Ray

jamoor · 10 Dec 2009 at 15:15

raycarmody said:
Hi,

What I tend to do (unless the client as a desire to purchase the open file agent)

Is as the guys above say use SQL server to backup to a file ( make sure you select backup all databases, this wil take system / model and any databases you add in future)

I use SQL Agent to run this export and at the end kick off a dos script to move the backup either to a shared server that gets backed up or then allow the standard backup to take this file.

I move the file because SQL server will just keep adding to the file ( you can set to overwrite all backup sets but I have had trouble with SQL not doing this and being onsite for short periods of time the move has provided a quick fix).

Ray

How do you get it to backup to a schedule?

Also, RE: acronis - I don't think it has a feature to backup your system state :/ active directory etc.

jamoor · 10 Dec 2009 at 15:38

Also on SBS 2003, I remember there used to be a feature where you could roll back to an older version of a particular file, does anyone know what this is called?

GhostlyPea · 10 Dec 2009 at 15:44

Volume Shadow Copy/Service

- Pea0n

raycarmody · 11 Dec 2009 at 09:16

jamoor said:
How do you get it to backup to a schedule?

you can use sql server agent which version of SQL server you using?

jamoor · 11 Dec 2009 at 10:10

raycarmody said:
jamoor said:

How do you get it to backup to a schedule?

you can use sql server agent which version of SQL server you using?

Click to expand...

SQL server 2005, do you mean the SQL Managment studio?

raycarmody · 27 Dec 2009 at 19:51

HI sorry you probably already done this

SQL 2005 is fine ....pretty much everything goes via Management studio ( sorry i am lazy ..I do not follow our Oracle DBA point of view re graohical tools)

Within SQL agent you can create new job and it will ask you what you want to do...and then just follow the wizard...

If you can not figure it out can do a few screen shots from my system and pass them over ( it may be that I am taking completly against what you want ....)

Ray