Using MS Sql Server for BrightStor ARCserve DB

Posted on 2006-07-15
Last Modified: 2012-08-14

I hope my questions is relevant for this area:

I'm running CA BrightStor ARCserver r11.5 SP1 which maintains its own DB. Since I also have SqlServer 2000 in my organization I was wandering whether I can use it as ARCserve DB.

If so, How?


Question by:dneebrkr
  • 3
  • 2
LVL 22

Expert Comment

ID: 17116240
Yes. When installing ARCserve it lets you choose to use the default database or choose a MS SQL server. The SQL server does not have to be running on the same system as ARCserve. After ARCserve has been installed there is a utility in the ARCserve directory setupsql.exe which can be used to do the conversion.  

Author Comment

ID: 17120218
10x dovidmichel,

Managed to configure ARCserve to use SqlServer but now I have 1.5GB of the old DB. How can I purge these files in a safe way?
What puzzles me is that there are some files in C:\Program Files\CA\BrightStor ARCserve Backup\DATABASE which are still being modified.

10x again

LVL 22

Expert Comment

ID: 17123325
Catch 22

Now that the database has been converted over to MS SQL there is no way to go back and purge the old VLDB database.

What you can do to free up the space is to install ARCserve on another system.
Stop the ARCserve services and close the manager on the original system.
Delete the contents of the ARCserve Database directory.
Copy over the ARCserve Database directory from the new installation on the other system.

Author Comment

ID: 17163026
Why can't I just delete the old DB files?
LVL 22

Accepted Solution

dovidmichel earned 150 total points
ID: 17164002
It will probably be ok, but I can not say 100% sure that none of those will be needed.

Featured Post

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

In this article, I provide some information on storage disks which go into calculations that will help you figure out how much Input/output Operations Per Second (IOPS) your disk subsystem can deliver. To effectively size & tune up applications l…
I previously wrote an article addressing the use of UBCD4WIN and SARDU. All are great, but I have always been an advocate of SARDU. Recently it was suggested that I go back and take a look at Easy2Boot in comparison.
This video teaches viewers how to encrypt an external drive that requires a password to read and edit the drive. All tasks are done in Disk Utility. Plug in the external drive you wish to encrypt: Make sure all previous data on the drive has been …
This Micro Tutorial will teach you how to reformat your flash drive. Sometimes your flash drive may have issues carrying files so this will completely restore it to manufacturing settings. Make sure to backup all files before reformatting. This w…

895 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now