Viewing 15 posts - 2,701 through 2,715 (of 9,244 total)
Adam Bean (11/24/2014)
Ya got me again. Previously I was specifying the database, this time I was not. As soon as I specified the database, it indeed took me to 03.
:cool:...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 24, 2014 at 8:01 am
Adam Bean (11/24/2014)
When I connect to the listener with ;ApplicationIntent=ReadOnly, it still lands on the current primary (which is SQL01\AO1):Shouldn't I have landed on SQL03 first?
Are you specifying the listener...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 24, 2014 at 7:50 am
It doesnt get the server roles but i use this
SELECT'CREATE LOGIN [' + name + '] WITH PASSWORD = ' +
sys.fn_varbintohexstr(password_hash) +
' HASHED, SID = ' + sys.fn_varbintohexstr(sid) +...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 24, 2014 at 7:47 am
Would check your replica names if i were you, seems you're using O and not 0 in some of the replica names and that's likely why it fails
ALTER AVAILABILITY GROUP...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 24, 2014 at 7:38 am
assuming you're sorted now??
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 24, 2014 at 6:41 am
Firstly, why are you using a disk based quorum?
How many nodes are in the cluster?
Are they geographically dispersed?
To remove the quorum disk, reconfigure the quorum type with failover cluster manager...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 24, 2014 at 3:51 am
HanShi (11/24/2014)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 24, 2014 at 3:49 am
the sql server ntfs permissions are secured by the use of either local groups in ealier versions of windows or by virtual server accounts for Windows 2008 on. As the...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 22, 2014 at 7:19 am
incidentally is this an iSCSI storage system or FC?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 21, 2014 at 1:05 pm
PhilipC (8/7/2014)
Perry Whittle (8/7/2014)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 21, 2014 at 12:55 pm
run them in same query window as that has the single connection
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 21, 2014 at 12:47 pm
Wayne West (11/21/2014)
Perry Whittle (11/21/2014)
If you're talking transparent database encryption then Exprsss edition is not going to provide this. It's an Enterprise feature only
I will not deploy Express for something...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 21, 2014 at 10:16 am
are you running the restore within the same window as the prvious commands?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 21, 2014 at 10:11 am
If you're talking transparent database encryption then Exprsss edition is not going to provide this. It's an Enterprise feature only
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 21, 2014 at 9:13 am
Maddave (11/21/2014)
There is still one or more connections to the database. Exec sp_who2 and look to see what connections are connected to your database.
Not if this completed successfully
USE [master]
ALTER...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 21, 2014 at 9:05 am
Viewing 15 posts - 2,701 through 2,715 (of 9,244 total)