closed

there shouldn't be an issue with backing up the log while writing to it. One is reading, one writing, but SQL and the OS should manage that fine. There could...

Are you looking to script this for use on other servers?

Here's an article on setting things up: http://www.sqlservercentral.com/articles/Profiler/63097/

You probably want to grab the login name of the user, you'll filter...

Interesting debate here, anyone want to turn some testing into an article?

Closing thread

Check your maintenance plan or other jobs to see if they are rebuilding indexes.

tempdb may get used in a checkdb, but it shouldn't grow the db that I'm aware of.

What account is running SQL Agent? You can add that account as a login.

Is that account being used to run multiple instances? I wonder if there is some strangeness in W2K3 checking this.

And this is why do DO NOT delete old backups before ensuring the new one is complete and successful.

Strange. Thanks for the update, and glad it's working.

you can bring in a Database Diagram as well.

Unless you've populated a description of the field in the extended properties, I'm not sure a tool helps.

If you want something beyond...

Thanks, that's a great complement and glad you like the site and my mistakes, err, human-ness, yeah. I think I'll do a "human reel" next month 🙂

Mirroring is by database, doesn't move logins, jobs, etc. Clustering is by instance.

There is a security check, and you'd need to link in the databases (linked server or view), but there isn't a substantial difference I'd think in having separate databases.

First, use roles. Don't grant rights to a user, even if it's one. at some point this person will move on and someone else will do their job.

Create a...