?
Solved

Running Copy Database from SQL Management Studio fails

Posted on 2008-10-22
6
Medium Priority
?
735 Views
Last Modified: 2008-12-06
Hi experts,

Can someone let me know what the permissions should be for the login that's being used to carry-out a Copy Database command from a remote Management Studio?  

I keep getting a failure in the final stage of the process and the error in the event log that looks most important is:

"Message: Could not read metadata, possibly due to insufficient access rights."

Any clues or guidance would be most appreciated?
0
Comment
Question by:jammy-d0dger
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
6 Comments
 
LVL 37

Expert Comment

by:momi_sabag
ID: 22775242
are you using attach detach method or the other method?
0
 
LVL 7

Accepted Solution

by:
Cedric_D earned 2000 total points
ID: 22778159
Make a backup and restore it to new db. Maybe you'll have enough access rights for that.
0
 

Author Comment

by:jammy-d0dger
ID: 22788038
to momi_sabag... I'm using the SQL object manager method as the attach/detach option is greyed-out for me.

0

Featured Post

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

There are some very powerful Dynamic Management Views (DMV's) introduced with SQL 2005. The two in particular that we are going to discuss are sys.dm_db_index_usage_stats and sys.dm_db_index_operational_stats.   Recently, I was involved in a di…
I am showing a way to read/import the excel data in table using SQL server 2005... Suppose there is an Excel file "Book1" at location "C:\temp" with column "First Name" and "Last Name". Now to import this Excel data into the table, we will use…
Michael from AdRem Software explains how to view the most utilized and worst performing nodes in your network, by accessing the Top Charts view in NetCrunch network monitor (https://www.adremsoft.com/). Top Charts is a view in which you can set seve…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…

771 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question