02-01-2009 11:32 PM
hi,
I am using veritas netbackup version 6.5.it is working correctly for all my paths.but it can not backup from my .mdf and .ldf files of our sql server 2005.which configuration should I do? do I need to install any agent?please help me.
Best Regards,
luckyman
Solved! Go to Solution.
02-02-2009 12:00 AM
There are two solutions:
1. Use MS SQL agent (it is a part of Windows client) to backup MS SQAL files (recommended approach).
2. Shut down MS SQL instance before backing up its datafiles (looks like workaround)
02-02-2009 12:00 AM
There are two solutions:
1. Use MS SQL agent (it is a part of Windows client) to backup MS SQAL files (recommended approach).
2. Shut down MS SQL instance before backing up its datafiles (looks like workaround)
02-02-2009 02:20 AM
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
02-02-2009 09:17 AM
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).
02-02-2009 04:49 PM
Hi.
You should read the following manual.
Veritas NetBackup for Microsoft SQL Server Administrator's Guide
02-14-2009 11:25 PM
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
02-17-2009 04:59 AM
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
02-27-2009 10:06 PM
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
03-02-2009 01:07 AM
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
09-26-2009 11:05 PM
09-28-2009 12:34 AM