Viewing 15 posts - 4,231 through 4,245 (of 9,241 total)
Marios Philippopoulos (3/26/2013)
I was reading an article that described a similar scenario of a single WSFC comprised of 2 FCIs
Could you provide the article link please
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 27, 2013 at 12:14 am
muthyala_51 (3/22/2013)
We tested it on the dev servers and we never had any issue with shared drives. We never restarted the service. I am not sure why you wanted to...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 23, 2013 at 1:48 am
Jay Beta (3/22/2013)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 23, 2013 at 1:43 am
This
BACKUP DATABASE Test1
TO DISK = 'C:\temp\20130319_1.bak',
TO DISK = 'C:\temp\20130319_2.bak',
TO DISK = 'C:\temp\20130319_3.bak',
TO DISK = 'C:\temp\20130319_4.bak',
TO DISK = 'C:\temp\20130319_5.bak'
Should be this
BACKUP DATABASE Test1
TO DISK = 'C:\temp\20130319_1.bak',
DISK = 'C:\temp\20130319_2.bak',
DISK =...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 19, 2013 at 12:30 pm
Creating a clustered DTC service to run on each node wont harm anything, do you have a lot of DTC activity in the cluster?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 19, 2013 at 9:33 am
all the shared disks are dependencies otherwise how would the service start
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 19, 2013 at 9:30 am
GilaMonster (3/17/2013)
Make sure that the login is not sysadmin, the user is not db_owner and...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 17, 2013 at 1:54 pm
after granting the roles you would need to DENY delete not REVOKE
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 17, 2013 at 1:21 pm
What is it you are not clear on?
Do you understand the concept of public and private keys?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 17, 2013 at 2:22 am
You cant view them, to understand what they are check books online for more info.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 17, 2013 at 2:20 am
clintonG (3/16/2013)
Here is one solution perhaps the best I've learned so far:// Transact-SQL
REVOKE privilege_name
ON object_name
FROM {user_name |PUBLIC |role_name}
// Example
REVOKE DELETE
ON TransactionRecordsTable
FROM employee
REVOKE only clears the granted permission,...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 16, 2013 at 1:31 pm
clintonG (3/14/2013)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 16, 2013 at 12:40 pm
use either
computername\instancename
computername, portnumber
IPaddress\instancename
IPaddress, portnumber
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 16, 2013 at 8:04 am
GilaMonster (3/15/2013)
MyDoggieJessie (3/15/2013)
so there's no difference between 2 files of 140GB and 4 files of 70GB, it's still 280GB total space.
To add to the above, remember that when adding multiple...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 16, 2013 at 8:01 am
The shared databases represent only the upper layer of the shared objects. At the base level, each cluster node that is part of the failover instance shares the virtual IP,...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 16, 2013 at 7:57 am
Viewing 15 posts - 4,231 through 4,245 (of 9,241 total)