Viewing 15 posts - 5,746 through 5,760 (of 9,244 total)
what IP ranges do you have assigned to the NICs, what IP are you copying backups out to?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 10, 2012 at 3:24 pm
thelegendarywolf (4/9/2012)
Hi All,As per application upgradation/design, we're suppose to change the physical IP of the nodes for an Active/Passive cluster.
Why?
thelegendarywolf (4/9/2012)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 10, 2012 at 3:22 pm
make the root disk as small as possible, i usually use a size of around 100MB. See my article at this link[/url] for more info
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 10, 2012 at 3:09 pm
Are the remaining drives separate or are they merely logical drives on the same physical disk(s) as the C drive?
What is the current total size and free space of the...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 10, 2012 at 12:51 am
opc.three (4/9/2012)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 9, 2012 at 12:07 pm
opc.three (4/9/2012)
however what if you had multiple files to move and missed one?
The database would not come online!
The only time this would differ in any way is with file group...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 9, 2012 at 11:57 am
If you'd bothered to read the code in the post it reads as follows
alter database DatabaseName set single_user with rollback immediate
go
-- Set databae Offline
alter database DatabaseName set Offline
go
--- Cut and...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 9, 2012 at 11:41 am
opc.three (4/9/2012)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 9, 2012 at 11:04 am
I've never tried it but I'm pretty sure you won't be able to use the upgrade wizard. The 2 are essentially the same eition with different licensing constraints. Having said...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 8, 2012 at 3:24 am
Stefan Krzywicki (4/7/2012)
The creation of the index you suggested did complete after 2 hours. That's much slower than it should be, but at least it completed.
Ok the index i suggested...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 8, 2012 at 3:07 am
You could capture the failovermgr events in the windows system log and also check the windows application log for concurrent event messages.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 7, 2012 at 5:26 pm
Stefan Krzywicki (4/7/2012)
Perry Whittle (4/7/2012)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 7, 2012 at 4:03 pm
Unfortunately I can't supply you a query as I'm not at my computer. As Gail said kill the current session id for the create index and re run with maxdop...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 7, 2012 at 3:51 pm
Stefan Krzywicki (4/7/2012)
I'm not going to be able to take the database offline until tomorrow..
Don't worry not necessary
You need to find the actual wait type. There should be multiple threads...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 7, 2012 at 3:40 pm
GilaMonster (4/7/2012)
Blocking session of 0 means it's not blocked by another sessionWhat's the wait type?
Doh totally misread that one lol
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 7, 2012 at 3:37 pm
Viewing 15 posts - 5,746 through 5,760 (of 9,244 total)