What Arcserve products in necesary to buy?

[JUANCARLOS]

I have a Small Business Server 4.5 (with NT 4.0, SQL Server 7.0, Exchange 5.5, and a Web Server) all running in the same server.

I want to make a backup automatically 23:00pm every day excepts sunday. all users are out off conection at this time.

I call a representative of Arcserve and suggest:
Arcserve Enterprice edcition, SQL Agent, Exchange Agent, OLP, Disater recovery.

The question is which buy? and Why.

Thanks in advance.

JCHR

 

[monkeylizard]

ArcServe Enterprise Edition is the basic piece and must be purchased.

SQL Agent will allow you to backup your SQL databases via ArcServe. One alternative to this is to schedule backups within SQL which will create *.bak files. You can then back these .bak files up with ArcServe.

Not sure what OLP is, unless it's a new name for OFA (Open Files Agent). This allows you to backup files that Windows, SQL, Exchange, etc. may have open when the backup runs. this is pretty much a necessity.

Exchange Agent allows you to backup your Exchange Mailboxes. I don't know much about it...don't use it.

Disaster Recovery Agent is nice, but you'll have to determine if it's a necessity. What it does is allow you to boot a crashed server from diskettes and restore the ENTIRE server (not select directories) directly from tape. Without this agent, a disaster would require you to re-load NT and ArcServe (along with the tape drive), then restore from tape. You get the same results either way, but the Agent makes it much faster. Monkeylizard
-Isaiah 35-

 

[Guest_imported]

How to import the bak file?

 

[Guest_imported]

Exchange agent is a thing of beauty. Use it, but only if you know how to install it!!! Follow the docco to the LETTER. OLP is the Open License Program allowing you to license with one license file across your enterprise. A good thing. You can do SQL dumps and back these up, but the SQL agent is a lot prettier. At the moment, there is no such thing as Enterprise edition, just advanced edition. you will need this to back anything up.

hope this helps,

ARCserve guru - brightstor@hotmail.com

 

[monkeylizard]

To answer atmqb7's question, within MS-SQL, schedule a job (I won't tell you how, if you need help, look in the SQL section of TekTips) to perform a backup of the databases you need. These backups will be created in a file with a .bak extension in whatever directory you tell SQL to use. Then just use ArcServe to backup the .bak file just like any other file.

I have to use this method on a SQL6.5 server that sits in another domain where Domain Trusts are not working quite right and I can't make the SQL agent work. Monkeylizard
-Isaiah 35-