Viewing 15 posts - 1,726 through 1,740 (of 9,253 total)
Wooju (9/22/2015)
I also need to change the server collation. I have a 2 node, 2 instance SQL 2012 SP1 cluster. I tried to run the sqlservr -m -T4022 -T3659...
September 22, 2015 at 8:33 am
can you supply more info on the environment please, not enough to work with here?
September 22, 2015 at 8:27 am
HookSqlDba7 (9/22/2015)
1) Is backing up files and/or file groups the best route to take?
backup\restore is a good way to move a copy of a database
HookSqlDba7 (9/22/2015)
September 22, 2015 at 8:24 am
Why on earth are you using copy database wizard to migrate databases, just use backup\restore or detach\attach
Jayanth_Kurup (9/20/2015)
September 21, 2015 at 10:32 am
dimadd2005 (9/1/2015)
If you change your service account on the second machine to local System.and then restore your master keys it just work.:-)
The point is you don't restore the SMK, it's...
September 21, 2015 at 9:19 am
stanlyn (9/18/2015)
I'm successfully logging into the alphaone database as it shows as "DAS\AlphaOne,1xxxPport) at the top of the treeview in ssms.
when connecting, for the instance name and port number, you...
September 21, 2015 at 9:14 am
you'll need a stable network connection to replicate all the mirror traffic plus handle cluster network communications.
Teamed connections are fully supported and make perfect sense
September 18, 2015 at 9:04 am
lyle.schow 28602 (9/17/2015)
I will be installing SQL2008R2...
September 18, 2015 at 3:51 am
Wurstsalat (9/17/2015)
Perry Whittle (9/17/2015)
Wurstsalat (9/17/2015)
also i would like to do a shrink after reorgSTOP shrinking your databases!!
the space is only needed for the reorgs, not while running productive (no auto...
September 18, 2015 at 3:45 am
dan-572483 (9/17/2015)
September 17, 2015 at 10:13 am
dan-572483 (9/16/2015)
The passive node is off the network and not recognizing its NICs. Our hardware people are recommending a complete OS reinstall.
seems a bit drastic, doesn't seem like they have...
September 17, 2015 at 7:08 am
ANn -425914 (9/16/2015)
Can you explain why, so in order to use alwayson group it has to be at least 3 nodes in a cluster?
An AlwaysOn availability group configuration requires...
September 17, 2015 at 7:06 am
Wurstsalat (9/17/2015)
also i would like to do a shrink after reorg
STOP shrinking your databases!!
September 17, 2015 at 7:02 am
Wurstsalat (9/17/2015)
BEGIN/END fixed the first flaw....but not the "USE" flaw for dynamic SQL i have to read much i think...saw a few articles about it ( i am not...
September 17, 2015 at 5:00 am
ramana3327 (9/15/2015)
I am working with one of the task automating the db refresh in test server from production backup.
I need your expertise advice
The production backup sits on the production server...
September 16, 2015 at 7:29 am
Viewing 15 posts - 1,726 through 1,740 (of 9,253 total)