SQL 2008 R2 Database copy wizard

Question

Post reply

SQL 2008 R2 Database copy wizard

adam kurtz

SSC Rookie

Points: 41
More actions
July 24, 2012 at 11:20 am

#264253

Just trying to copy a database from one server to another server both sql 2008 R2. Getting error below:
Login failed for user 'MISDOM\SILVONDEMO2$'. Reason: Token-based server access validation failed with an infrastructure error. Check for previous errors. [CLIENT: 192.168.10.29]

Viewing 11 posts - 1 through 10 (of 10 total)

You must be logged in to reply to this topic. Login to reply

Devendra Shirbad SSC-Forever Points: 42493 More actions · Answer 1

Does this login ‘MISDOM\SILVONDEMO2$’ has access to both the servers?

Jared SSC Guru Points: 61793 More actions · Answer 2

Why are you using a wizard for the same version? Why not just backup and restore?

Jared
CE - Microsoft

adam kurtz SSC Rookie Points: 41 More actions · Answer 3

adam kurtz

SSC Rookie

Points: 41

July 24, 2012 at 11:51 am

#1516989

I have no idea where that login even resides??

Jayanth_Kurup SSC-Insane Points: 22967 More actions · Answer 4

+1 backup restore , however have a look at the below link as well

http://www.sqldbops.com/2010/05/token-based-server-access-validation.html

Jayanth Kurup[/url]

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 5

Jayanth_Kurup (7/24/2012)

+1 backup restore , however have a look at the below link as well

http://www.sqldbops.com/2010/05/token-based-server-access-validation.html%5B/quote%5D

Using the [ url ]/[ /url ] IFCode shortcuts (no spaces inside the square brackets) makes the url reference "clickable".

http://www.sqldbops.com/2010/05/token-based-server-access-validation.html

adam kurtz SSC Rookie Points: 41 More actions · Answer 6

Jayanth_Kurup (7/24/2012)

+1 backup restore , however have a look at the below link as well

http://www.sqldbops.com/2010/05/token-based-server-access-validation.html%5B/quote%5D

I need to automate it, basically I need to copy a database and replace it to another server...was wondering of the most straightforward approach

adam kurtz SSC Rookie Points: 41 More actions · Answer 7

SQLKnowItAll (7/24/2012)
Why are you using a wizard for the same version? Why not just backup and restore?

I need to automate it, basically I need to copy a database and replace it to another server...was wondering of the most straightforward approach

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 8

Not that hard to automate a backup/restore process. There may actually be scripts on this site that can help with this.

adam kurtz SSC Rookie Points: 41 More actions · Answer 9

Lynn Pettis (7/24/2012)
Not that hard to automate a backup/restore process. There may actually be scripts on this site that can help with this.

Yes - I know, but was just wondering what tihs utility is all about, looks like it's mainly used for upgrading....I will pursue backup\restore....Thanks everyone....

Devendra Shirbad SSC-Forever Points: 42493 More actions · Answer 10

adam kurtz (7/24/2012)
Lynn Pettis (7/24/2012)
Not that hard to automate a backup/restore process. There may actually be scripts on this site that can help with this.
Yes - I know, but was just wondering what tihs utility is all about, looks like it's mainly used for upgrading....I will pursue backup\restore....Thanks everyone....

I absolutely don’t want to push for copy database option but it could be a better option in some case (detach attach method) on same server.

There is absolutely no harm in playing with it if you haven’t tried it yet. Be careful; please don’t try it on PROD server if you are unsure of its side effects and pre-requisites (SQL Agent).