SQL7 as backupdatabase in ASO7.0 1

[Ivanhoe]

I use ASO7.0 (ARCserve 2000) on Windows 2000 SP2 with SQL7.0 SP3 as backupdatabase. My db is around 5GB, and i prune old records every 60 days.

I've had problems using SQL as db for my ASO7.0. It was not about reliability, but performance when browsing in restore by tree. It was very, very slow, even we made a maintenance job on the SQL server.

But what you need to do, is a little SQL script, you execute in the SQL Query Analyzer.

The script look's like this:
USE ASDB
GO
CREATE
INDEX [IX_astpdat_pathid] ON [dbo].[astpdat] ([pathid], [sesid])
ON [PRIMARY]
GO

I had a issue at CA, but they have aproved the solution, for not making other problems.

Hope this can help someone, it really gives a lot in performance. Before i could wait around 60 sec. at every step down a tree, now only 1-2 sec.:-V

Regards
Ivanhoe

 

[ARCserveGuru]

Thanks for this tip, I am sure it will prove more than valuable to the frustrated people running the ARCserve database on SQL.

guru

 

[maxel01]

Oh, that's the solutions that make anyone happy.

Small but with the the woooooshh effect

It works perfectly now.

Thank you Ivanhoe, you save my life ;-)