You can consider using split backups

You can use BCP

Use available DMV's it will not harm the perormence of the servers.

Why do u want to perform all the stuff at a shot??? How big your databases?

Plan accrodingly to the size of the databases.

Yes u can.....

Use BCP. It will faster and not logged

is the latest diff backup taken after old full backup????

What is the tool that u are using to copy the tables? u can disable the constraints, copy the data and enable the constraint.

You can write down as script and schedule the same in a job.

NULLIF returns the first expression if the two expressions are not equal. If the expressions are equal, NULLIF returns a null value of the type of the first expression.

Seems to be permission issue

check the following link

http://support.microsoft.com/kb/929665

nullif:Returns a null value if the two specified expressions are equal.

If your SQL Server’s tempdb database is heavily used by your application(s),consider locating it on an array of its own (such as RAID 1 or RAID 10). This will allow...

Thanks for the comments.

Duplicate Post