error on database copy. - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

error on database copy.

Author

Topic

chedderslam
Posting Yak Master

223 Posts

Posted - 2008-11-25 : 20:24:32

I am trying to use the copy database functionality. I am copying a database from my web host's server to my local instance. It fails with the following error, please help, thanks:
OnInformation,SMITH-FILESERVE,NT AUTHORITY\SYSTEM,sqla17_webcontrolcenter_com_SMITH-FILESERVE_Transfer Objects Task,{2D51B61E-DBE5-493D-9E76-065CAC402E92},{43B9DCA0-3746-4A09-BF05-DC4E35060D1A},11/25/2008 7:03:27 PM,11/25/2008 7:03:27 PM,0,0x,Transferring data to database jury-duty from jury-duty
OnInformation,SMITH-FILESERVE,NT AUTHORITY\SYSTEM,CDW_SQLA17_SMITH-FILESERVE_1,{B81AD9BB-9B77-416D-BCE5-A862711D0BE9},{43B9DCA0-3746-4A09-BF05-DC4E35060D1A},11/25/2008 7:03:27 PM,11/25/2008 7:03:27 PM,0,0x,Transferring data to database jury-duty from jury-duty
OnError,SMITH-FILESERVE,NT AUTHORITY\SYSTEM,sqla17_webcontrolcenter_com_SMITH-FILESERVE_Transfer Objects Task,{2D51B61E-DBE5-493D-9E76-065CAC402E92},{43B9DCA0-3746-4A09-BF05-DC4E35060D1A},11/25/2008 7:04:26 PM,11/25/2008 7:04:26 PM,0,0x,ERROR : errorCode=-1073548784 description=Executing the query "EXEC dbo.sp_changedbowner @loginame = N'sasql', @map = false
" failed with the following error: "Cannot find the principal 'sasql', because it does not exist or you do not have permission.". 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={8BDFE893-E9D8-4D23-9739-DA807BCDC2AC}
StackTrace: at Microsoft.SqlServer.Management.Dts.DtsTransferProvider.ExecuteTransfer()
at Microsoft.SqlServer.Management.Smo.Transfer.TransferData()
at Microsoft.SqlServer.Dts.Tasks.TransferObjectsTask.TransferObjectsTask.TransferDatabasesUsingSMOTransfer()
OnError,SMITH-FILESERVE,NT AUTHORITY\SYSTEM,CDW_SQLA17_SMITH-FILESERVE_1,{B81AD9BB-9B77-416D-BCE5-A862711D0BE9},{43B9DCA0-3746-4A09-BF05-DC4E35060D1A},11/25/2008 7:04:26 PM,11/25/2008 7:04:26 PM,0,0x,ERROR : errorCode=-1073548784 description=Executing the query "EXEC dbo.sp_changedbowner @loginame = N'sasql', @map = false
" failed with the following error: "Cannot find the principal 'sasql', because it does not exist or you do not have permission.". 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={8BDFE893-E9D8-4D23-9739-DA807BCDC2AC}
StackTrace: at Microsoft.SqlServer.Management.Dts.DtsTransferProvider.ExecuteTransfer()
at Microsoft.SqlServer.Management.Smo.Transfer.TransferData()
at Microsoft.SqlServer.Dts.Tasks.TransferObjectsTask.TransferObjectsTask.TransferDatabasesUsingSMOTransfer()
OnProgress,SMITH-FILESERVE,NT AUTHORITY\SYSTEM,sqla17_webcontrolcenter_com_SMITH-FILESERVE_Transfer Objects Task,{2D51B61E-DBE5-493D-9E76-065CAC402E92},{43B9DCA0-3746-4A09-BF05-DC4E35060D1A},11/25/2008 7:04:26 PM,11/25/2008 7:04:26 PM,0,0x,Database transfer failed for 1 database(s).
OnProgress,SMITH-FILESERVE,NT AUTHORITY\SYSTEM,sqla17_webcontrolcenter_com_SMITH-FILESERVE_Transfer Objects Task,{2D51B61E-DBE5-493D-9E76-065CAC402E92},{43B9DCA0-3746-4A09-BF05-DC4E35060D1A},11/25/2008 7:04:26 PM,11/25/2008 7:04:26 PM,100,0x,Transfer objects finished execution.
OnTaskFailed,SMITH-FILESERVE,NT AUTHORITY\SYSTEM,sqla17_webcontrolcenter_com_SMITH-FILESERVE_Transfer Objects Task,{2D51B61E-DBE5-493D-9E76-065CAC402E92},{43B9DCA0-3746-4A09-BF05-DC4E35060D1A},11/25/2008 7:04:26 PM,11/25/2008 7:04:26 PM,0,0x,(null)
OnPostExecute,SMITH-FILESERVE,NT AUTHORITY\SYSTEM,sqla17_webcontrolcenter_com_SMITH-FILESERVE_Transfer Objects Task,{2D51B61E-DBE5-493D-9E76-065CAC402E92},{43B9DCA0-3746-4A09-BF05-DC4E35060D1A},11/25/2008 7:04:26 PM,11/25/2008 7:04:26 PM,0,0x,(null)
OnWarning,SMITH-FILESERVE,NT AUTHORITY\SYSTEM,CDW_SQLA17_SMITH-FILESERVE_1,{B81AD9BB-9B77-416D-BCE5-A862711D0BE9},{43B9DCA0-3746-4A09-BF05-DC4E35060D1A},11/25/2008 7:04:26 PM,11/25/2008 7:04:26 PM,-2147381246,0x,SSIS Warning Code DTS_W_MAXIMUMERRORCOUNTREACHED. The Execution method succeeded, but the number of errors raised (1) reached the maximum allowed (1); resulting in failure. This occurs when the number of errors reaches the number specified in MaximumErrorCount. Change the MaximumErrorCount or fix the errors.

OnPostExecute,SMITH-FILESERVE,NT AUTHORITY\SYSTEM,CDW_SQLA17_SMITH-FILESERVE_1,{B81AD9BB-9B77-416D-BCE5-A862711D0BE9},{43B9DCA0-3746-4A09-BF05-DC4E35060D1A},11/25/2008 7:04:26 PM,11/25/2008 7:04:26 PM,0,0x,(null)
PackageEnd,SMITH-FILESERVE,NT AUTHORITY\SYSTEM,CDW_SQLA17_SMITH-FILESERVE_1,{B81AD9BB-9B77-416D-BCE5-A862711D0BE9},{43B9DCA0-3746-4A09-BF05-DC4E35060D1A},11/25/2008 7:04:26 PM,11/25/2008 7:04:26 PM,1,0x,End of package execution.

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-11-25 : 20:27:04

Use backup/Restore for simpler solution.

chedderslam
Posting Yak Master

223 Posts

Posted - 2008-11-25 : 21:48:04

This is from a hosted server. I don't have access to the file system to do a backup. Can I backup a remote sql server db to a local file somehow?

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-11-25 : 22:41:11

Then how can you Copy database ? You need to have permissions to do it.

chedderslam
Posting Yak Master

223 Posts

Posted - 2008-11-25 : 22:52:10

I can run the copy. I can also get into the dialog to do a backup, but the only place I can back up to in their server. I do not have access to that filesystem once the backup is done.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources