August 27, 2010 at 5:25 am
Hi iam getting the below error.
plz help me.
(1) Backup: use Enterprise Manager with COMPLETE backup setup, owners: dbo
and machine name\my login name.
(2) Copy backup file to another machine with SQL Server 2005.
(3) Start SQL Server Management Studio of SQL Server 2005.
(4) Use Restore to restore the backup to a database.
(5) Tables, Viewers, and SPs are OK. But Database Diagrams need to further
work.
the error massage. I can not either display the diagram or create new
diagram on the database. The error message:
does not have valid owner.
To continue, first use the Files page of the Database Properties dialog box
ot the Alter Authorization statement
to set the database owner to a valid login, then add the datatbase diagram
support objects."
August 27, 2010 at 5:44 am
As the error states:
The database does not have valid owner.
To continue, first use the Files page of the Database Properties dialog box or the Alter Authorization statement to set the database owner to a valid login
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply