I'm with homebrew01. The space will get reused. It isn't in the backups (that size should have dropped), but growing a db is an expensive operation. You don't want to...

You could run that multiple times to clear all rows, which is something to do if you are managing log sizes or worried about activity with a large transactions.

Keep in mind that a db should NOT be the data size. There should be free space in there to allow for growth.

I agree with Bru, hard to predict. It depends on system load (since that will change the amount of stuff in the backup, potentially, with log records) and then also...

WayneS (5/20/2010)

---

Yep... I took the week off, and among all the chores I had a list of 13 sessions I...

jcrawf02 (5/20/2010)

---

Advice requested -

trying to develop a searcheable db of our available reports for end users, including description, author, screenshots, blah blah blah.

We have a standard documentation template...

Chores

I'd agree with Jason. One more thing I'd suggest is that you rebuild indexes only on fragmentation, not on a schedule. There are scripts here on the site to help...

Well I missed it as well, missing it actually with a day off, chores, and family coming in town. This is my 5 minutes before my brother and nephews arrive.

I...

Restore v attach, 6 of one. Either way works. I don't have a big preference.

As Jason mentioned, no file system backups on a regular basis. Always do a SQL backup...

I don't think we'll add ads to the email notifications. They are in the newsletter, and we are likely looking to change those up to make them more effective, and...

Ditto. Backup the db, shouldn't be too long at that size. 160GB isn't that large.

Detach, copy, attach.

You'll have orphaned users, so I'd use sp_help_revlogin (from MS) to script logins, sp_change_users_login...

Interesting because a stored proc create/drop is in my Schema Changes History report on 2008. That is supposed to come from the default trace.

If I run this:

SELECT...

The headlines images are different because of poor image editing skills on my part. Our designer gets busy, and so I decided to try something. The icons are different, which...

Holly,

I think you're right. It's not about us, it's about minor protections for the company, lawyer PIAs and horse droppings rolling downhill.