March 2, 2010 at 9:53 am
I've a scheduled job running that copies a databases from one server to another. The job has begun to fail with the following error :
"errorCode=-1073548784 description=Executing the query "IF EXISTS (SELECT * FROM sys.database_principals ..." 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."
I cannot see what has changed to bring about this error, any assistance would be most appreciated.
Nick
March 2, 2010 at 11:58 am
please provide the entire query instead of the part of it.
The probability of survival is inversely proportional to the angle of arrival.
March 3, 2010 at 3:33 am
I agree with sturner, you need to provide the full details for us to be able to help.
However, the error message suggest that your script is trying to drop the original database owner, without first changing ownership of the database. Was the original database owner login present in the copied database before this error started happening?
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply