We recently changed out one of our core database apps. It was a hosted solution and the new one we are hosting. Rather than do a dirty data conversion we opted to rekey the data. Fair enough.
With the previous application, we had (literally) hundreds of custom crystal reports for pulling data easily. Before the migration we pulled the majority of the core reports for hard reference for the future and the service was discontinued.
They have provided a hefty *.bak file from MSSQL server which contained our old database. Our intention is to have it available with our old reports in case of an audit or we need to look up data we may not have reported out earlier.
I have restored the database to a MSSQL 2008 server and can see data in the tables, however if I select rows from the views there is no data available. Of course the reports are built off of the views so they are displaying no data either once relinked.
What am I missing in regards to the Views not populating?