Viewing 15 posts - 1,921 through 1,935 (of 9,244 total)
giri10488 (7/8/2015)
i already tried on google but i want how its work exactly.
Check my article linked above
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 9, 2015 at 3:04 am
kathy.plamann (7/8/2015)
I have a powershell script that runs robocopy from sql server agent
Cut out the middleman and just use PoSh to copy the files instead of Robocopy 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 8, 2015 at 10:05 am
on top of what Kevin has said, try this link and this link
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 8, 2015 at 7:03 am
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
Viewing 15 posts - 1,921 through 1,935 (of 9,244 total)