If you retain backup history, that shows the data size before compression. Keep in mind that backups don't show free space, so you need to account for that as part...

Matt-1034261 (12/30/2009)

---

Hi Gail

Thanks for your suggestion, I tried restoring a new one from scratch, it got about half way and then came up with an error message to say something...

Transaction logs of production databases are usually backed up more frequently than you are doing. Are you sure you don't need them more often ? (I don't mean to...

Do you have the "Backward Compatibility" and "2005_DTS" add-ons installed ? What service pack of 2005 are you on ?

You can also use the Activity Monitor GUI, then look at details to see what's running.

Duplicate post in an old thread. Reply...

gk-411903 (12/21/2009)

---

Forgive my ignorance. I understand that the index is moved to the desired filegroup (index file group). But is the data also in the same index file group? I...

Instead of using the GUI locally on your desktop, use the GUI...

I seem to recall that you can get blocking when creating a table this way if...

Yes, prevent the duplicates in the...

Is "acad" the default database for those users ?

If MDF_2 is in the same file group then SQL will add to it outside of your control. If you create a secondary file group, then you can move tables...

Thanks for all the tips.

I just came across this on SQL-Performance, so I don't see a clustered Index in my future since the table is 1+ Terabytes:

"...Also keep in mind...

EdVassie (12/18/2009)

---

Changing one of the existing indexes to clustered may (or may not) cause maintenance problems in the future if you apply a service pack from your app supplier. ...

SMNayak (12/18/2009)

---

I had searched a lot for this...!!!

Finally got a one simple solution... 🙂

The user's windows login should be having the admin rights in the machine where the SQL Server...