Viewing 15 posts - 1,051 through 1,065 (of 6,400 total)
Is it a SQL authenticated user or a Windows Authenticated user?
If Windows, create the login on Principal and Mirror. Map the user on Principal to the database
If SQL, create the...
June 9, 2020 at 2:12 pm
Add the user account on both sides of the mirror/AG ensure correct SID mapping etc, re-snap the database.
As you say permissions are inherited from the original database so your user...
June 9, 2020 at 12:23 pm
Did you do the install via "Install-Module" or was it the offline install mode? If offline have you unblocked the child items and imported the modules first off
Import-Module dbatools
Copy-DbaDbDataTable
June 5, 2020 at 1:00 pm
Visual Studio has a schema compare option if you have the database tools installed. It's free but can be a bit clunky as it pulls in differences you tell it...
June 4, 2020 at 12:47 pm
You will need downtime to move the VNN, your probably best to create a DNS alias instead using a CNAME for when you do the actual switch.
Create the new cluster,...
June 3, 2020 at 9:19 am
Also are you deploying Standard Edition or Enterprise Edition in this new setup?
As if it's Standard you have other complications to contend with given how it all needs to work.
June 2, 2020 at 7:47 am
A traditional clustered instance, along with a node for an AG can co-exist in the same cluster, but there are caveats to it.
Primarily is the fact that the AG replica...
June 2, 2020 at 7:45 am
Never heard of it but from a quick google it seems its another DELL EMC product.
We did have Data Domain at one place I worked another DELL EMC product which...
May 27, 2020 at 8:59 am
I use ASG Remote Desktop the freeware version is great, ok it's limited as you cant have more then 3 RDP session open at anyone time, but I find it a...
May 26, 2020 at 12:07 pm
unsure, it depends, you may break it more than its already broken. its a risk you will need to take hence why I would build a new server and move...
May 22, 2020 at 12:58 pm
do they have read access to master?
we had this recently on a 2012 box and changing user permissions to be ssis_admin, they couldn't run the ssis reports without getting errors...
May 22, 2020 at 10:35 am
I would be cautious in this, if something has borked the installed on the engine, then installing SP2 may resolve it. Don't 100% expect it to work though.
If it didn't...
May 22, 2020 at 7:14 am
Remember that 2008R2 and below are all now out of mainstream support and extended support.
SQL 2012 and SQL 2014 are now out of mainstream support.
These legacy versions of the engine...
May 22, 2020 at 7:10 am
Compatibility level doesn't work like that.
If you on a 2017 server you get the 2017 syntax.
Changing the compatibility level is only for some internal things to revert to the old...
May 21, 2020 at 8:34 am
post the full details of the job output, not just what the overall job says, theres more to the job, expand it and select the details from the step
May 20, 2020 at 6:45 am
Viewing 15 posts - 1,051 through 1,065 (of 6,400 total)