SQL - database

[MariusD]

I have 3 server with SQL database. One client is with Windows Server 2003 and this client work. I can do backup for  this client database. But for another 2 clients (windows server 2008) isn´t work. Come status code 2 - none of the requested files were backed up.

bkup.bch file:
"
SQLINSTANCE $ALL
OPERATION BACKUP
DATABASE $ALL
SQLHOST "xxxxxxxxxxx"
NBSERVER "xxxxxxxxxxx"
MAXTRANSFERSIZE 0
BLOCKSIZE 7
ENDOPER TRUE
"

Any Idee????

Thanks,
Marius Demeter

[Anton_Panyushki]

Well, Windows Server 200u8 is relatively new piece of software from MS. Please check if your version of Netbackup supports this OS.

[Moeman]

I've had this problem as well when I select all instances to backup.  I've had better success picking each databse individually for my .bch file.  So your .bch file will contain more entries.

[MariusD]

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. 

[MariusD]

How to look my *.bch file??? with another databases entries. Eg.pls!?!?

Regards,

Marius Demeter

[Andy_Welburn]

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

..."

[MariusD]

Hi Andy,

and this *.bch file  must be same on each sql server. Or just on one server it´s enough.

Regards,

Marius D.

[MariusD]

and one more question:

what is this >>SQLINSTANCE "SECOND"<< ????? What is a SQLINSTANCE??? Where I found this name???

Regards,

Marius D.

[Andy_Welburn]

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.

[Andy_Welburn]

---

@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.

..."

[MariusD]

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.

[Andy_Welburn]

---

@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)

[MariusD]

Thanks a lot for this file. I think this file will resolve my problem :).

Regards,

Marius Demeter

[Stumpr2]

I suggest you open a case with symantec support.

You will probably end up needing an updated file sqlvdi.dll or some such thing.