SQL Problems

[Mitchy6998]

I can't seem to restore an SQL Database. I want to redirect it. We're using SQL2000, and BENT 8.6 with SQL Agent. When I try a restore I get one of two erros (Depending on the recovery settings) Those errors are:

qlDumpExceptionHandler: Process 190 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.

and

Line 1: Incorrect syntax near ''.

What's up with that?

 

[SQLBill]

Is SQL and BE on multiprocessor servers?
Is SQL installed 'cluster aware'?
Are SQL and BE active on the same node and at the same time the backups are being done?
Is the BE v8.6 build 3808 or 3878?
If it's build 3878, has hotfix 4 (for SQL) been applied?

Apparently, there are problems/issues with using the BE SQL Agent.

-SQLBill

 

[Mitchy6998]

SIngle Processor
Not a Cluster, so no
SQL and BE are running at the same time on the server.
Build 3878... i'm not sure about the hotfix ... probably not.

 

[SQLBill]

You only meet two of the criteria, I met all of them and Veritas said that I HAD to have hotfix 4 applied or NONE of my tape backups will work. And when I did apply the latest build (to 3878) and hotfix 4, it only fixes the problem for all tapes made from that point on.

I don't know if the problem you are experiencing can be solved by the hotfix, but check it out.

I really suggest NOT using Veritas BE SQL Agent to backup SQL Server databases. I use the native SQL Server backup commands to create backup files on my hard drive (*.bak files) and then I use Veritas to copy those files to tape. Then when I need to restore, I copy from tape to hard drive and then use SQL Server commands to restore the files. It doesn't solve your problem, but it can keep you from having problems in the future.

-SQLBill

 

[Mitchy6998]

Is there a way to automate the SQL backup comamnds?

 

[SQLBill]

Yes. The easiest way is using Enterprise Manager. You can either use Database Maintenance to set up backup jobs, or you can create a JOB.

First you create a backup device in Query Analyzer:

exec sp_addumpdevice 'disk', 'mydbfull', 'C:\<path>\mydbfull.bak

Then the backup job would be:

backup database mydb to mydbfull with init

Check out the MS SQL Books OnLine (BOL) that are part of SQL Server.

-SQLBill