I need to copy an existing database within my SQL server 2005 to a new database within the same SQL Server instance. I've read a lot about the Copy Database Wizard but can't see this option within any menu of SQL Server 2005 Management Studio. As far as I know this option should be shown after right clicking at a database and selecting of 'Tasks'. It shows other options as Detach, Back-up, Restore but not he Copy function. I also don't see any wizard option when selecting 'Management'. I've already updated to SQL Server 2005 SP2 but that didn't help.
I've installed MS SQL Server 2005 from my MSDN-Professional subscription. After installation, while SQL Server Management Studio is shown without an 'Express' addition, it has named the SQL Server instance as Servername\SQLExpress which I find confusing. The full name of SQL Server Management Studio is shown with the version number 9.0.3042 which ensures that it is SQL Server 2005 SP2 version and not the Express edition.
Do I need to install something additionaly to display the Copy Database Wizard? Very frustrating that this option is not shown and there is no documentation how to toget it. Is this maybe a known bug?
regards
Oscar
Copy Database should be the last item on the Tasks menu.
On my machine with developer edition:
SELECT @.@.VERSION;
Returns: Microsoft SQL Server 2005 - 9.00.3042.00 (Intel X86) Feb 9 2007 22:47:07 Copyright (c) 1988-2005 Microsoft Corporation Developer Edition on Windows NT 6.0 (Build 6000: )
SELECT SERVERPROPERTY('Edition ');
Returns: Developer Edition
|||In my case:
SELECT @.@.VERSION;
Returns : Microsoft SQL Server 2005 - 9.00.3042.00 (Intel X86) Feb 9 2007 22:47:07 Copyright (c) 1988-2005 Microsoft Corporation Express Edition with Advanced Services on Windows NT 5.1 (Build 2600: Service Pack 2)
SELECT SERVERPROPERTY('Edition ');
Returns : Express Edition with Advanced Services
So it looks like I've installed the Express edition. This is hard to believe since I used my Official MSDN Subscription to install SQL Server 2005. Important to inform, I even can't update the Manager Studio with the SQL Server Studio Express SP2 since it reports that the Express edition has not been installed.
Besides, As I've noticed, The SQL Server 2005 Express users have this Copy Database option and in my case it doesn't show this menu option.
Where did you got your Developer edition from?
|||I have an MSDN subscription I can't remember the new name...it replaced universal.
You can download the trial edition from:
http://www.microsoft.com/sql/downloads/trial-software.mspx
|||
As I already own an MSDN subscription why should I download a trial edition?
Can anyone reply whether the Express edition lacks the Copy Database option like my case?
|||Oscar99 wrote:
Can anyone reply whether the Express edition lacks the Copy Database option like my case?
Correct, the Express edition does not have the Copy Database Wizard. If you have an MSDN subscription you can download SQL Server Developer Edition. If you don't, you can buy it for $50.
Paul A. Mestemaker II
Program Manager
Microsoft SQL Server Manageability
http://blogs.msdn.com/sqlrem/
i don't think so
In my case:
SELECT @.@.VERSION;
Returns: Microsoft SQL Server 2005 - 9.00.3042.00 (Intel X86) Feb 9 2007 22:47:07 Copyright (c) 1988-2005 Microsoft Corporation Developer Edition on Windows NT 6.0 (Build 6000: )
SELECT SERVERPROPERTY('Edition ');
Returns: Developer Edition
but i ca'nt see this option
|||Thanks Paul,
Finally everything clear now.
Meanwhile I've reinstalled my MSDN july 2006 version and now the option for CDW shows up! As to MS I don't understand why MS removes such basic and simple functions within the Express edition.
regards,
Oscar
|||I upgraded a SQLExpress instance to Standard and the copy command did not come with it. It was enough of a reason for me to uninstall Express and reinstall Standard and restore the pertinent dbs. What a hassle. I'd call that a bug.
No comments:
Post a Comment