SQL 2008 - database copy function - getting permission error

[cs96ai]

Hi,

Just trying out the SQL2008 db.
I was trying to use the copy database function in enterprise manager to move a copy of my production db to the testing server (just to test stuff out).
Seems that I'm getting a permission error when trying to select the destination database.

It could be the permission I'm running on my side but I'm looking in to it.
Any chance you have info on this?

Please see the error pic attached.

Thnx
CS /emoticons/smile.gif

[wisemx]

Hi,
Click on Tools, Options...
Then make sure "Prevent saving changes that require table re-creation" is not checked.

[nunga]

Hi, how can i copy a database made on sql server 2005 that i have on my computer to the sql2k8-beta.discountasp.net database server?
i was tryng by copy adatabase and by restore a database but nothing results.i tried to do the before thing but it do'snt work.
a message box error appears:




Post Edited (nunga) : 8/5/2008 5:10:59 AM GMT

[wisemx]

Hi,
There's an update for SQL Server 2005 to allow it to connect to a remote SQL 2008.
You need the update or you need to use SQL 2008 locally.
Salute,
Mark