Skip to Content

SQL Server 2005 Error Message - when Right Clicking a DB > Properties

Hi

We are running SQL Server 2005 SP03, we have x15 databases (excluding SBO-COMMON, RSP, Coresuite), all x15 databases have Maintenance Plans setup, tasks ticked:

- Shrink Database

- Clean Up History

- Back up Database (Full)

- Maintenance Clean-up task

These Maintenance Plans have been running for over 5 months now, we have recently changed our VMware Virtual Server over to a Hosted VMware Virtual Server, now when I right click on a certain database and select "Properties" I get the following error message with SQL Server:

Property Owner is not available for Database '[Turquoise_Moon_Live]'. This property may not exist for this object, or may not be retrievable due to insufficient access rights. (Microsoft.SqlServer.Smo)

Could the Maintenance Plan be preventing me to run the Properties against a relevant DB (I have tested this by restoring a DB that doe not have a Maintenance Plan and the Properties works, tested this on SBO-COMMON and it works as well)

Can anyone agree with me or let me know what else might be the issue as I have checked the Server Roles & the Users Credentials for SQL and all seems well.

Regards

Kurt Walters

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jul 30, 2010 at 01:59 PM

    Hi Kurt Walters,

    Have you reset those plans after moving the database to new VM?

    Thanks,

    Gordon

    Add a comment
    10|10000 characters needed characters exceeded

    • Hi Gordon

      Thanks very much for the help, I basically did a Detach and Re-attach and the properties option becomes available for the relevant database on SQL Server 2005 now.

      So as you said it basically carried across the data / security settings from the old server to the new therefore prompting me to detach and re-attach.

      Regards

      Kurt Walters

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.