Any help appreciated. I have a database created in SQL 2000 that is being
managed in SQL 2005. I need to copy it from the 2005 instance to a 2008
instance (different server on a different domain). I have successfully moved
two other databases (which were created natively in 2005) from the 2005
instance to 2008 using the copy database wizard in 2008. The remaining
database, however, refuses to be copied AND SQL Server will not write a LOG
FILE so that I can see the detailed results. I get a 12291 error as:

Log Name: Application
Source: SQLISPackage100
Date: 8/30/2009 9:00:45 AM
Event ID: 12291
Task Category: None
Level: Error
Keywords: Classic
User: ... <removed for posting>
Computer: ... <removed for posting>
Description:
Package "<removed for posting>" failed.
Event Xml:
<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
<System>
<Provider Name="SQLISPackage100" />
<EventID Qualifiers="16385">12291</EventID>
<Level>2</Level>
<Task>0</Task>
<Keywords>0x80000000000000</Keywords>
<TimeCreated SystemTime="2009-08-30T13:00:45.000Z" />
<EventRecordID>8759</EventRecordID>
<Channel>Application</Channel>
<Computer><removed for posting></Computer>
<Security UserID="S-1-5-21-1608752586-2612269214-3089130531-1001" />
</System>
<EventData>
<Data><removed for posting></Data>
</EventData>
</Event>

and then a 208 error as:

Log Name: Application
Source: SQLSERVERAGENT
Date: 8/30/2009 9:00:47 AM
Event ID: 208
Task Category: Job Engine
Level: Warning
Keywords: Classic
User: N/A
Computer: <removed for posting>
Description:
SQL Server Scheduled Job '<removed for posting>'
(0xEE5E45CC72A50A49BD7DD56BC9337E11) - Status: Failed - Invoked on:
2009-08-30 09:00:35 - Message: The job failed. The Job was invoked by User
xxx. The last step to run was step 1 (<removed for posting>_3_1_Step).
Event Xml:
<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
<System>
<Provider Name="SQLSERVERAGENT" />
<EventID Qualifiers="16384">208</EventID>
<Level>3</Level>
<Task>3</Task>
<Keywords>0x80000000000000</Keywords>
<TimeCreated SystemTime="2009-08-30T13:00:47.000Z" />
<EventRecordID>8760</EventRecordID>
<Channel>Application</Channel>
<Computer><removed for posting></Computer>
<Security />
</System>
<EventData>
<Data><removed for posting>_3_1</Data>
<Data>0xEE5E45CC72A50A49BD7DD56BC9337E11</Data>
<Data>Failed</Data>
<Data>2009-08-30 09:00:35</Data>
<Data>The job failed. The Job was invoked by User xxx. The last step
to run was step 1 (<removed for posting>_3_1_Step).</Data>
</EventData>
</Event>

Any ideas? Is this the correct group into which to post this issue?

Thanks to both of you. I did use the detach method and it worked fine. Thanks
again

"Erland Sommarskog" wrote: