troubleshooting Question

Copy Database fails from SQL 2000 to SQL 2005

Avatar of Tasburath
Tasburath asked on
DatabasesMicrosoft SQL Server 2005
4 Comments1 Solution4828 ViewsLast Modified:
Hey guys,

We are in the process of migrating from SQL 2000 to SQL 2005.  I have been copying databases using the copy databse task.  Several have worked and a couple have not.  One of the databases, I've tried to copy using both the SMO and detach and attach methods.  I created a user called sqlmove on both servers that had full rights to the database being moved.  Here are the event log errors I am getting:

Event Type:      Error
Event Source:      SQLISPackage
Event Category:      None
Event ID:      12291
Date:            10/24/2007
Time:            9:19:23 AM
User:            NT AUTHORITY\SYSTEM
Computer:      CCPSSQL3
Description:
Package "ShellPackage" failed.

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.



Event Type:      Error
Event Source:      SQLISPackage
Event Category:      None
Event ID:      12550
Date:            10/24/2007
Time:            9:19:23 AM
User:            NT AUTHORITY\SYSTEM
Computer:      CCPSSQL3
Description:
  Event Name: OnError
 Message: ERROR : errorCode=-1073548784 description=Executing the query "IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[INFORMATION_SCHEMA].[SCHEMATA]') AND OBJECTPROPERTY(id, N'IsView') = 1)
DROP VIEW [INFORMATION_SCHEMA].[SCHEMATA]
" failed with the following error: "Cannot drop the view 'INFORMATION_SCHEMA.SCHEMATA', 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.TransferExtraObjectsViaSmoTransfer()
 Operator: NT AUTHORITY\SYSTEM
 Source Name: ccpssql1_CCPSSQL3_Transfer Objects Task
 Source ID: {ADBFA98C-F532-41B0-847F-A64E5283CB87}
 Execution ID: {80FE58F7-9692-4BFF-8D62-D1A1C6B2D6A3}
 Start Time: 10/24/2007 9:19:23 AM
 End Time: 10/24/2007 9:19:23 AM
 Data Code: 0

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.




Event Type:      Error
Event Source:      SQLISPackage
Event Category:      None
Event ID:      12550
Date:            10/24/2007
Time:            9:19:23 AM
User:            NT AUTHORITY\SYSTEM
Computer:      CCPSSQL3
Description:
  Event Name: OnError
 Message: ERROR : errorCode=-1073548784 description=Executing the query "IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[INFORMATION_SCHEMA].[SCHEMATA]') AND OBJECTPROPERTY(id, N'IsView') = 1)
DROP VIEW [INFORMATION_SCHEMA].[SCHEMATA]
" failed with the following error: "Cannot drop the view 'INFORMATION_SCHEMA.SCHEMATA', 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.TransferExtraObjectsViaSmoTransfer()
 Operator: NT AUTHORITY\SYSTEM
 Source Name: CDW_CCPSSQL1_CCPSSQL3_15
 Source ID: {0083809D-C826-4135-85A3-F0AED14F01A7}
 Execution ID: {80FE58F7-9692-4BFF-8D62-D1A1C6B2D6A3}
 Start Time: 10/24/2007 9:19:23 AM
 End Time: 10/24/2007 9:19:23 AM
 Data Code: 0

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.



Event Type:      Error
Event Source:      SQLISPackage
Event Category:      None
Event ID:      12551
Date:            10/24/2007
Time:            9:19:24 AM
User:            NT AUTHORITY\SYSTEM
Computer:      CCPSSQL3
Description:
  Event Name: OnTaskFailed
 Message:
 Operator: NT AUTHORITY\SYSTEM
 Source Name: ccpssql1_CCPSSQL3_Transfer Objects Task
 Source ID: {ADBFA98C-F532-41B0-847F-A64E5283CB87}
 Execution ID: {80FE58F7-9692-4BFF-8D62-D1A1C6B2D6A3}
 Start Time: 10/24/2007 9:19:24 AM
 End Time: 10/24/2007 9:19:24 AM
 Data Code: 0

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.



Event Type:      Warning
Event Source:      SQLISPackage
Event Category:      None
Event ID:      12549
Date:            10/24/2007
Time:            9:19:24 AM
User:            NT AUTHORITY\SYSTEM
Computer:      CCPSSQL3
Description:
  Event Name: OnWarning
 Message: 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.

 Operator: NT AUTHORITY\SYSTEM
 Source Name: CDW_CCPSSQL1_CCPSSQL3_15
 Source ID: {0083809D-C826-4135-85A3-F0AED14F01A7}
 Execution ID: {80FE58F7-9692-4BFF-8D62-D1A1C6B2D6A3}
 Start Time: 10/24/2007 9:19:24 AM
 End Time: 10/24/2007 9:19:24 AM
 Data Code: -2147381246

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.



Event Type:      Error
Event Source:      SQLISPackage
Event Category:      None
Event ID:      12291
Date:            10/24/2007
Time:            9:19:24 AM
User:            NT AUTHORITY\SYSTEM
Computer:      CCPSSQL3
Description:
Package "CDW_CCPSSQL1_CCPSSQL3_15" failed.

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.



Event Type:      Warning
Event Source:      SQLSERVERAGENT
Event Category:      Job Engine
Event ID:      208
Date:            10/24/2007
Time:            9:19:24 AM
User:            N/A
Computer:      CCPSSQL3
Description:
SQL Server Scheduled Job 'CDW_CCPSSQL1_CCPSSQL3_15' (0xCD500A1D3D00BF4892FEA96952F7F21A) - Status: Failed - Invoked on: 2007-10-24 09:17:45 - Message: The job failed.  The Job was invoked by User sqlmove.  The last step to run was step 1 (CDW_CCPSSQL1_CCPSSQL3_15_Step).

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.



I know this is a lot of information, but I am not a SQL DBA and it's greek to me.  DOes anyone have any ideas?
ASKER CERTIFIED SOLUTION
Nightman
CTO

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 4 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 4 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros