|
|
Posted by Steen Persson (DK) on 10/01/89 11:29
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
Navigation:
[Reply to this message]
|