There’s a general consensus that you should reorganize (“defragment”) your indices as soon as index fragmentation reaches more than 5 (sometimes 10%), and you should rebuild them completely when it goes beyond 30% (at least that’s the numbers I’ve heard advocated in a lot of places). Michelle Ufford (a.k.a. “SQL Fool”) has an automated index … Read more
I had the same problem. Turns out it was an execution window that was buried. It doesn’t show as an “open window” when you look at the taskbar at the SSMS icon, so it’s deceptive. ALT-TAB your way through the windows and you should find it. The open windows was:
Try these checks: Use *.* for the file extension or bak without a dot, both of which I have found work if other issues are correct too. Make sure that the path is simply the path to where your backups are but with a backslash on the end. Check that verify is ticked when you … Read more
The reorganize and rebuild are different things. Reorganize: it’s a defrag for indexes. Takes the existing index(es) and defragments the existing pages. However if the pages are not in a contiguous manner, they stays like before. Only the content of the pages are changing. Rebuild: actually it drops the index and rebuilds it from scratch. … Read more