Viewing 15 posts - 1,921 through 1,935 (of 9,241 total)
Jayanth_Kurup (7/8/2015)
I cant remember if a windows shutdown cleanly shutsdown SQL Server Services but i guess it should.
Yes it will
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 8, 2015 at 5:07 am
was the instance still present as a replica in the AG?
was the database still listed as joined to the AG?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 8, 2015 at 3:45 am
Arestas (7/7/2015)
For some reason only 1 entry was created per listener on dns.(instead of 2)
is this a multi subnet cluster?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 8, 2015 at 3:44 am
do the database file paths on the principal and the mirror match?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 8, 2015 at 3:41 am
you'll need to supply a lot more detail on this, screenshots of any errors too if possible
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 8, 2015 at 3:40 am
Jim_K (7/7/2015)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 7, 2015 at 11:43 am
is the database in full recovery mode?
run a transaction log backup
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 7, 2015 at 6:01 am
is this the SPN for the listener Virtual NetworkName?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 7, 2015 at 6:00 am
so, you have a valid AD domain controller, a valid DNS infrastructure and a primary dns suffix.
So you do have access to AD and DNS, the fact you were granted...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 7, 2015 at 5:58 am
it depends on the organisation
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 7, 2015 at 5:53 am
SQL!$@w$0ME (7/6/2015)
I was thinking if it's a best practice not to allow the file to grow too much
That's not a best practice, you'll really likely only have issues when the...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 6, 2015 at 1:51 pm
swoozie (7/6/2015)
SQLsrvr.exe -m this did not work either -m unrecognizable
You have to run this from the folder where the exe lives, usually
C:\Program Files\Microsoft SQL Server\MSSQL11.INSTANCEID\MSSQL\Binn
As i said before...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 6, 2015 at 1:48 pm
Arestas (7/6/2015)
I don't have any access to AD or DNS.
A windows server failover cluster requires an Active Directory domain and a valid DNS server. It is possible to implement clustering...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 6, 2015 at 1:44 pm
can you tell us a bit more about your environment, is this a test system?
Who installed\controls the domain controller(s) and DNS server(s)?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 6, 2015 at 12:25 pm
when running as a sql server account the job will impersonate the service account at the OS level. If the service account has permission to the folder then it will...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 6, 2015 at 12:10 pm
Viewing 15 posts - 1,921 through 1,935 (of 9,241 total)