Need to backup database while active (open files)

Occasionally, our Windows 2000 server will blue screen during the workday and we lose the day's data.

We also have a Windows 2003 server that runs our website.

We are looking at a continuous backup system that can copy the open files at regular intervals.  ( Please note that leaving the files open during backup is our main criteria for the backup plan.)

Backup Exec (now by Symantec) and ARCserve are outrageously expensive for a small business to acquire the most recent versions.  So, I'm looking at stepping back a version or two.  Please give me your thoughts on these apps along with any others that perform open file backups.
fuze44Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

NJComputerNetworksCommented:
what type of database?  SQL?
0
NJComputerNetworksCommented:
Symantic costs about $800

http://symantec.com/small_business/products/backup_recovery/bewin_sb_svr/features.html

Fast backups and restores of Exchange Server, SQL Server, and SharePoint Services.

Do you have SBS?  I don't think $800 is really all that expensive...



NTBACKUP now has the ability to backup open files...you just need to make sure VSS is enabled.
http://support.microsoft.com/kb/104169
0
mcsweenSr. Network AdministratorCommented:
If you are talking about SQL server; this ability is already integrated in v2000.  I would say you want the full recovery model.  After SQL makes it's backups you can have a scheduled job either use NTBackup to back it up to tape/share, or just use a batch file to copy to a share.  Have a look at the following links.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_bkprst_4i61.asp

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/howtosql/ht_7_backpt_1m0p.asp

0
Cloud Class® Course: Microsoft Office 2010

This course will introduce you to the interfaces and features of Microsoft Office 2010 Word, Excel, PowerPoint, Outlook, and Access. You will learn about the features that are shared between all products in the Office suite, as well as the new features that are product specific.

fuze44Author Commented:
Sorry, I should have specified the DB.  It's Visual Foxpro 8.0.

Would you really trust the integrity of your DB to Ntbackup?  Seems risky if users have the files open.
0
mcsweenSr. Network AdministratorCommented:
No, I wouldn't trust anything to ntbackup.

Being that you are using Foxpro you can use Arcserve's agent for open files...this will require you purchase the core Arcserve application and the BAOF, which will run about $900-$1000.

BackupExec and all other major backup software will have the same type of agent available for their software.  Arcserve is the only one I have used extensivly and I can say that it works great!



0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
mcsweenSr. Network AdministratorCommented:
Sorry, I just re-read your original post.

I have been using Arcserve since v7.  The Backup Agent for Open Files has always worked flawlessly.  So yes you can step back a couple versions and be just fine.
0
fuze44Author Commented:
Thanks, everyone.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Windows Server 2003

From novice to tech pro — start learning today.