Viewing 15 posts - 5,746 through 5,760 (of 9,241 total)
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
Ok so there is something blocking the operation, strange. Can you force the database offline using rollback immediate then bring it back online and after about 15 mins re run...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 7, 2012 at 3:23 pm
Perry Whittle (4/7/2012)
Stefan Krzywicki (4/7/2012)
Perry Whittle (4/7/2012)
Run this and let me know what happens
CREATE NONCLUSTERED INDEX NoddyIDX ON dbo.FTD
(ProdID ASC)
Same problem as the main index. Runs for over an hour...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 7, 2012 at 3:12 pm
Stefan Krzywicki (4/7/2012)
Perry Whittle (4/7/2012)
Run this and let me know what happens
CREATE NONCLUSTERED INDEX NoddyIDX ON dbo.FTD
(ProdID ASC)
Same problem as the main index. Runs for over an hour and nothing...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 7, 2012 at 3:05 pm
Viewing 15 posts - 5,746 through 5,760 (of 9,241 total)