You are welcome and glad it will help.

One cool thing to think about as well is that clients can actually generate the GUID themselves and insert the values. They're unique,...

Is there something in particular you want to check? The maintenance plan runs as a job, which can be set to alert you on success and/or failure.

Actually you could use log shipping.

What I'd think about doing is restoring the production db, then set up log shipping. You might want to pause the jobs for log shipping...

Actually if you have possible corruption on your system database, I wouldn't mess around. We might get you past it, but something else could happen.

Call PSS and work through this...

As it says, you can force the subscription by passing in a parameter.

Here's the entry in BOL: http://technet.microsoft.com/en-us/library/ms175980.aspx

This is a high end certification, mostly for internal MS people and consultants. Not sure it's worth it unless you plan on being a consultant and billing a high $$/hr...

Monitor meaning record size or alert you if it gets to some size?

You can run perfmon, log the size in a CSV and chart it, load into a table, etc....

That KB shows you how to script out the logins and move them over, with passwords intact.

As Pam mentioned, this won't do anything to them on the principal.

I agree with Greg that this is probably not stored anywhere. If you have logins audited, you could check who logged in at various times.

However if no one will admit...

You can't remove the file without removing all objects from the file.

An output parameter can be used to assign a variable the result of a stored procedure. Less used now that we have user-defined functions.

For dynamic Sql, it's something like

declare @cmd...

DO NOT SHRINK databases. This messes with your indexes and increases fragmentation.

You need to have free space in your database. As people add data or change it, there should be...

How are you exporting in the job? Meaning what's being run?

DTS would make this easy. You can use the data export wizard to help set this up from Enterprise Manager.

Look up dateadd in BOL for the syntax.

Most of these are system stored procedures.

First, don't allow guest or others into msdb, and you can ignore the public permissions there. If a user doesn't have access to the...