April 7, 2010 at 7:54 am
The error "E002" reads "Database xxx could not be successfully cloned on the test server"
The workload is a trace file (.trc).
I think that this has something to do with the hardware and software differences.
The version of sql server on production is:
Microsoft SQL Server 2005 - 9.00.4273.00 (X64)
Dec 3 2009 10:20:38
Copyright (c) 1988-2005 Microsoft Corporation
Standard Edition (64-bit) on Windows NT 5.2 (Build 3790: Service Pack 2)
The version of sql server on test is:
Microsoft SQL Server 2005 - 9.00.4035.00 (Intel X86)
Nov 24 2008 13:01:59
Copyright (c) 1988-2005 Microsoft Corporation
Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 2)
If you need more information please let me know.
Thanks,
James
April 7, 2010 at 4:46 pm
I found the following suggestions.
1. Make sure that you are not using an unsupported tuning option. The following link provides the unsupported tuning options: http://msdn.microsoft.com/en-us/library/ms345360.aspx
2. Ensure that the two SQL Server instances are the same SQL Server editions.
3. Ensure that the two machines belong to the same domain.
4. Use the Trusted Connection option in the DTA utility command.
It looks like the problem revolves around the servers being different versions.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
April 8, 2010 at 6:34 am
Thank you sir,
I found that as well.
Looks like I'll have to wait for our latest test server which will be 64-bit.
April 8, 2010 at 10:13 am
You're welcome.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply