12-22-2008 03:22 AM
12-22-2008 06:43 AM
12-22-2008 06:45 AM
12-22-2008 07:25 AM
now must to look my .bch file??? with more entries?? One exemple pls. And what can i do when i don´t know the database name???? I don´t have access.
Marius Demeter.
12-23-2008 12:22 AM
How to look my *.bch file??? with another databases entries. Eg.pls!?!?
Regards,
Marius Demeter
12-23-2008 12:40 AM
Marius, I don't actually use this but it IS at the end of the MSSQL Admin Guide:
(Have cut down the excerpt, so only showing 2 of the stated 5 operations)
"...
In this sample batch file, five separate backups will be performed sequentially.
Remember that each operation is required to be completely specified.
OPERATION BACKUP
DATABASE "BUSINESS"
OBJECTTYPE DATABASE
SQLHOST "CADOO"
SQLINSTANCE "SECOND"
NBSERVER "CHISEL"
MAXTRANSFERSIZE 0
BLOCKSIZE 7
STRIPES 5
ENDOPER TRUE
OPERATION BACKUP
DATABASE "RECREATION"
SQLHOST "CADOO"
SQLINSTANCE "SECOND"
NBSERVER "CHISEL"
MAXTRANSFERSIZE 0
BLOCKSIZE 7
OBJECTTYPE TRXLOG
ENDOPER TRUE
etc
etc
etc
This sample is identical to the previous one except that the first operation
contains BATCHSIZE 3. This tells NetBackup to start the first three operations
in parallel, then after these are all completed begin the next set of 3. In this case,
since there are just five operations, the second batch set will contain two
operations.
BATCHSIZE 3
OPERATION BACKUP
DATABASE "BUSINESS"
OBJECTTYPE DATABASE
SQLHOST "CADOO"
SQLINSTANCE "SECOND"
NBSERVER "CHISEL"
MAXTRANSFERSIZE 0
BLOCKSIZE 7
STRIPES 5
ENDOPER TRUE
OPERATION BACKUP
DATABASE "RECREATION"
SQLHOST "CADOO"
SQLINSTANCE "SECOND"
NBSERVER "CHISEL"
MAXTRANSFERSIZE 0
BLOCKSIZE 7
OBJECTTYPE TRXLOG
ENDOPER TRUE
etc
etc
etc
..."
12-23-2008 01:13 AM
Hi Andy,
and this *.bch file must be same on each sql server. Or just on one server it´s enough.
Regards,
Marius D.
12-23-2008 01:19 AM
and one more question:
what is this >>SQLINSTANCE "SECOND"<< ????? What is a SQLINSTANCE??? Where I found this name???
Regards,
Marius D.
12-23-2008 01:35 AM
Hi Marius
Again, this is in the Admin Guide, but...
"...
■ Place the batch file in the install_path\NetBackup\DbExt\MsSql\
folder.
■ Batch files must reside on the host from which they executed. If performing
actions on a remote host, the batch file must reside on that remote host.
..."
and further...
"...
■ If SQLINSTANCE $ALL is used, then it must appear in the first operation of
the batch file. Each operation in the batch file will be performed for all SQL
Server instances on the client where the batch file is executed. Also, it is not
necessary to specify a SQLHOST or SQLINSTANCE on any subsequent
operations.
..."
which would intimate to me that the batch files are placed & executed on each client & that its contents would depend on the instances on that client (?) - I stand to be corrected because, as I said before, I don't use this personally.
12-23-2008 01:47 AM
@MariusD wrote:What is a SQLINSTANCE???
Had to Google this one!
"...
On a given server you can run multiple SQL Server services, each with their own ports, logins, and databases. Each of these services is called an "instance" of SQL Server. You can further categorize these as the "primary instance" and "named instances." The primary instance can be accessed using just the server name or IP address. The named instances, on the other hand, are accessed by appending a backslash and the instance name. For instance, to connect to the instance called "abc" on the local server, use: "127.0.0.1abc".In SQL Server 2005, you can have up to 50 instances running simultaneously on a server.
..."
and elsewhere
"...
You can have many databases (unlimited?) in one instance, so there is rarely any need for more than one instance on a server.
..."
12-23-2008 02:02 AM
when I have 2 database on to one client(Windows Server 2008) and the *.bch file is:
"
SQLINSTANCE $ALL
OPERATION BACKUP
DATABASE $ALL
NBSERVER "xxxxxxxxx"
MAXTRANSFERSIZE 0
BLOCKSIZE 10
ENDOPER TRUE
"
Is this file right???? while for this client don´t work the backup.
One question: On the Master server - in sql policy -are 3 clients but in "Backup Selection", i have just 1 entrie "c:\Program Files\Veritas\NetBackup\DbExt\MsSql\bkup.bch. When on one client the backup script hed anothe name..then can I on "backup selection" another entrie add??
Regards,
Marius D.
12-23-2008 02:26 AM
@Anton Panyushkin wrote:
Well, Windows Server 200u8 is relatively new piece of software from MS. Please check if your version of Netbackup supports this OS.
Did you check your compatibility?
Veritas NetBackup (tm) 6.x Database Agent Compatibility (Updated December 9, 2008)
12-23-2008 02:42 AM
Thanks a lot for this file. I think this file will resolve my problem :).
Regards,
Marius Demeter
12-23-2008 09:46 PM
I suggest you open a case with symantec support.
You will probably end up needing an updated file sqlvdi.dll or some such thing.