Thanks for the input, guys.

Is there another way to assess wide indices?

Jeff Moden (11/11/2013)

---

namdinh4 (11/11/2013)

---

Hey all,

I am doing an evaluation against all indices on my database, and I have a question regarding index maintenance. I could not find the answer anywhere...

1 column is just an example. What if multiple columns of the index are not being use?

Is there any way to pinpoint that col3 is not used,so that i could recreate Index1 with col1, col2?

This issue occurs every time we backup over the network during traffic time

Do you guys have any theory of what happened?

No, I used standard script task to to issue the command 'backup database xxx to disk ='\\yyy\xxx.bak'

No server/OS issue at all, and yes, account has permission to add/drop/modify file on that share folder. Weirdest thing ever.

Yes I looked at the event log and confirm that the command failed. Server event log and SQL event log both confirmed that the backup command failed.

yes, everything is good. I could not figure out why the file is there when the backup command is terminated.

I backed up the database on a share folder. The media is raid 5 disks.

It is a native backup. I use SSIS script job to fire the backup command.

Yes I have.

I checked the file already using headeronly, filelistonly, and verifyonly. There is no issue with the file. The fact that i was able to restore that file on...