2008 R2.

I have been trying to get it to use dontsavesensitive and pass it creds. But my problem seems to be around the connectionmanager. If it deviates from...

Good to know, think you can point me in the right direction?

Ok, so I did try a convert on that table so I was on the right path, but I didn't get the result I was expecting:

select convert(varchar(100), Owner) from tbl_RBS_UserRole

This...

Ok that makes sense, thank you guys for the help understanding this.

Ok, I think I understand, one last question then, wouldn't the index rebuilds cause it to grow significantly though?

Brandie, my apologies, but I think I didn't explain well enough, it's not specifically the mirror server that's the problem. Both systems have identical storage (mirror has slightly more actually)...

So is it more productive to not shrink the db, and not rebuild the indexes? I understand the correlation between this and space usage due to the increase in...

Sorry, yes space is an issue, and I'm several months out on a new storage purchase in the best case scenario. Space in this datacenter is so incredibly expensive...

As Brandie said, looking at the 'right now' doesn't help in figuring out what happened in the past. There are operations that take a lot of log space. Index rebuilds...

That's why I'm confused, my transaction log backups run every 15 minutes, no failures for the last couple weeks.

I think that's the smoking gun.

Gail, result of the query you provide in that post shows that LOG_BACKUP is the culprit.

This brings up a couple questions. Assuming...

From msdn:

TRUNCATEONLY

Releases all free space at the end of the file to the operating system but does not perform any page movement inside the file. The...

Agreed, Seth your script would not be a good idea, especially in my situation with a mirror. You want to keep your backup history as long as you keep...

Thank you both for the reply, there is no error. It is currently 10GB and the initial size is the same. It was originally created to be 500MB...

I'm not aware of any tools, After a week of trying to solve this I ended up opening a MS Support case. I would suggest you do the same...