Hy ayodeji,

to restore your SQL database you use NBU  MS SQL Client from Windows server where is the SQL database Start-> Veritas -> NBU Agents -> NBU MS SQL Client. And with the Client confg you a restore script.

You open NBU MS SQL Client and go to File -> Restore SQL server object. and config your restore script.

OR,  

a example restore script:

OPERATION RESTORE
OBJECTTYPE DATABASE
NBIMAGE "DDCW1-S1000.MSSQL7.DDCW1-S1000\VMWARE.db.VM_Composer_DB.~.7.001of001.20090608190033..C"
SQLHOST "DDCW1-S1000"
SQLINSTANCE "WSUS"
NBSERVER "master server name"
BROWSECLIENT "DDCW1-S1000"
MAXTRANSFERSIZE 6
BLOCKSIZE 7
RESTOREOPTION REPLACE
RECOVEREDSTATE RECOVERED
NUMBUFS 2
ENDOPER TRUE

regards,
Marius D.

thanks marius,

i have some questions. in the script you typed, what is the sqlinstance? is it the clientname or what. also what is the sqlhost and browseclient

and lastly how do i run this script.

thanks.

:))

1. SQLINSTANCE is not the client name. The SQL database can have one or more instances. You must ask your SQL admin.

2. SQLHOST is the client where is the SQL database.

3. BROWSECLIENT is same with the SQLHOSTin my ex.

But when you don't know all this things is more easier with NBU  MS SQL Client. This  agent is installed along with the NetBackup client where also the  SQL is installed.
Start-> Veritas -> NBU Agents -> NBU MS SQL Client.

Look in NetBackup for MS SQL Server Admin Guide at page 89, 90 ....

Regards,
Marius D.

THANKS MARIUS.

I APPRECIATE.

MARIUS,

BUT IF I WANT TO RUN THE SCRIPT, HOW DO I DO IT?

Start-> Veritas -> NBU Agents -> NBU MS SQL Client.  ...go to File -> Manage Script Files. and from here select your script and open or start.

Regards,
Marius D.

many thanks marius.