1

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.

Community
  • 1
Jonathan
  • 111
  • 1
  • 4
  • 5
    I prefer to automate the restore from my backups. That way you get automatic testing thay your backup and restore procedures work as well. – Grant May 21 '14 at 12:38

2 Answers2

1

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

Community
  • 1
MichelZ
  • 11,008
  • 4
  • 30
  • 58
1

Use the Copy Database Wizard. - Right click the source database - Choose Tasks - Copy Database.

In the guide You can choose to create a schedule for the job also.

Rolf Sørensen
  • 11
  • 1