It depends how these DBs are configured. If you use standard instance and you have instance based backup (eg. MSSQL:) then all database under that instance are backed up. You can verify that in savegrp log or nsrsqlsv log on client. SQL admin can see the same from SQL mgmt studio and I think event log has also the record. If you use non standard instance, you must use following format: MSSQL$ . If you wish to abandon instance based backup and have each DB defined individually, you must create two client resources; one for DB backup and one for TLOG backup (one can argue this can be achieved with one instance which is also true, but less clean and certainly less secure). In such case you define backup as MSSQL: (or MSSQL$ : ).
You can also verify on server end what is in backup with nsrinfo command, for example:
nsrinfo -n mssql (this will list all backups in index db for namespace which belongs to SQL online backups).
ble1
4 Operator
•
14.4K Posts
1
March 12th, 2015 14:00
It depends how these DBs are configured. If you use standard instance and you have instance based backup (eg. MSSQL:) then all database under that instance are backed up. You can verify that in savegrp log or nsrsqlsv log on client. SQL admin can see the same from SQL mgmt studio and I think event log has also the record. If you use non standard instance, you must use following format: MSSQL$ . If you wish to abandon instance based backup and have each DB defined individually, you must create two client resources; one for DB backup and one for TLOG backup (one can argue this can be achieved with one instance which is also true, but less clean and certainly less secure). In such case you define backup as MSSQL: (or MSSQL$ : ).
You can also verify on server end what is in backup with nsrinfo command, for example:
nsrinfo -n mssql (this will list all backups in index db for namespace which belongs to SQL online backups).