Any good 3rd party backup program?

[eggy168]

Hi,
I would like to get some advices from any of you, experts, who is using 3rd party backup program for the SQL Server 2000? I heard ArcServe 9V is not a good one, any one has an idea?
thank you.

 

[JayKusch]

We use Veritas but not as a direct backup utility. We first create our backups to a remote server as a disc backup. From there we use Veritas for backing up the ahhh backup files - lol.

In this manner we are able to keep our backups on tape and off site in case of a disaster and then we are able to use the remote server disc backups for restores needed in a timely manner.

Thanks

J. Kusch

 

[SQLBill]

I also use Veritas' Backup Exec (versions 8.6 and 9.0) and am happy with them. Jay and I do our backups the same way...use SQL Server to back them up to disk and then Backup Exec to backup (I like the term copy) those backup files to tape. It makes it a two step process, but you don't have to buy Veritas' SQL Agent and it's good practice to use the built-in functions wherever possible. Who whould know the best method to backup SQL Server - SQL Server or Veritas???????

-SQLBill

 

[eggy168]

Thanks Jay and SQLBill,
I am wondering how it works? Do they have table-level restore in Veritas? I guess my big concern is the table-level restore for the SQL Server 2000.
Thanks so much

 

[SQLBill]

What do you mean by table-level restore? SQL Server can not restore JUST a table.

-SQLBill

 

[mrdenny]

I'm using CommVault to backup our SQL Servers. Unlike Bill and Jay we've purchased the SQL Agent so that the CommVault system can do the backups directly.

I'm not sure how the Veritas backup works, but the CommVault agent logs into the SQL Server and creates a virtual device on the server, pointing that virtual device, to a tape drive on the tape unit. Then it runs a normal backup database or backup log command using the virtual device it created as the backup device.

Denny

 

[ecobb]

Much like Bill and Jay, I have our SQL Servers set up to run their own backups and place the .BAK files in a folder on our Veritas server. Then the Veritas server just copies everything in that folder to the tape when it runs. Kinda like Bill said, let SQL Server do what it's supposed to (backups), and let Veritas stick it on the tapes.

Hope This Helps!

Ecobb
- I hate computers!

 

[eggy168]

Hi
I am really having trouble restore table level from SQL Server 2000. Can anyone help?
I download the trial verison of ArcServe v9, they don't let me do restore from table-level to the database. And I tried the suggestions using the Veritas and CommVault. None of them is working.
Can anyone help? Is SQL Server 2000 has the option to restore only certain table(s) instead of the whole database or I am day dreaming that they have this option available at all?
Thanks so much

 

[ecobb]

No, you can only restore the whole database. You can't go in and restore only certain tables, it's all or nothing.

Hope This Helps!

Ecobb
- I hate computers!

 

[eggy168]

Thanks Ecobb. I think you help a lot to clear the situation.

 

[SQLBill]

In SQL Server there is only one way that I know of to restore just a table. And it's not simple. You restore the whole database assigning it another name (ie. restore DB1 as DB2). Then CREATE the missing table in the original database and then import the information from the second database.

It's a real lengthy process and is really easier to just restore the whole database.

-SQLBill

 

[BuGlen]

If the table in question contains any relational reference to other tables in the database, you will not want to just restore a single table as you may loose the referential integrity. It's always best practice, IMO, to restore all tables in the db to ensure data intregrity.

Glen Appleton

VB.Net student.