will you be retrrying SP2? If so you need to be sure you won't hit the same error again.

well then you have online rebuild with sort_in_tempdb open to you, (as long as no LOB data) and even multi threaded. But that would still be resource intensive and I...

what version of 2008, standard or enterprise?

Whats the recovery mode of the database?

I presume the PK is the clustered index?

You could reorganise and backup the log up at intervals

you could...

see this for the error you had.

try restoring your msdb as a user database (this server or elsewhere) and see if you can fix the problem so that script runs....

I know, I just couldn't resist it ! 😉

if you want to keep it simple and just change recovery model for all user databases run this, copy results to another window and run

select 'alter database ['+name+'] set recovery...

why does it matter that other tables are fragmented? what is your script trying to do?

can you force the logic flow to pick up your table?

SQL Guy 1 (1/7/2014)

---

This server is used by 3rd party applications and not frequently used. I want to debug some rare case in my defragmentation script, it happens only...

run a dbcc shrinkfile on it, you'll have all the fragmentation you want.

but not in production 🙂

IIRC you will get the same error if you try and do the above.

Pretty sure you need to upgrade your RS instance so it is the same version (including service...

This QOTD discussion link just popped up in active threads for some reason so thought i would grab a couple of points 🙂

temporary fix - move the modellog.ldf file to where SQL expects it to be so SQL starts, then correct the values in master_files via alter database with care, restart (ensure...

we cannot see what you can see so difficult to troubleshoot, please post result of query above and portion of errorlog showing start up.

sorry that information is not held.

backward compatibility. I expect Microsoft used the term 'deprecated.'

Microsoft are giving you a chance to wean yourself off OSQL. expect it to disappear at some point. Its still in 2008R2.

Cannot...