Viewing 15 posts - 1,726 through 1,740 (of 9,244 total)
can you supply more info on the environment please, not enough to work with here?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 18, 2015 at 9:04 am
lyle.schow 28602 (9/17/2015)
I will be installing SQL2008R2...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 18, 2015 at 3:45 am
dan-572483 (9/17/2015)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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!!
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 16, 2015 at 7:29 am
Jeff Moden (9/15/2015)
5. Are you allowed to use xp_CmdShell (which would make this easy)?
Powershell is even easier 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 16, 2015 at 7:28 am
Viewing 15 posts - 1,726 through 1,740 (of 9,244 total)