Depends on how long you want to keep the information for 🙂

If it's only for a short time to allow export to a reporting database, you could use Change Data...

Could be a disk bottleneck, or latency if you're backing up to a network share.

There's some discussion and good advice here:

http://social.msdn.microsoft.com/Forums/sqlserver/en-US/7542f102-854f-4283-874c-2d78a2d85feb/full-database-backup-takes-so-long

Do you really need the instance name and the port number ?

I've always used (for an instance on port 666):

Servername,666 not servername\instancename,666

..or is it special for SQL...

I seem to remember having a similar question myself a while back, which broke down as follows:

If the data set it too large to fit in the RAM that SSIS...

You don't need to bring the database back online before doing the restore.

I do this quite a lot:

ALTER DATABASE myDatabase SET OFFLINE WITH ROLLBACK IMMEDIATE;

RESTORE DATABASE [myDatabase] FROM DISK...

If you omit the @sensitivity parameter, does the mail send OK ? And I know it's a stupid question, but can you send a mail to the intended...

As long as your mail profile is called 'Profile Name', that looks OK.

Have you checked the logs as per http://technet.microsoft.com/en-us/library/ms190630(v=sql.105).aspx ?

OK, this is largely from my own experience, but backed up by what we know about database backups.

When a database backup is started, an internal snapshot is taken to preserve...

Love it when people did stuff "because it works", only to leave a timebomb for us later on 😛

Good effort getting as far as you did, though !!

You can't full back up a database at the same time as another full backup is already running.

Worst case is the second will queue behind the first one until the...

This is most likely the cause of the problem. 'dbo' has access to all objects in all schemas, so can do the DROP fine.

Do all users have their...

As a first, there's this:

http://technet.microsoft.com/en-us/library/ms187540(v=sql.105).aspx

🙂

Can you share a extract of the procedure that you're using to send mail ? just the bit that does the sending, not the full text...

Kinda. Once allocated, nothing will change the port number unless it's changes manually.

AFAIK, there's no windows service or function that monitors or allocates TCP ports. Technically, there's nothing stopping 2...

The name 'dynamic ports' is a bit confusing.

If selected on installation, SQL Setup will pick an available port, and assign that to SQL Server, but that's about as dynamic as...

This probably isn't the kind of advice you were looking for, but it's usually best to re-write your ETL in SSIS directly rather that attempt to migrate DTS to SSIS.

There...