Scan an expired MSSQL backup

NMM SQL Saveset generates metasaveset per backup.  This saveset is always marked as INCR backup type.  Hence, you need make the same changes to the metadata saveset to browse in the NMM SQL UI.

Hello, ElanC.

Thanks for your feedback, but after review my SQL full backups, I cannot see any incr savesets... all of them are MSSQL:, and the index saveset.

Let me add some general issues here as there seems to be a general misunderstanding:

1. Change save set mode to 'nonrecyclable'. o.k.

2. Change retention date for that save set (nsrmm -e -S )

      Policies only apply to new save sets - once they exists in the media index, changing a policy does have no influence.

3. "scanner -i -S XXXXXX" will only work if there is file index info at all.

    A lot of db backups already start their lifecycle not as 'browsable' but as 'recoverable' - which makes sense as you most

    likley never receover a part of such save set.

4. Do not use "nsrck -L7" - it does not make sense in this case.

Bingo, a few comments.

1. Change save set mode to 'nonrecyclable'. o.k.

2. Change retention date for that save set (nsrmm -e -S )

      Policies only apply to new save sets - once they exists in the media index, changing a policy does have no influence.

You are correct. It was a misunderstand. I changed the retention date for the saveset. Obviously, tha's why I wrote the command.

3. "scanner -i -S XXXXXX" will only work if there is file index info at all.

I am not agree with you. If you use scanner, as I understand, Networker reads the media and repopulate the file index. If I had index backup, I would recover it using nsrck.

4. Do not use "nsrck -L7" - it does not make sense in this case.

I am agree, it was a desperate action.

In case I lost all my backup environment, and I only had a tape with a DB expired backup, I would like to know that I could recover it. I think scanner is done for this case... Am I wrong?

Hello ledugarte,

I still doubt on browing the SQL saveset's in the NMM SQL UI.  I am very much sure that SQL Meta saveset's needed for the UI browsing (NMM SSMS and NWMSSQL.exe). I think, command line restore should be possible for the backups without SQL Metasavesets.

Thanks,

Elango C

Hi ledugarte,

have you checked the NMM Advanced Recovery Guide? Maybe that helps.

NMM 8.2.1 Advanced Recovery Guide, Rev 1, Page 49: Recovering NMM data from recoverable or eligible for recycling save sets

Regards

mkeil

Hello, ElanC.

After review in NMM  Advance Recovery Guide, I can see that metadata savesets exists. Thanks for your help. I will do a research.

Thanks. I didn't know about this guide. I will do a research.

Hi Ledugarte,

You may want refer the Admin/user guide for NW SQL backups.  I think, there is a mention of meta savesets.   Let me know queries, if any.

Thanks,

Elango C