Viewing 15 posts - 8,236 through 8,250 (of 9,241 total)
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
yes, it wasnt until i tested it and was able to confirm it works that i now plug it into my DR processes
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 9, 2009 at 5:57 pm
the other trick to recover from a dead master database is to take a backup of the master and restore it to a different sql instance as another name (i.e....
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 9, 2009 at 5:04 pm
do you really need to log ship all 16 databases??
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 9, 2009 at 4:26 pm
Viewing 15 posts - 8,236 through 8,250 (of 9,241 total)