SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2012 Forums
 SQL Server Administration (2012)
 Is this an issue?
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

elwoos
Flowing Fount of Yak Knowledge

United Kingdom
2048 Posts

Posted - 04/05/2013 :  06:04:37  Show Profile  Reply with Quote
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.

thanks

steve



-----------

Insanity: doing the same thing over and over again and expecting different results.

TG
Flowing Fount of Yak Knowledge

USA
5937 Posts

Posted - 04/05/2013 :  09:03:15  Show Profile  Reply with Quote
Could it be that the database owner is not a user (or login) on the new test 2012 server?
Do you see the same thing from a 2012 Management Studio?

Be One with the Optimizer
TG
Go to Top of Page

elwoos
Flowing Fount of Yak Knowledge

United Kingdom
2048 Posts

Posted - 04/05/2013 :  09:37:36  Show Profile  Reply with Quote
Hi TG, thanks for that, seems you are correct. The user wasn't a login.

steve

-----------

Insanity: doing the same thing over and over again and expecting different results.
Go to Top of Page

TG
Flowing Fount of Yak Knowledge

USA
5937 Posts

Posted - 04/05/2013 :  10:13:35  Show Profile  Reply with Quote
Cool.

Be One with the Optimizer
TG
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.05 seconds. Powered By: Snitz Forums 2000