why netbackup does not backup mdf and ldf files?

hi,

thanks alot for your reply.but how can I configure MS sql agent?

I see sql server agent (MSSQLSERVER) in the services.do you mean that  or another agent?

Best Regards

Third solution.

have the dba's backup to a backup dir on disk

set up a policy to backup the backup dir to tape.  ( just time it so the backup to disk is finished before you have the schedule to tape start).

Hi.

You should read the following manual.

Veritas NetBackup for Microsoft SQL Server Administrator's Guide

Dear sir,

thank you for your helpfull pdf.I could finally backup the database.but when I want to restore it I see the following error.would you please help me what to do?

OPERATION RESTORE
OBJECTTYPE DATABASE
DATABASE "testdb"
# The following image is type: Full
NBIMAGE "dedicate-3.MSSQL7.DEDICATE-3.db.testdb.~.7.001of001.20090214152437..C"
SQLHOST "DEDICATE-3"
NBSERVER "DENA"
BROWSECLIENT "dedicate-3"
MAXTRANSFERSIZE 6
BLOCKSIZE 7
RESTOREOPTION REPLACE
RECOVEREDSTATE RECOVERED
TRACELEVEL MAX
NUMBUFS 2
ENDOPER TRUE

INF - RESTORE STARTED USING
Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86)
Oct 14 2005 00:33:37
Copyright (c) 1988-2005 Microsoft Corporation
Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 2)
Batch = C:\Program Files\Veritas\NetBackup\dbext\mssql\temp\__10_32_58_228_00.bch, Op# = 1.
INF - Using backup image dedicate-3.MSSQL7.DEDICATE-3.db.testdb.~.7.001of001.20090214152437..C
INF - restore database "testdb" from VIRTUAL_DEVICE='VNBU0-5384-7076-1234681378' with  stats = 10, blocksize = 65536, maxtransfersize = 4194304, buffercount = 2, replace , norecovery
INF - Number of stripes: 1, Number of buffers per stripe 2.
ERR - Error in CreateEx: 0x80770007.
    CONTINUATION: - Failed to recognize the SQL Server instance name.
INF - OPERATION #1 of batch C:\Program Files\Veritas\NetBackup\dbext\mssql\temp\__10_32_58_228_00.bch FAILED with STATUS 1 (0 is normal). Elapsed time = 0(0) seconds.
INF - Results of executing <C:\Program Files\Veritas\NetBackup\dbext\mssql\temp\__10_32_58_228_00.bch>:
<0> operations succeeded. <1> operations failed.
 

Best regards,

luckyman

Are you restoring the SQL database to the server and instance you backed it up from? Also did you create the restore script on the same server?

Thanks Giro

hi,

the priviouse error happens when I want to restore on the backup server. I can restore backup from my netbackup client (where my sql server is installed) successfully.but suppose my client is damaged and I want to restore my database ,some where else.I want to know if I can restore my mdf and ldf files in a path on my netbackup server? and restore it directly to my sql server when it is necessary?

Best regards,

luckyman

Hi,

I believe you can't restore the flat files to a server as it was backed up by an SQL agent.

You need to restore the files to an SQL instance on another server. To do this you need to create the below file on your master server.

Installation path\NetBackup\db\altnames\No.Restrictions

This allows the a client to search through another clients backups to enable the restore.

Once this is done you log on to the client to you want to restore to and it will let you select another clients backups to restore. You need to do the backup as a Move template otherwise the restore will fail.

This is just a rough overview of how to do it but all this info is in the Netbackup SQL admin guide which should fill in the gaps!

Cheers

Giro