VFPSQLDeveloper
asked on
Copy Wizard Failes with 'The database principal owns a schema in the database, and cannot be dropped'
I need to setup a scheduled copy of a database in SQL 2005 SP3.
When I use the Copy Database wizard it fails with the followig enries in the log:
OnError,XSERVER,FG\Adminis trator,XSE RVER_SSH_X SERVER_SSH _Transfer Objects Task,{CDnnnnnn-167C-48F8-B 52C-8413B5 937153},{2 19A71B7-E6 B4-4512-A2 9C-24310A2 44A87},31/ 10/2007 13:23:49,31/10/2007 13:23:49,0,0x,ERROR : errorCode=-1073548784 description=Executing the query "IF EXISTS (SELECT * FROM sys.database_principals WHERE name = N'tmt')
DROP USER [tmt]
" failed with the following error: "The database principal owns a schema in the database, and cannot be dropped.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.
helpFile= helpContext=0 idofInterfaceWithError={8B DFE893-E9D 8-4D23-973 9-DA807BCD C2AC}
StackTrace: at Microsoft.SqlServer.Manage ment.Dts.D tsTransfer Provider.E xecuteTran sfer()
at Microsoft.SqlServer.Manage ment.Smo.T ransfer.Tr ansferData ()
I cannot see why a simple copy of a database would need to drop users.
Any help would be much appreciated as I'm currenlty on site, scratching my head and swearing lots!
When I use the Copy Database wizard it fails with the followig enries in the log:
OnError,XSERVER,FG\Adminis
DROP USER [tmt]
" failed with the following error: "The database principal owns a schema in the database, and cannot be dropped.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.
helpFile= helpContext=0 idofInterfaceWithError={8B
StackTrace: at Microsoft.SqlServer.Manage
at Microsoft.SqlServer.Manage
I cannot see why a simple copy of a database would need to drop users.
Any help would be much appreciated as I'm currenlty on site, scratching my head and swearing lots!
Are there options to transfer database users? If so, and you've checked them, they probably do a drop before a create...
ASKER
I cant find any options like this, do you know where where would they be?
No, I can't see option for this (unlike on DTS sql 2000). Perhaps a red herring then.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Didn't know that.