SEO

#1 (**permalink**) 02-29-2008, 01:32 PM

Hello
First of all - sorry for may be stupid question, but as I am not
Win* administrator and my field is *nix, I am a little bit stuck wit
a problem, presented to me by one of the customers. He has few window
boxes with some webfile and (most important) - mssql database. And h
asks for a backup. I found some company, which offers us IBM's Tivol
software, but my opinion is that they want a little bit too much fo
it and also, from my *nix experiece, I know there should be man
other products, probably cheaper and better. If not - we will us
that Tivoli. So we need to backup mssql data and some file
somewhere. The best would be on some ftp.
Can anyone please suggest a good and simple way of making such kind o
backup

Many thanks
Anton

#2 (**permalink**) 02-29-2008, 01:32 PM

"anton.aleksandrov" <anton@basehost-dot-net.no-spam.invalid> wrote in
message news:Y7WdnavrKoN-UNneRVn_vQ@giganews.com...
> Can anyone please suggest a good and simple way of making such kind of
> backup?

You could in theory just use Microsoft's built-in backup tool, though you'd
have to schedule a job to export the SQL Server database as you'll have
problems with open files. The usual starting point for an small to medium
installation that deals with the SQL Server open file issue for you is to
look at the options from Veritas, which are popular and relatively
inexpensive, though Dantz (now EMC) Retrospect also has an SQL Server
add-on.

D.

#3 (**permalink**) 02-29-2008, 01:32 PM

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

Please suggest backup software