Hi all,

I have a task where i need to configure database mirroring for 400 databases at a time. I need a single TSQL Script to restore all the databases full backups with no recovery mode at a time.

QUick answer will be really appreciated. 

Hi all,

I have a task where i need to configure database mirroring for 400 databases at a time. I need a single TSQL Script to restore all the databases full backups with no recovery mode at a time.

QUick answer will be really appreciated. 

Are all these databases on single SQL instance ? If so there would be heavy load.There is surely script to create DB mirroring through script but please take my advise please go one at a time.Below links will be helpdul

http://ifcsong.wordpress.com/2011/10/11/setup-database-mirroring-using-windows-authentication-t-sql/

http://blogs.msdn.com/b/sqlserverfaq/archive/2009/03/31/setting-up-database-mirroring-in-sql-server-2008-using-t-sql-when-the-database-is-encrypted-using-transparent-data-encryption.aspx