But you need SYSADMIN or DB_OWNER to be able to execute the shrink.

You can't stop someone executing a shrink outside the wrapper code.

So while you might block them in the...

But if the user is a "SysAdmin" or a "db_owner" they can do what they want, when they want, where they want and you cannot stop them for love nor...

This is by design.

SQL once it has got the memory will not release it unless the operating system asks for it.

SQL is designed to read from RAM, every page request...

Don't modify the mdf file of tempdb, I have seen it do some very crazy things when the MDF file has been modified.

Revert the mdf file back to the original...

Does the profile require authentication?  Or is it anonymous auth?

Seen it do this with a username and password required to send before.

Why are you shrinking it?  There must be a reason the data file grew that big?  Have you ironed out that problem? You're only going to have to do an...

Brain dumps are usually from people who have a photogenic memory who can look at the screen, remember the question and answers and reproduce that outside of the invigilated environment. ...

Without seeing what’s going on it’s hard to say for sure.

my guess is something none native with the data types is happening so it’s extrapolating the sizes some what.  Int...

How are you going to test you've successfully done a full transfer?

Part of things like this need testing.

If you want to wing it, well that's your choice, but I strongly...

The file location doesn't exist

The system cannot find the path specified.

Ensure the file paths below exist, if not create them, assign permissions and put in the right files

L:\LogFiles\, L:\LogFiles\Alerts_log.ldf, I:\DataFiles\, I:\DataFiles\Alerts.mdf

You need to install the ACE driver if you haven’t already done so wherever your going to be running this package.

There is a 32bit and 64bit version so you need...

Also what snapshot options have you specified?

native character sets?

compressed snapshots?

any of the database compressed at row or page level?

This a VM or a physical piece of tin?

is it a virtual disk or a rdm?

is it thick or thin provisioned?

if it’s been thin provisioned and the the lun is...

From looking at it, you need to put in the right SMTP server for whatever you have on your environment that can relay mail.  My guess is that your mail...

So you got a number of parameterised execute SQL tasks there, one is "Generate GUID", my guess is that GUID is being passed down the chain, so its the SSIS...