Unsolved
This post is more than 5 years old
2 Posts
1
457
March 12th, 2015 14:00
How to tell which Databases are getting backed up
I'm new to EMC and have been given the keys to the car but do not know how to drive.
We have just added 2 DBs to a SQL server and I have been asked if the new DBs will be backed up-up since there is already a backup job that runs for SQL. I said no because I'm not sure if every DB is getting backed-up and I would think you would have to select which DBs you want to get back-up.
How can I tell and if I need to how do I select the added DBs to the backup job.
No Events found!
ble1
6 Operator
•
14.4K Posts
•
56.2K Points
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).