Copy Database fails

Hi,

I am getting the error below when I try to copy a database.

OnError,SQLSERVER2005,AUTORIDADE NT\SYSTEM,XX_XX_XX_XX_SQLSERVER2005_Transfer Objects Task,{E2404B46-E96F-47DA-91F7-ACBB914BD89D},{6D380D9F-9A9E-42F6-AE14-B8852DF6B8E9},16/6/2007 22:24:02,16/6/2007 22:24:02,0,0x,ERROR : errorCode=0 description=CREATE DATABASE failed. Some file names listed could not be created. Check related errors. helpFile= helpContext=0 idofInterfaceWithError={8BDFE893-E9D8-4D23-9739-DA807BCDC2AC}
StackTrace: em Microsoft.SqlServer.Management.Dts.DtsTransferProvider.ExecuteTransfer()
em Microsoft.SqlServer.Management.Smo.Transfer.TransferData()
em Microsoft.SqlServer.Dts.Tasks.TransferObjectsTask.TransferObjectsTask.TransferDatabasesUsingSMOTransfer()

I am using SQL Server 2005 SP2 (9.0.3042) with Windows XP SP2 inside a virtual machine (Virtual PC 2007 version 6.0.156.0).

I am copying the database to a local drive (C:\) and the error occurs after 45 minutes.

Using SQL Server 2000 takes 40 minutes to copy the same database without problem.

Do you have enough disk space on the virtual hard drive and your physical hard drive?|||

Yes, there is enough space both on the virtual and physical hard drive.

Copy a database

Hi,
I need to copy a database from sqlserver 2005 to another server sqlserver
2005 too.
I am administrador of the server source, and dbowner of a empty database
into the server destination.
Can someone help with this?
Thanks in advance
Hi,
If you use SQL Server logins, remember about this:
http://support.microsoft.com/kb/274188
Do you know how deal with domain users when restore database from DomainA
(logins from DomainA) to server in DomainB?
Regards,
anxcomp
|||I like back-up restore also but you can also dettach the database, copy the
files using your operating system and then attach the copied database to
your destination instance
Sincerely,
John K
Knowledgy Consulting
http://knowledgy.org/
Atlanta's Business Intelligence and Data Warehouse Experts
"Vipper" <Vipper@.discussions.microsoft.com> wrote in message
news:0166FB25-A835-4901-A0D7-8CB509847B22@.microsoft.com...
> Hi,
> I need to copy a database from sqlserver 2005 to another server sqlserver
> 2005 too.
> I am administrador of the server source, and dbowner of a empty database
> into the server destination.
> Can someone help with this?
> Thanks in advance