anton.aleksandrov wrote:
Hello,
First of all - sorry for may be stupid question, but as I am not a
Win* administrator and my field is *nix, I am a little bit stuck with
a problem, presented to me by one of the customers. He has few windows
boxes with some webfile and (most important) - mssql database. And he
asks for a backup. I found some company, which offers us IBM's Tivoli
software, but my opinion is that they want a little bit too much for
it and also, from my *nix experiece, I know there should be many
other products, probably cheaper and better. If not - we will use
that Tivoli. So we need to backup mssql data and some files
somewhere. The best would be on some ftp.
Can anyone please suggest a good and simple way of making such kind of
backup?
Many thanks,
Anton.
I'd simply use the SQL Server Backup to backup the databases. Then you
have the backups as normal files you can backup to whatever media you
want using whatever program you want.
If it's important data though (and of course they are otherwise you
wouldn't bother backing them up...) I'd suggest that you get somebody on
site to help with the setup. Even though it's not difficult to set up
the jobs, it's not to much help if you don't know the basics of the
Backup/Restore procedure.
You'll have to put a few thoughts into the backup strategy - or maybe
more correctly the Restore strategy. You'll have to talk to the customer
and find out how critical the data is. How many data can he afford to
loose (I.e. do you need to backup the log and if yes how often?). How
long downtime will the customer accept? The size of the database will
also be a factor here.
Remember that a backup is not worth anything if you don't know how to
restore it and if you don't know how many data you'll get back when you
manage to restore it...:-).
HTH
Regards
Steen