473,289 Members | 2,087 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,289 software developers and data experts.

Please suggest backup software

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
2 1730
"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
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

4
by: Bishop | last post by:
For example the files in a computers windows directory and profile directory that the application is running on.
4
by: Wanhua Yi | last post by:
Hi all, anybody out there with experience in using EMC's Time Finder Software and DB2 UDB EEE on AIX ? Especially in using BCV for Backup ? Any white papers ?
6
by: aj | last post by:
I currently have 2 official DB2 Workgroup Edition licenses for my 2 v8 production servers. I also have tech support/software upgrade agreements in place for both servers. I am interested in...
0
by: David | last post by:
My environment is as following: (1) DB on AIX OS: AIX 4.3.3 ML 09 DB: DB2 UDB EE 7.2 Fixpak 05 Backup Software: Veritas Netbackup 4.5 DB Volume: 750GB LTO Drive: 4 drivers Backup time elapsed:...
3
by: Peter Postlbauer | last post by:
Hi, I try to perform an incremental backup of an entire database. My problem: the option's for incremental backup are disabled. OS: W2003Srv UDB: 8.1 Any idea? Are there any parameters, which I...
6
by: Sue W via AccessMonster.com | last post by:
We have a database that is in use 24/7, and does not get backed up by our network backup software because it is always open. Does anyone have experience with backup software specifically designed...
1
by: David Van D | last post by:
Hi there, A few weeks until I begin my journey towards a degree in Computer Science at Canterbury University in New Zealand, Anyway the course tutors are going to be teaching us JAVA wth bluej...
2
by: William | last post by:
I've been tasked with taking over the support for a client's SQL Server database. I'm not a DBA by profession, I'm a software developer who uses SQL Server as a database designer. The clients...
16
by: john | last post by:
How safe is it to back up a single user mdb when it is opened. No tables are opened at the time of the backup. The only object that is open is the form from which the backup code is being run....
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: Aftab Ahmad | last post by:
Hello Experts! I have written a code in MS Access for a cmd called "WhatsApp Message" to open WhatsApp using that very code but the problem is that it gives a popup message everytime I clicked on...
0
by: Aftab Ahmad | last post by:
So, I have written a code for a cmd called "Send WhatsApp Message" to open and send WhatsApp messaage. The code is given below. Dim IE As Object Set IE =...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
by: marcoviolo | last post by:
Dear all, I would like to implement on my worksheet an vlookup dynamic , that consider a change of pivot excel via win32com, from an external excel (without open it) and save the new file into a...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.