SQL 2008 R2 Database copy wizard

  • 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]

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

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

    Jared
    CE - Microsoft

  • I have no idea where that login even resides??

  • +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]

  • 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

  • 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

  • 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

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

  • 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....

  • 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).

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

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