Viewing 15 posts - 8,236 through 8,250 (of 9,244 total)
Flo\Barry
thanks a lot, i only need the drive name and then the folders underneath. I'll check out the items posted and see how i get on
Regards
Perry
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 11, 2009 at 9:41 am
samsql
to start, can you please post the following info
SQL server version/edition:
OS version/edition:
min memory for sql:
max memory for sql:
you say the server has 16GB ram is that correct?
what exactly do you...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 11, 2009 at 6:13 am
i need to populate a treeview object with fixed drives and their folders
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 11, 2009 at 5:29 am
did you remember to add the extra required resources under cluster administrator for disk, IP, Name, etc.
your 2nd instance will use separate disk resources, etc 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 11, 2009 at 3:51 am
i take your point, the point of investing in a SAN though is you can lose a switch or a disk and the array is still available. The OP states...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 11, 2009 at 3:36 am
incidentally, exactly where did you change the sql service account credentials from local to domain user?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 10, 2009 at 4:58 pm
Edogg (4/10/2009)
This way if you lose a SAN you don't lose both servers.
absolute rubbish, the whole point of a SAN is multi pathing and fail over. Chances are, if...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 10, 2009 at 4:41 pm
i would migrate all data to the new SAN and setup database mirroring between the 2 instances. Decommission the old Hitachi SAN unless you have any real need to keep...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 10, 2009 at 1:40 pm
for sql 2008 clustering post in the sql 2008 forum in the future.
Apart from that this should help too
http://www.mssqltips.com/tip.asp?tip=1698
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 10, 2009 at 11:51 am
Rowan (4/10/2009)
But why does it run perfectly in sql 2000 with or without using a udf. I am stumped!Thanks for your replies.
sql 2000 let you do a whole load of...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 10, 2009 at 11:36 am
using either profiler or a server side trace!
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 10, 2009 at 3:49 am
have you tried profiling the database to see if there are any oddities there?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 10, 2009 at 3:44 am
you have 3 nodes
NODE A
NODE B
NODE C
run setup on NODE A and you would select "New SQL Server failover Cluster Installation". During set up you indicate which cluster nodes participate...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 10, 2009 at 3:40 am
if the server is stand alone then there is no cluster, could you explain a little more please?
do you have a windows cluster configured and ready to go?
Have you created...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 9, 2009 at 6:39 pm
did you run DBCC UPDATEUSAGE as well?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 9, 2009 at 6:31 pm
Viewing 15 posts - 8,236 through 8,250 (of 9,244 total)