Viewing 15 posts - 1,126 through 1,140 (of 9,244 total)
Sree Divya (10/13/2016)
i have configured logshipping for my databases.
for dr testing i have disabled the lscopy,ls restore jobs on the secondary server and after that i have ran my database...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 20, 2016 at 9:23 am
tcronin 95651 (9/20/2016)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 20, 2016 at 9:19 am
most I've seen who get it wrong move to hardware that's inferior expecting it to be super fast and it isn't.
I've worked on projects where we've used high end kit...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 20, 2016 at 8:52 am
SQLKnowItAll (10/20/2016)
I suppose that depends on how you measure "overhead." I still stand by my statement that "in general" a properly configured VM can boost your performance.
:w00t: wow you stand...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 20, 2016 at 7:24 am
so just backup user databases from the source servers and restore them onto the new cluster
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 20, 2016 at 7:15 am
suvorav (10/17/2016)
When I wanted to mitigate read-write workload issues then RCSI seemed enough
When I attempted to use snapshot...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 20, 2016 at 4:59 am
Guras (10/19/2016)
it's strange that my username is the member of the server role sysadmin if I check it in the Security section through SSMS.
are you connected to the correct instance...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 20, 2016 at 4:04 am
CM-249617 (10/19/2016)
Sue_H (10/19/2016)
CM-249617 (10/19/2016)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 20, 2016 at 4:01 am
SQLSalas (10/19/2016)
For now, this IS the information:
"Always On Availability...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 20, 2016 at 3:02 am
SQLKnowItAll (10/19/2016)
What makes you say there will be negative performance impact of virtualization? I would say "generally" you can get a bump in performance.
Virtualisation carries an overhead, fact. Its...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 20, 2016 at 2:29 am
Krasavita (10/18/2016)
Do you have any idea how long it might take to sql backup for 600 gb.Thank you
As stated, it depends on your hardware and configuration.
As a rough guide, I'm...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 19, 2016 at 9:51 am
Guras (10/18/2016)
SET SINGLE_USER WITH ROLLBACK IMMEDIATE
This is giving me the following error and I am in the sysadmin server role in the...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 19, 2016 at 9:37 am
rkrpat (10/18/2016)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 19, 2016 at 9:29 am
Brandie Tarvin (10/19/2016)
Are you taking log backups of your primary AG database? If not, then expect it to fill up and not clear.
you can offload log backups to secondaries, they...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 19, 2016 at 9:28 am
is it enterprise or evaluation edition
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 19, 2016 at 9:23 am
Viewing 15 posts - 1,126 through 1,140 (of 9,244 total)