SQL restore problem

[rookie11]

Hi guys

we hav a SQL policy which runs daily . it was completed success yesterday. but when i m trying to check backedup database in netbackup database extension GUI. i could nt find it. though dates are correct.

then i ran command bplist -C SERVER1 -t 15 -R

bplist -C SERVER1 -t 15 -k <policyname> -R

bplist -C SERVER1 -t 15 -k <policyname> -R -s start date -e end date 

but all commands giving me EXIT STATUS 227: no entity was found 

plz help

[Yasuhisa_Ishika]

Try to add "/" in tail.

bplist -C SERVER1 -t 15 -k <policyname> -R -s start date -e end date /

[Marianne]

Have you confirmed that -C <client-name> corresponds exactly with client name seen in Activity Monitor (eg shortname vs FQDN, lowercase vs uppercase)? The spelling of Client name needs to match exactly with name stored in image database.

Also remember to add the \ at the end of the command:

bplist -C <Client-name> -t 15 -s <start date> -e <end date> -R \

[rookie11]

i found this in dbclient logs:

20:07:05.521 [21736.22260] <4> CSQLDBMSOptions::OnInitDialog: INF - It is unknown whether NetBackup for Microsoft SQL Server is installed on host machine

20:07:51.070 [21736.22260] <4> DBConnect: INF - Logging into SQL Server with DSN <NBMSSQL_temp_21736_22260>, SQL userid <captain> handle <0x00e52dd0>.

20:07:51.101 [21736.22260] <4> DBConnect: INF - Logging into SQL Server with DSN <NBMSSQL_temp_21736_22260>, SQL userid <captain> handle <0x00e52868>.

20:07:51.101 [21736.22260] <4> CGlobalInformation::CreateDSN: INF - A successful connection to SQL Server <server\SERVER_2> has been made using Trusted security with DSN <NBMSSQL_temp_21736_22260> using standard userid <captain>.

20:07:51.101 [21736.22260] <4> DBDisconnect: INF - Logging out of SQL Server with handle <0x00e52868>

20:07:51.101 [21736.22260] <4> DBConnect: INF - Logging into SQL Server with DSN <NBMSSQL_temp_21736_22260>, SQL userid <captain> handle <0x00e52868>.

20:07:51.117 [21736.22260] <4> DBDisconnect: INF - Logging out of SQL Server with handle <0x00e52868>

20:07:51.351 [21736.22260] <16> CUserLogin::ModifyDefaultSQLUseridAndPasswordInReg: ERR - Internal error. See the dbclient log for more information.

20:07:51.351 [21736.22260] <32> CUserLogin::ModifyDefaultSQLUseridAndPasswordInReg: ERR - Error in CryptExportKey (for determining size): 2148073475. The text follows:

20:07:51.351 [21736.22260] <1> CUserLogin::ModifyDefaultSQLUseridAndPasswordInReg:     CONTINUATION: - Bad Key.

20:07:51.351 [21736.22260] <16> CSQLDBMSOptions::OnApply: ERR - Error encountered entering your SQL host/instance into the registry.

[Marianne]

Did you show those errors to the SQL dba?

Did you check the SQL Application and Error logs? SQL VDI log?

[Mark_Solutions]

2008 SQL Server? Right click and "Run As Administrator" when opening the NetBackup SQL GUI - sounds like you do not have rights / local admin rights?