I'm using Branched Versioning. I've learned that I cannot write SQL queries in SQL Server to query my base table directly (in hopes of replicating the results of a versioned view), but that didn't stop me from trying.
I did look at the SDE schema tables in SQL Server to see if I could figure out how the REST API could mine records from specific versions/queries. Granted I didn't look for hours, but it didn't look to me that the SQL Database alone contained the data necessary to make the queries.
That leads me to believe that the datastore on the enterprise you published your service to is storing additional information about your branch versioned data. Is backing up my branch versioned database using SQL Server alone enough to ensure data security, or do I need to backup my SQL Database and the Enterprise Datastore? Any suggestions about best practices would be appreciated.