SQL DB Restoration via Command line

[Karthikeyan_Sun]

Can anyone help me to restore a SQL DB from Command line.

I tried to use this below command but getting some errors.

bprestore.exe -S Master -C Client1 -D Client2 -t 15 -cm -md -L "C:\Program Files\VERITAS\NetBackup\logs\bprestore\progress.log" "Client1.MSSQL7.xxx\xxx.db.xxxx.~.7.001of001.20090514184452..C"

Am i wrong??

This is my Backup Details:

Source Client: Client1
Destination Client: Client2
Master Server: Master
Database name: Client1.MSSQL7.xxxx\xxxxx.db.xxxxxxx.~.7.001of001.20090514184452..C

[scorpy_582]

Hi Karthikeyan,

The command syntax looks ok.  

What happens when you run this command? Are you getting an error? Does the job come up in activity monitor?

bplist -S Master -C Client1 -t 15 -s <date> -e <date> "\*<database>*"

Run the bplist to see if the database you are trying to restore is displayed.

[rj_nbu]

HI

Create No.Restrictions on the master server

http://seer.entsupport.symantec.com/docs/316920.htm

-Rajeev