July 24, 2012 at 11:20 am
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]
July 24, 2012 at 11:37 am
Does this login ‘MISDOM\SILVONDEMO2$’ has access to both the servers?
July 24, 2012 at 11:37 am
Why are you using a wizard for the same version? Why not just backup and restore?
Jared
CE - Microsoft
July 24, 2012 at 11:51 am
I have no idea where that login even resides??
July 24, 2012 at 11:54 am
+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
July 24, 2012 at 11:56 am
Jayanth_Kurup (7/24/2012)
+1 backup restore , however have a look at the below link as wellhttp://www.sqldbops.com/2010/05/token-based-server-access-validation.html
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
July 24, 2012 at 11:57 am
Jayanth_Kurup (7/24/2012)
+1 backup restore , however have a look at the below link as wellhttp://www.sqldbops.com/2010/05/token-based-server-access-validation.html
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
July 24, 2012 at 11:58 am
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
July 24, 2012 at 11:59 am
Not that hard to automate a backup/restore process. There may actually be scripts on this site that can help with this.
July 24, 2012 at 12:01 pm
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....
July 24, 2012 at 12:15 pm
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
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy