Hi Eric,

I'm guessing that you detached, deleted the log file and then tried to re-attach? SQL Server won't allow you to attach a database without a log file if the...

I always advise people to restore all their backups - if you're taking a backup its because you think you may need to use it in the future. If that's...

My guess is that there was a huge amount of free space in the pages comprising your indexes and that rebuilding them with a larger fillfactor got back a bunch...

Sounds like you have a database but it's been detached - is that the case? If so, how did it get detached?

Can you post the before and after (removing fragmentation) results from the DMV for each index?

Also, if you're having continuous problems with fragmentation, you might want to see if you can change your index keys so that the indexes aren't so prone to fragmentation. E.g....

Yup - if you take an exact copy of the database and then make a change in one that isn't reflected exactly in the other, as far as SQL Server...

It can't be done unless the databases are identical copies of each other - otherwise the LSNs in the databases get out of sync. It's an often-requested feature of SQL...

Yup - forgot about that. There's also a presentation available that I presented at TechEds in China and Hong Kong last year that's based on that whitepaper - see http://www.mshk.com/hk/technet/teched2006/ppt/Day_1/Session_1/DAT319_Paul_Randal.ppt

This is a big problem for many VLDBs that are mirrored. There are a couple of things you can do in 2005:

1) use a potentially less expensive (in terms...

Please - don't shrink tempdb - it's likely to just grow again and you'll end up with file system fragmentation.

One thing to do before restoring master - figure out why the errors happened in the first place. If you took a power failure and you have caching turned on...

It'll be in one of the future CTPs of SS2008. See http://www.microsoft.com/sql/techinfo/whitepapers/sql_2008_oltp.mspx for more info.

Be careful - make sure you understand the ramifications of switching to bulk-logged recovery mode. For the duration of the bulk-logged operation in the log backup, you cannot do a...

That's not really a question we can answer for you. It depends on your application needs and business needs - do you need any of the new features in SS2008?...