What you would need to do is serialize these. So backup, then script the move, then backup next one, etc. You'd need validation to be sure that the backup was...

Are you executing through BIDS? sp_start_job? How?

http://searchenterpriselinux.techtarget.com/tip/0,289483,sid39_gci1207179,00.html\

http://www.isql.org/2007/02/mysql-vs-sybase-ms-sql-server.html

How are you executing the package?

If it needs Windows auth, you need to call it from an account that uses Windows auth or there are no credentials.

SQLSentry has a great tool for scheduling stuff across servers and managing the process.

SQL Agent works well, however, might not be the best choice here. Windows Scheduler works, but doesn't...

What are you trying to achieve? Perhaps we can suggest something. Replication doesn't necessarily seem to fit what you are asking.

You can learn a lot from reading about this, but that won't necessarily get you to think about everything. This is a complex subject, and a lot of moving to...

The question is based on identities and defaults. You don't know how many columns, so how can you insert a row? It might seem unclear, but I think it you...

I think you have to reassess how you look at things, do lots of testing, and possibly revisit your architectures. I think this can work. Not that it should, but...

Make sure it's the same on both nodes as well.

It's a round robin type thing.

You can do one file / filegroup and get this granuarity.

Are you talking about paging? There are articles on this site dealing with that.

http://www.sqlservercentral.com/articles/Advanced+Querying/3181/

I'd agree with Gus. I'd also start by being sure you are using N' data types (Nvarchar, ntext, etc.)

Haven't tested it, but this (http://msdn.microsoft.com/en-us/library/ms186865.aspx) seems to indicate it does.

It doesn't prevent another process or user from deleting them.

FWIW, I'd consider this the way to do things. Always restore with NORECOVERY and then once you're sure you're done, run the statement Gail has listed above.