We help IT Professionals succeed at work.

Sql 2008 management studio no copy database wizard

Medium Priority
271 Views
Last Modified: 2012-06-21
When I right click on the management folder in the sql server management studio, the only options I get are reports and refresh, I do not get the backup copy database and so on
Comment
Watch Question

http://msdn.microsoft.com/en-us/library/ms188664.aspx

Are you sure you have proper permissions?

Commented:
And not a Sql Server Express edition?

Author

Commented:
I am logging into sql 2008
Server type Database Engine
Server name SQL-08\SQLEXP_VIM
Authentication Windows Authentication
User name Clinton\administrator

I am trying to copy databases from sql 2005 to the new sql 2008. Using the SQL 2008 server.

Commented:
And possible in 2005? Both for the express version or the permission.

How to see if it's Express edition? On which it does not work.
select @@version

Open in new window

http://support.microsoft.com/kb/321185
Microsoft SQL Server 2008 (SP1) - 10.0.2531.0 (X64)   Mar 29 2009
10:11:52   Copyright (c) 1988-2008 Microsoft Corporation  Express
Edition
(64-bit) on Windows NT 6.1 <X64> (Build 7600: )

or
SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), [b]SERVERPROPERTY ('edition')[/b]

Open in new window


Do this on both the 2005 and the 2008.

Author

Commented:
I am going to unistall and reinstall the 2008 and test it again

Author

Commented:
I reinstalled the sql 2008, applied the SP3 update, when I am trying to connect to the database engin I get the error:

ITLE: Connect to Server
------------------------------

Cannot connect to SQL-08\SQLEXP_VIM.

------------------------------
ADDITIONAL INFORMATION:

A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not
 found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote
 connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (Microsoft SQL Server, Error: -1)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=-1&LinkId=20476

Explore More ContentExplore courses, solutions, and other research materials related to this topic.