Viewing 15 posts - 1,111 through 1,125 (of 9,244 total)
JP10 (10/25/2016)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 26, 2016 at 10:40 am
I just my scripts into a PS1 file and create an os exec job step calling the PS1 script and passing any parameters
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 26, 2016 at 10:23 am
Does that mean you are unhappy with the licensing changes around core licensing too?
You could of course stay on sql server 2008
Like any organisation as products evolve, features and licencing...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 26, 2016 at 10:21 am
the issue occurs usually because you do not have local administrator permissions on the server which you'll need to stop and start services
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 21, 2016 at 7:40 am
you absolutely can restore any of the databases as any name, works fine.
When restoring master though, as hanshi says its not recognised as a user database, will likely be down...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 21, 2016 at 5:06 am
put this PoSh code into a PS1 script and run it via sql agent
$checkdate = (get-date).AddDays(-14)
$checkpath = "drive:\path\path\"
get-childitem $checkpath -Include...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 21, 2016 at 2:55 am
SQLKnowItAll (10/20/2016)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 21, 2016 at 2:40 am
gshyam23 92006 (10/20/2016)
Thanks for your response. I tried restoring the certificate and I was still not able to read the data, not sure if some thing is wrong in our...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 20, 2016 at 10:27 am
nj-240363 (10/20/2016)
Thanks for the quick reply RonenIt is a very good article indeed. I'll try again to see if I'll get lucky next time.
Do yourself a favour and either
get some...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 20, 2016 at 10:25 am
each new availability group would have it's own listener and would require a unique virtual computername and IP address
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 20, 2016 at 10:11 am
You can use separate port or separate port and ip address. You would usually do this when creating a soft NUMA configuration for your sql server instance.
The port assignments are...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 20, 2016 at 9:51 am
gshyam23 92006 (10/20/2016)
I am trying to learn about column level encryption as we are planning to implement in our environment, I tried to configure it in our lab environment...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 20, 2016 at 9:49 am
the cluster account requires permissions to create vcos in the domain.
do you have a gpo that's wiping this out by any chance,
check with your admins for further info
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 20, 2016 at 9:44 am
dax.latchford (8/9/2016)
I have covered clustering very briefly on...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 20, 2016 at 9:38 am
snomadj (8/18/2016)
Added a new data file on current principal.
On my mirror the drive letters don't match
The new file could not be created on...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 20, 2016 at 9:36 am
Viewing 15 posts - 1,111 through 1,125 (of 9,244 total)