Viewing 15 posts - 136 through 150 (of 859 total)
Thanks. So, I think I will plan for a backup/restore method.
January 29, 2015 at 7:17 am
More clearly, the primary site has node1,2,3,4. In Node 3 (SQl1,SQL1\N) and 4(SQl1\N,SQL1) has a/a pair SQL instances. Need to move only SQL1\N from WSFC 2008 to 2012....
January 29, 2015 at 5:30 am
Perry Whittle (1/29/2015)
muthukkumaran Kaliyamoorthy (1/28/2015)
Since it's already a GEO cluster 4 node in USA (6 SQL instances)+ 2 node in China (2 SQL instances).
All 6 nodes part of the same...
January 29, 2015 at 5:21 am
Ozzmodiar (1/28/2015)
Is the database you're migrating the only one in...
January 28, 2015 at 10:53 pm
Perry Whittle (1/28/2015)
muthukkumaran Kaliyamoorthy (1/28/2015)
Yes, Correct. Server A & B old - SQL 2012. And need to move it to server C & D new - SQL2014.
So, you have two...
January 28, 2015 at 9:52 pm
sm_iransoftware (1/27/2015)
I Create an availibility Group with a primary and a secondary. (For test)
Then run Planed Failover.
Switched to secondary. That's ok.
After that I update some tables on secondary (That...
January 28, 2015 at 11:03 am
Yes, Correct. Server A & B old - SQL 2012. And need to move it to server C & D new - SQL2014.
January 28, 2015 at 10:54 am
Perry Whittle (1/28/2015)
muthukkumaran Kaliyamoorthy (1/28/2015)
Yes, I have AG group in SQL 2012 which has two replicas primary and secondary.
So if i have it correct, you have the following
ServerA and ServerB...
January 28, 2015 at 10:32 am
Perry Whittle (1/28/2015)
are you using availability groups?if you're not then disregard my previous post and i'll explain it differently to match your scenario
Yes, I have AG group in SQL 2012...
January 28, 2015 at 10:21 am
Perry Whittle (1/28/2015)
Once synchronised you may...
January 28, 2015 at 10:08 am
Got it. It connects default port for the default instance.
I should connect listener,port 🙂
April 23, 2014 at 6:06 pm
quackhandle1975 (2/25/2014)
quick sanity check here: migrating from SQL 2005 to 2008 R2. I'm looking to take a full bk up on Source 2005 instance and copy/ restore to...
February 25, 2014 at 5:56 am
pmadhavapeddi22 (2/18/2014)
Please suggest me what are the measures to be taken on the database or server settings if we are suggesting our client
to upgrade from SQL 2005 version to 2008...
February 25, 2014 at 3:30 am
John Mitchell-245523 (1/22/2014)
Ryan Keast (1/22/2014)
I've now changed SQL Server service to run under the same account of mhs2\sysadmin3 and they are now working.
Interesting. Looks as if the maintenance plans...
January 22, 2014 at 5:06 am
Is the both SQL service & SQL Server Agent runs under same account.
January 22, 2014 at 4:45 am
Viewing 15 posts - 136 through 150 (of 859 total)