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...

I'd contact MS directly if you need confirmation. They often don't publish specifics, but they'll answer something for your company.

Thanks, can you let us know which checker?

I thought 64 bit cost the same as 32? My understanding was that you purchases a "SQL server license" and can install either one, just not both.

If they might need to scale to separate servers, I might. Otherwise, not sure there's a benefit. You could use a schema for security, multiple disks for performance.