Glad it's working. Be sure that you have log backups running, and manage the size over time, watching the growth and balance that with the backups you need.

The horses do graze some down, but they're not consistent, and they'll eat to the roots, so it destroys the growth. We rotate them around the 4 areas we...

Moving this to 2005/Admin.

What is S3?

Ah, one more note. The Pensacola SSUG is looking for speakers for 2011. They meet the 4th Thur and are looking for speakers. No idea if they'll do Livemeeting. If...

Well my post for the day is to say that thanks to crappy forum code, my subscription to this thread, the forum, and Jeff hanging out with a keyboard on...

I will dig a few by hand at times, but not often. I did, however, pound in 20 T-posts into the ground by hand over the last month.

If you run regular log backups, you ought be able to set a log size and not mess with it. Read Gail's article and that should help you understand why.

Log...

Does this work if you don't do the SAN backup?

You should be able to test this during a low period of activity. See if you can :

- Add a table

-...

I wouldn't lie.

I'd say, I left this job because they wanted me to work 80 hours a week for weeks. I can't, and don't believe it that. I'm more productive...

Ignore the query.

How do you get this answer if you have the populations?

Now, how do you get the populations in a query?

Apply the math to the query. It's not...

LOL, I think I did this without thinking in my younger...

x64 or x86?

I would leave 2GB for the OS, but monitor and check the pagefile for lots of activity. Leaving3-4GB can't hurt.

For SQL, you'll have to experiment with each instance....

The issue with Single_user is that the first user gets in. Might not be that person.

I'd still set permissions in two groups. Revoke access for one group, add for the...

It should. You might need to restart the log shipping jobs, but they should be able to pick up with the next log file

That's the agent log, isn't it? You want to get something from the maintenance plan itself, not the job. Something like this:

Maintenance Cleanup Task (SEVENFALLS)

Maintenance Cleanup on Local server connection

Cleanup...