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
 SSIS and Import/Export (2005)
 Copy Database Wizard - Failed

Author  Topic 

sixside
Starting Member

12 Posts
Posted - 2011-02-03 : 23:20:05
I'm trying to make a copy of a current (and live) database to a new clone of the database for testing purposes. I am using the wizard which seems to fail on a view -- the error log is attached.

It seemed to create all of the mdf, ldf and ndf files of
the same size as the original db just fine. But none of the tables,
views, sprocs, etc... seem to be available when browsing the database
in Management Studio.

I looked at the views that it seemed to be failing on and nothing looks out of the ordinary to me.



#Fields: event,computer,operator,source,sourceid,executionid,starttime,endtime,datacode,databytes,message
OnPreValidate,SV2335,NT AUTHORITY\SYSTEM,CDW_SV2335_SV2335_2,{B16320F0-6B48-4E43-BB0D-4C5E43BE220E},{9FD8D5F8-232B-4039-9521-33AAA5C476CE},2/3/2011 4:18:31 AM,2/3/2011 4:18:31 AM,0,0x,(null)
OnPreValidate,SV2335,NT AUTHORITY\SYSTEM,SV2335_SV2335_Transfer Objects Task,{DA9470A6-5433-44FD-A7AE-13886AF2C5B0},{9FD8D5F8-232B-4039-9521-33AAA5C476CE},2/3/2011 4:18:31 AM,2/3/2011 4:18:31 AM,0,0x,(null)
OnPostValidate,SV2335,NT AUTHORITY\SYSTEM,SV2335_SV2335_Transfer Objects Task,{DA9470A6-5433-44FD-A7AE-13886AF2C5B0},{9FD8D5F8-232B-4039-9521-33AAA5C476CE},2/3/2011 4:18:31 AM,2/3/2011 4:18:31 AM,0,0x,(null)
OnPostValidate,SV2335,NT AUTHORITY\SYSTEM,CDW_SV2335_SV2335_2,{B16320F0-6B48-4E43-BB0D-4C5E43BE220E},{9FD8D5F8-232B-4039-9521-33AAA5C476CE},2/3/2011 4:18:31 AM,2/3/2011 4:18:31 AM,0,0x,(null)
PackageStart,SV2335,NT AUTHORITY\SYSTEM,CDW_SV2335_SV2335_2,{B16320F0-6B48-4E43-BB0D-4C5E43BE220E},{9FD8D5F8-232B-4039-9521-33AAA5C476CE},2/3/2011 4:18:31 AM,2/3/2011 4:18:31 AM,0,0x,Beginning of package execution.

Diagnostic,SV2335,NT AUTHORITY\SYSTEM,CDW_SV2335_SV2335_2,{B16320F0-6B48-4E43-BB0D-4C5E43BE220E},{9FD8D5F8-232B-4039-9521-33AAA5C476CE},2/3/2011 4:18:31 AM,2/3/2011 4:18:31 AM,0,0x,Maximum concurrent executables are set to 1.

