Q: "DBCC INDEXDEFRAG can be used for which structures? Select one"

On SQL 2005, If I run:

DBCC INDEXDEFRAG (msdb, 'backupset', backupsetuuid)

and get a result of:

(1 row(s) affected)

DBCC execution completed. If DBCC...

Thanks everyone. I sent in an application earlier today.

yes. I don't think you can browse to a UNC path, but you can paste it in.

Are you appending your backup to an existing backup file ? I like to have separate files for eeach backup.

Why SP2 ? SP4 has been out a while. At least go to SP3 for all the big fixes.

I am waiting to hear back from a non-profit charity that I've applied to (bored & dead-end at my current job). I found out it would be a big pay...

I don't quite understand. What is .7z ?

Is the database backup file changing nightly, but the databse will ulimately have the same name each day ? Could you...

Side note: I put [] around the ? like [?] in case there are any dashes or other characters in db names. We have a couple such as My-Database and...

Sure .... lots of little tips out there that could be useful to others.

Sparkle ?

Thanks !!

Thanks 🙂

Update: I cancelled the insert, modified some code, and now it seems to be working .... basically: inefficient code.

Ninja's_RGR'us (7/26/2011)

---

Don't know what to tell you. I've definitely done this in the past and I was getting ever increasing counts in the table. I don't know what...

I have a process to alert me if there's blocking, but no problems so far.