By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,663 Members | 1,431 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,663 IT Pros & Developers. It's quick & easy.

Please suggest backup software

P: n/a
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.

Oct 6 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
"anton.aleksandrov" <an***@basehost-dot-net.no-spam.invalid> wrote in
message news:Y7********************@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.
Oct 6 '05 #2

P: n/a
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
Oct 6 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.