From Books Online, what it says is a full backup contains the data and the rest (logins, stored procs, etc) at the time the backup is finished. So any transactions...

As mentioned by Johan, the best bet is to look for Windows Event logs around the time frame when the failover happened, to know when the failover happened, there are...

You will have to have a local string variable and pass the parameter value to that local variable and execute that..

in short, this is how it should look like..

DECLARE

How are you saving the SSIS package, (from Bids or from SSMS or how?), that might help a little in troubleshooting..

Also, where is the SSIS package residing now?

No, I have multiple dedicated SSIS Servers and some of them have Standard Edition, where we can save the...

Please look at this msdn example.

http://msdn.microsoft.com/en-us/library/ms170572.aspx

Try adding some kind of looping to that..

Have you thought about Replication to do what you want to achieve? If not, I would recommend you to explore that possibility. Though it is too generic of an answer,...

Can't say exactly why that is happening (might be blocking / deadlocking involved).. If the timeouts occur repeatedly at the same time, then you might want to see if...

You are welcome..

I am not sure if attach / detach is considered as a best practice, but I would be more inclined to do it using backup / restore, unless there is...

Just to add to what is already suggested..

You should look at the total size of all the databases and what is the Kind of usage (OLTP or OLAP) of...

I would choose backup restore as my choice as I would not have to worry that db's on original Server are offline during the copying phase. If the databases are...

Attaching system databases is not possible, where as restoring the system db's is possible. However, restoring system db's from one SQL Instance is not done unless you know why you...

What is TDP?

Not knowing how the backups are configured is dangerous, as you (the DBA responsible for that SQL Server) has to know how are the backups configured in order...

How are the backups configured?

If you doing it from a custom script, check if the database names are hard-coded and remove that db name from that list of db's...