We have just tried upgrading a test Content Management System database from 2008 to 2012.
To do this we first took last nights backup of live and restored to the test system, then ran the upgrade wizard. As far as the database is concerned all seemed well though the CMS isn't working and I just wanted to eliminate SQL Server as the source of the issue.
I'm using the 2008 version of Management Studio. If I look at the live instance (on SQL Server 2008) I can see that the name of the database owner is correct and if I go to Database properties, then click on files, it has the same owner. If however I do that on test (which is SQL Server 2012 with database compatibility set to 2008), then I see the same database owner but if I go to Properties and files, there is no entry for the database owner.
Is this an issue? I don't understand how the two can be different.
Insanity: doing the same thing over and over again and expecting different results.