Sql-server – Scheduled copy of production database into test database

database-administrationdatabase-replicationsql server

My question is similar to this one.

I've Two different severs (both SQL Server 2014 Std Edition). Production and Test. I want my test server to connect every night to the production server and copy/clone one database.

I Know I could schedule a backup in the Production server, put this backup in a shared folder and the restore it in the Test Server.

Is there any way to make the Test Server do all the job without using any shared folder?

Thanks.

Best Answer

You could write a program which does it all in TSQL. Or use an SSIS task

Have a look on this SO post for some more details

Related Topic