Viewing 15 posts - 3,901 through 3,915 (of 9,244 total)
muthukkumaran Kaliyamoorthy (11/8/2013)
> Need a Shared disk
> Need a Third server/node
> create a new...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 8, 2013 at 4:33 am
muthukkumaran Kaliyamoorthy (11/7/2013)
Thanks Perry Whittle. I understand that, i need to run the wizard on passive node/server or do i need one more server for the third instance.
No, you dont...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 8, 2013 at 4:30 am
anoop.mig29 (11/7/2013)
Perry Whittle (11/6/2013)
Where firewalls are in place and you wish to connect via the instance name...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 7, 2013 at 9:19 am
muthukkumaran Kaliyamoorthy (11/7/2013)
I want to add/install 3rd SQL “instance3”....
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 7, 2013 at 8:23 am
you can use a single one, it's probably easier to store the mapping files with the VM. I have done this in the past.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 7, 2013 at 8:19 am
If your procedure only accepts a scalar value why are you dumping the value provided to the sp into a cursor looping through sys.database_principals??
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 7, 2013 at 8:13 am
A port in the high end range is usually good, say 50000 - 60000.
Where firewalls are in place and you wish to connect via the instance name you'll need the...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 6, 2013 at 12:03 am
You must grant share permissions on the share itself and ntfs permissions on the folders\files. Where the 2 combine the most restrictive applies, this is the default when creating a...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 5, 2013 at 12:14 am
yes i see what you mean, the following shows correctly the server role members but probably shouldnt be granted to ordinary users
grant VIEW ANY DEFINITION TO [youruser]
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 4, 2013 at 9:36 am
durai nagarajan (11/4/2013)
Thanks for you replyAre there no other alternative to this.
You could use a manual log backup instead of a differential and restore WITH NORECOVERY, MOVE.
The easiest option...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 4, 2013 at 5:06 am
assuming you havent disabled row or page locks on the index it would generally start with a row lock but as Gail said it depends on how much data is...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 4, 2013 at 5:00 am
it's detailed in Books online and requires membership of the Public role
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 4, 2013 at 4:57 am
Krishna1 (11/4/2013)
Need to create 3 users, please guide what roles to selected for these users
1. User who can run DDL commands
2. User who can excute procedures/views/triggers, view/add/delete/modify data
3....
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 4, 2013 at 4:47 am
query the file C:\windows\system32\drivers\etc\services and find a free port. perform a netstat -n to confirm that no other service on the machine is listening on that port.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 4, 2013 at 4:32 am
this is a common problem that is encountered with log shipping and mirroring when the servers are using disparate drives\paths.
Best way is to
run the LSCopy and...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 3, 2013 at 11:41 am
Viewing 15 posts - 3,901 through 3,915 (of 9,244 total)