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.

What's your client? How are you thinking to pull them? The client app gets a path and ????

I think an HTTP request from an internal or external IIS server is...

Well, I know the editor, so I got to schedule my thoughts early 😉

That's a good summary of some issues. And it covers some of how I feel as someone...

I tend to agree with Richard. While for performance reasons it's shown that in the db at these sizes is quicker than having things served off the db filesystem (with...

If you are wanting someone with more knowledge than you, good luck. Jason is probably right, but I think you'll struggle to find someone to move to the islands that's...

Can you not script (with VBScript/Powershell/SMO) something that runs a backup for the client and uploads/emails the bak?