Viewing 15 posts - 5,761 through 5,775 (of 9,244 total)
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
Welsh Corgi (4/7/2012)
I could not eve log on so I removed SQL Server 2008 R2.
Why didn't you just put it single user mode and add the appropriate account into sysadmins?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 7, 2012 at 1:46 pm
Run this and let me know what happens
CREATE NONCLUSTERED INDEX NoddyIDX ON dbo.FTD
(ProdID ASC)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 7, 2012 at 1:26 pm
Before going any further I would like you to confirm exactly the configuration of the logical disks, also is this server a virtual machine by any chance?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 7, 2012 at 1:03 pm
Stefan Krzywicki (4/7/2012)
I'm sorry, I don't know how to answer that question.You mean other than each of those being a different physical drive?
Yes, exactly. Get your server admin to confirm...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 7, 2012 at 12:49 pm
Stefan Krzywicki (4/7/2012)
Well, I had been running the index creation with WITH SORT_IN_TEMPDB = ON, so wouldn't the sort space be happening on C?
Yes it would hit C drive
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 7, 2012 at 12:46 pm
Stefan Krzywicki (4/7/2012)
Perry Whittle (4/7/2012)
Other things to considerHow many logical drives are you using?
What are the physical disk configs underneath these?
System dbs on C
log files on G
data files on...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 7, 2012 at 12:42 pm
Other things to consider
How many logical drives are you using?
What are the physical disk configs underneath these?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 7, 2012 at 12:03 pm
Jeff Moden (4/7/2012)
check the scheduled jobs and see what's happening around that time frame.
Great minds think alike 🙂 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 7, 2012 at 11:37 am
Can you supply the table definition too?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 7, 2012 at 11:33 am
The backup related tables you require are in the MSDB. Use the following query
Select database_name, Compatibility_level, Recovery_model,
DATABASEPROPERTYEX(database_name,'Status'), Type
from msdb.dbo.backupset
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 7, 2012 at 11:28 am
Are referring to native or 3rd party backups, there is a difference
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 7, 2012 at 7:57 am
kranthi.india123 (4/7/2012)
3.6. Update statisticsIt is recommended that, after having committed or changed the compatibility mode to 100, execute the stored procedure: sp_updatestats
You first execute DBCC UPDATEUSAGE(), this is required when...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 7, 2012 at 6:55 am
Viewing 15 posts - 5,761 through 5,775 (of 9,244 total)