I am unable to see the Copy Database option in SQL Server Management Studio 2008 R2.
Can anyone tell me whats going on please?
SQL Server Management Studio 2008 R2 – Copy Database Option Not Found
sql serversql-server-2008-r2ssms
Related Question
- Sql-server – SQL Server Management Studio generates error, can’t start
- Sql-server – sql server management studio 2008 sucks up with memory yielding .net runtime failure
- Sql-server – How to connect to SQL Server Analysis Server via Management Studio command line
- SQL Server Profiler – How to Download for SQL Server Management Studio
- Sql-server – use SQL Server Management Studio 2012 on a 2008 server
- Sql-server – hide system databases sql server management studio
- Sql-server – SQL Server Management Studio – Cannot connect – Method not found SqlConnectionInfo.set_IsActiveDirectoryUniversalAuth
- SQL Server Management Studio – Impossible to Expand Database
Best Answer
That's because you are clicking on the wrong thing. Don't right-click Databases, but you need to actually right-click the database that you want to copy, and under Tasks there is an option for Copy Database.... In other words, right-click on Database1 and then you'll see this option under Tasks.
As per @AaronBertrand's comment, though, it is highly recommended not to use the Copy Database Wizard. Just go with a backup and restore. It'll be less of a headache.
Edit: It seems as though this option is not available for SQL Server Express edition. When connecting to a SQL Server Express instance, you cannot run the Copy Database wizard. This is due to the fact that the two primary means of executing this task are unavailable in SQL Server Express Edition. First, the Detach/Reattach method relies on SQL Agent (presumably to copy the data and log files from source to destination), and SMO has been removed from 2008 R2, so that method is also unavailable in Express 2008 R2.