OnPreExecute,SV2335,NT AUTHORITY\SYSTEM,CDW_SV2335_SV2335_2,{B16320F0-6B48-4E43-BB0D-4C5E43BE220E},{9FD8D5F8-232B-4039-9521-33AAA5C476CE},2/3/2011 4:18:31 AM,2/3/2011 4:18:31 AM,0,0x,(null)
OnPreExecute,SV2335,NT AUTHORITY\SYSTEM,SV2335_SV2335_Transfer Objects Task,{DA9470A6-5433-44FD-A7AE-13886AF2C5B0},{9FD8D5F8-232B-4039-9521-33AAA5C476CE},2/3/2011 4:18:31 AM,2/3/2011 4:18:31 AM,0,0x,(null)
OnPreValidate,SV2335,NT AUTHORITY\SYSTEM,SV2335_SV2335_Transfer Objects Task,{DA9470A6-5433-44FD-A7AE-13886AF2C5B0},{9FD8D5F8-232B-4039-9521-33AAA5C476CE},2/3/2011 4:18:31 AM,2/3/2011 4:18:31 AM,0,0x,(null)
OnPostValidate,SV2335,NT AUTHORITY\SYSTEM,SV2335_SV2335_Transfer Objects Task,{DA9470A6-5433-44FD-A7AE-13886AF2C5B0},{9FD8D5F8-232B-4039-9521-33AAA5C476CE},2/3/2011 4:18:31 AM,2/3/2011 4:18:31 AM,0,0x,(null)
OnProgress,SV2335,NT AUTHORITY\SYSTEM,SV2335_SV2335_Transfer Objects Task,{DA9470A6-5433-44FD-A7AE-13886AF2C5B0},{9FD8D5F8-232B-4039-9521-33AAA5C476CE},2/3/2011 4:18:31 AM,2/3/2011 4:18:31 AM,0,0x,Task just started the execution.
OnInformation,SV2335,NT AUTHORITY\SYSTEM,SV2335_SV2335_Transfer Objects Task,{DA9470A6-5433-44FD-A7AE-13886AF2C5B0},{9FD8D5F8-232B-4039-9521-33AAA5C476CE},2/3/2011 4:18:31 AM,2/3/2011 4:18:31 AM,0,0x,Connecting to server SV2335
OnInformation,SV2335,NT AUTHORITY\SYSTEM,CDW_SV2335_SV2335_2,{B16320F0-6B48-4E43-BB0D-4C5E43BE220E},{9FD8D5F8-232B-4039-9521-33AAA5C476CE},2/3/2011 4:18:31 AM,2/3/2011 4:18:31 AM,0,0x,Connecting to server SV2335
OnInformation,SV2335,NT AUTHORITY\SYSTEM,SV2335_SV2335_Transfer Objects Task,{DA9470A6-5433-44FD-A7AE-13886AF2C5B0},{9FD8D5F8-232B-4039-9521-33AAA5C476CE},2/3/2011 4:18:31 AM,2/3/2011 4:18:31 AM,0,0x,Connected to server SV2335
OnInformation,SV2335,NT AUTHORITY\SYSTEM,CDW_SV2335_SV2335_2,{B16320F0-6B48-4E43-BB0D-4C5E43BE220E},{9FD8D5F8-232B-4039-9521-33AAA5C476CE},2/3/2011 4:18:31 AM,2/3/2011 4:18:31 AM,0,0x,Connected to server SV2335
OnInformation,SV2335,NT AUTHORITY\SYSTEM,SV2335_SV2335_Transfer Objects Task,{DA9470A6-5433-44FD-A7AE-13886AF2C5B0},{9FD8D5F8-232B-4039-9521-33AAA5C476CE},2/3/2011 4:18:31 AM,2/3/2011 4:18:31 AM,0,0x,Connecting to server SV2335
OnInformation,SV2335,NT AUTHORITY\SYSTEM,CDW_SV2335_SV2335_2,{B16320F0-6B48-4E43-BB0D-4C5E43BE220E},{9FD8D5F8-232B-4039-9521-33AAA5C476CE},2/3/2011 4:18:31 AM,2/3/2011 4:18:31 AM,0,0x,Connecting to server SV2335
OnInformation,SV2335,NT AUTHORITY\SYSTEM,SV2335_SV2335_Transfer Objects Task,{DA9470A6-5433-44FD-A7AE-13886AF2C5B0},{9FD8D5F8-232B-4039-9521-33AAA5C476CE},2/3/2011 4:18:31 AM,2/3/2011 4:18:31 AM,0,0x,Connected to server SV2335
OnInformation,SV2335,NT AUTHORITY\SYSTEM,CDW_SV2335_SV2335_2,{B16320F0-6B48-4E43-BB0D-4C5E43BE220E},{9FD8D5F8-232B-4039-9521-33AAA5C476CE},2/3/2011 4:18:31 AM,2/3/2011 4:18:31 AM,0,0x,Connected to server SV2335
OnInformation,SV2335,NT AUTHORITY\SYSTEM,SV2335_SV2335_Transfer Objects Task,{DA9470A6-5433-44FD-A7AE-13886AF2C5B0},{9FD8D5F8-232B-4039-9521-33AAA5C476CE},2/3/2011 4:18:31 AM,2/3/2011 4:18:31 AM,0,0x,Transferring database aaamfi from SV2335 server as mfi11beta to SV2335 server
OnInformation,SV2335,NT AUTHORITY\SYSTEM,CDW_SV2335_SV2335_2,{B16320F0-6B48-4E43-BB0D-4C5E43BE220E},{9FD8D5F8-232B-4039-9521-33AAA5C476CE},2/3/2011 4:18:31 AM,2/3/2011 4:18:31 AM,0,0x,Transferring database aaamfi from SV2335 server as mfi11beta to SV2335 server
OnInformation,SV2335,NT AUTHORITY\SYSTEM,SV2335_SV2335_Transfer Objects Task,{DA9470A6-5433-44FD-A7AE-13886AF2C5B0},{9FD8D5F8-232B-4039-9521-33AAA5C476CE},2/3/2011 4:18:31 AM,2/3/2011 4:18:31 AM,0,0x,Added data file aaamfi_indexes in path E:\MSSQL\indexes\mfi11beta\mfi11beta_indexes.ndf to file group [Index_FG]
OnInformation,SV2335,NT AUTHORITY\SYSTEM,CDW_SV2335_SV2335_2,{B16320F0-6B48-4E43-BB0D-4C5E43BE220E},{9FD8D5F8-232B-4039-9521-33AAA5C476CE},2/3/2011 4:18:31 AM,2/3/2011 4:18:31 AM,0,0x,Added data file aaamfi_indexes in path E:\MSSQL\indexes\mfi11beta\mfi11beta_indexes.ndf to file group [Index_FG]
OnInformation,SV2335,NT AUTHORITY\SYSTEM,SV2335_SV2335_Transfer Objects Task,{DA9470A6-5433-44FD-A7AE-13886AF2C5B0},{9FD8D5F8-232B-4039-9521-33AAA5C476CE},2/3/2011 4:18:31 AM,2/3/2011 4:18:31 AM,0,0x,Added data file aaamfi in path C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\mfi11beta.mdf to file group [PRIMARY]
OnInformation,SV2335,NT AUTHORITY\SYSTEM,CDW_SV2335_SV2335_2,{B16320F0-6B48-4E43-BB0D-4C5E43BE220E},{9FD8D5F8-232B-4039-9521-33AAA5C476CE},2/3/2011 4:18:31 AM,2/3/2011 4:18:31 AM,0,0x,Added data file aaamfi in path C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\mfi11beta.mdf to file group [PRIMARY]
OnInformation,SV2335,NT AUTHORITY\SYSTEM,SV2335_SV2335_Transfer Objects Task,{DA9470A6-5433-44FD-A7AE-13886AF2C5B0},{9FD8D5F8-232B-4039-9521-33AAA5C476CE},2/3/2011 4:18:31 AM,2/3/2011 4:18:31 AM,0,0x,Added log file aaamfi_log in path E:\MSSQL\logs\mfi11beta_log.ldf
OnInformation,SV2335,NT AUTHORITY\SYSTEM,CDW_SV2335_SV2335_2,{B16320F0-6B48-4E43-BB0D-4C5E43BE220E},{9FD8D5F8-232B-4039-9521-33AAA5C476CE},2/3/2011 4:18:31 AM,2/3/2011 4:18:31 AM,0,0x,Added log file aaamfi_log in path E:\MSSQL\logs\mfi11beta_log.ldf
OnInformation,SV2335,NT AUTHORITY\SYSTEM,SV2335_SV2335_Transfer Objects Task,{DA9470A6-5433-44FD-A7AE-13886AF2C5B0},{9FD8D5F8-232B-4039-9521-33AAA5C476CE},2/3/2011 4:18:31 AM,2/3/2011 4:18:31 AM,0,0x,CREATE DATABASE [mfi11beta] ON  PRIMARY 
( NAME = N'aaamfi', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\mfi11beta.mdf' , SIZE = 23040128KB , MAXSIZE = UNLIMITED, FILEGROWTH = 10%), 
 FILEGROUP [Index_FG] 
( NAME = N'aaamfi_indexes', FILENAME = N'E:\MSSQL\indexes\mfi11beta\mfi11beta_indexes.ndf' , SIZE = 5120000KB , MAXSIZE = UNLIMITED, FILEGROWTH = 10%)
 LOG ON 
( NAME = N'aaamfi_log', FILENAME = N'E:\MSSQL\logs\mfi11beta_log.ldf' , SIZE = 8728896KB , MAXSIZE = UNLIMITED, FILEGROWTH = 10%)
OnInformation,SV2335,NT AUTHORITY\SYSTEM,CDW_SV2335_SV2335_2,{B16320F0-6B48-4E43-BB0D-4C5E43BE220E},{9FD8D5F8-232B-4039-9521-33AAA5C476CE},2/3/2011 4:18:31 AM,2/3/2011 4:18:31 AM,0,0x,CREATE DATABASE [mfi11beta] ON  PRIMARY 
( NAME = N'aaamfi', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\mfi11beta.mdf' , SIZE = 23040128KB , MAXSIZE = UNLIMITED, FILEGROWTH = 10%), 
 FILEGROUP [Index_FG] 
( NAME = N'aaamfi_indexes', FILENAME = N'E:\MSSQL\indexes\mfi11beta\mfi11beta_indexes.ndf' , SIZE = 5120000KB , MAXSIZE = UNLIMITED, FILEGROWTH = 10%)
 LOG ON 
( NAME = N'aaamfi_log', FILENAME = N'E:\MSSQL\logs\mfi11beta_log.ldf' , SIZE = 8728896KB , MAXSIZE = UNLIMITED, FILEGROWTH = 10%)
OnInformation,SV2335,NT AUTHORITY\SYSTEM,SV2335_SV2335_Transfer Objects Task,{DA9470A6-5433-44FD-A7AE-13886AF2C5B0},{9FD8D5F8-232B-4039-9521-33AAA5C476CE},2/3/2011 4:22:34 AM,2/3/2011 4:22:34 AM,0,0x,Created the database mfi11beta in destination SV2335
OnInformation,SV2335,NT AUTHORITY\SYSTEM,CDW_SV2335_SV2335_2,{B16320F0-6B48-4E43-BB0D-4C5E43BE220E},{9FD8D5F8-232B-4039-9521-33AAA5C476CE},2/3/2011 4:22:34 AM,2/3/2011 4:22:34 AM,0,0x,Created the database mfi11beta in destination SV2335
OnInformation,SV2335,NT AUTHORITY\SYSTEM,SV2335_SV2335_Transfer Objects Task,{DA9470A6-5433-44FD-A7AE-13886AF2C5B0},{9FD8D5F8-232B-4039-9521-33AAA5C476CE},2/3/2011 4:22:34 AM,2/3/2011 4:22:34 AM,0,0x,Transferring data to database mfi11beta from aaamfi
OnInformation,SV2335,NT AUTHORITY\SYSTEM,CDW_SV2335_SV2335_2,{B16320F0-6B48-4E43-BB0D-4C5E43BE220E},{9FD8D5F8-232B-4039-9521-33AAA5C476CE},2/3/2011 4:22:34 AM,2/3/2011 4:22:34 AM,0,0x,Transferring data to database mfi11beta from aaamfi
OnError,SV2335,NT AUTHORITY\SYSTEM,SV2335_SV2335_Transfer Objects Task,{DA9470A6-5433-44FD-A7AE-13886AF2C5B0},{9FD8D5F8-232B-4039-9521-33AAA5C476CE},2/3/2011 4:22:56 AM,2/3/2011 4:22:56 AM,0,0x,ERROR : errorCode=-1073548784 description=Executing the query "
CREATE VIEW dbo.ContributionDonations
AS
SELECT     ModelID, MemberID, SUM(DonationModelNet) AS Contribution, SUM(ISNULL(RedeemAmount,0)) AS RedeemAmount
FROM         dbo.Donation
WHERE     (DonationVerified = 1)
GROUP BY ModelID, MemberID





" failed with the following error: "Invalid object name 'dbo.Donation'.". 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,SV2335,NT AUTHORITY\SYSTEM,CDW_SV2335_SV2335_2,{B16320F0-6B48-4E43-BB0D-4C5E43BE220E},{9FD8D5F8-232B-4039-9521-33AAA5C476CE},2/3/2011 4:22:56 AM,2/3/2011 4:22:56 AM,0,0x,ERROR : errorCode=-1073548784 description=Executing the query "
CREATE VIEW dbo.ContributionDonations
AS
SELECT     ModelID, MemberID, SUM(DonationModelNet) AS Contribution, SUM(ISNULL(RedeemAmount,0)) AS RedeemAmount
FROM         dbo.Donation
WHERE     (DonationVerified = 1)
GROUP BY ModelID, MemberID





" failed with the following error: "Invalid object name 'dbo.Donation'.". 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,SV2335,NT AUTHORITY\SYSTEM,SV2335_SV2335_Transfer Objects Task,{DA9470A6-5433-44FD-A7AE-13886AF2C5B0},{9FD8D5F8-232B-4039-9521-33AAA5C476CE},2/3/2011 4:22:56 AM,2/3/2011 4:22:56 AM,0,0x,Database transfer is complete.
OnProgress,SV2335,NT AUTHORITY\SYSTEM,SV2335_SV2335_Transfer Objects Task,{DA9470A6-5433-44FD-A7AE-13886AF2C5B0},{9FD8D5F8-232B-4039-9521-33AAA5C476CE},2/3/2011 4:22:56 AM,2/3/2011 4:22:56 AM,100,0x,Transfer objects finished execution.
OnPostExecute,SV2335,NT AUTHORITY\SYSTEM,SV2335_SV2335_Transfer Objects Task,{DA9470A6-5433-44FD-A7AE-13886AF2C5B0},{9FD8D5F8-232B-4039-9521-33AAA5C476CE},2/3/2011 4:22:56 AM,2/3/2011 4:22:56 AM,0,0x,(null)
OnWarning,SV2335,NT AUTHORITY\SYSTEM,CDW_SV2335_SV2335_2,{B16320F0-6B48-4E43-BB0D-4C5E43BE220E},{9FD8D5F8-232B-4039-9521-33AAA5C476CE},2/3/2011 4:22:56 AM,2/3/2011 4:22:56 AM,-2147381246,0x,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,SV2335,NT AUTHORITY\SYSTEM,CDW_SV2335_SV2335_2,{B16320F0-6B48-4E43-BB0D-4C5E43BE220E},{9FD8D5F8-232B-4039-9521-33AAA5C476CE},2/3/2011 4:22:56 AM,2/3/2011 4:22:56 AM,0,0x,(null)
PackageEnd,SV2335,NT AUTHORITY\SYSTEM,CDW_SV2335_SV2335_2,{B16320F0-6B48-4E43-BB0D-4C5E43BE220E},{9FD8D5F8-232B-4039-9521-33AAA5C476CE},2/3/2011 4:22:56 AM,2/3/2011 4:22:56 AM,1,0x,End of package execution.

russell
Pyro-ma-ni-yak

5072 Posts
Posted - 2011-02-03 : 23:54:45
Don't waste your time with the copy database wizard. Just restore a backup of the source database.
Go to Top of Page
   

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources

Articles

Forums

Blogs

Contact Us

About the Site