Being the geek that I am whenever I see a file type with an extension like .db, that just says "open me!' So with a quick use of the handy dandy file bottle opener Notepad.exe I discovered that it is a SQLite Format 3 file.
Why is this important? It's not really, its just more interesting than anything. I've been working on a few different projects related to SnapManager 8.0 for SharePoint and was writing a document on the media service and how it creates indexes. The focus on my investigation was around how SMSP 8 backs up the SharePoint Web-Front End servers and Application Servers via a stream-based copy from the servers to the media service LUN. During this process we backup the SharePoint 14 (2010) or 15 (2013) hive along with any customizations, the Global Assembly Cache (GAC), Web parts and also the SMSP installation directory (Manager and/or Agent).
Before you begin you will need to have an SMSP backup of a WFE or Application Server from the Media Service LUN. This is typically on your Application Server as many people create a shared model running SharePoint services and the SMSP Media Service on that server. Access your LUN (via drive letter or mount point) and look for a similar directory structure and contents as shown in the screenshot below. The file that you want is the .db file, in my case it is named appmed1WFE_index.db; this was a backup of my Application Server. Notice that this file is 130MB so be sure if you make a copy for local use to play around with that you have enough space.
In order to review the contents of the .db file it's pretty simple, follow these steps:
Why would you ever want to do this? Curiosity, because you can, it's neat-o, but probably more likely a case of just knowing what's been backed up vs trusting it to the SMSP gods :-)