Automate how to copy a DB from Server A to Server B

[i9796674]

Hi,

Is there any tool in SQL Server that allows scheduling to copy a DB from Server A to B?

Thanks

[JinxT]

Hi,

Is there any tool in SQL Server that allows scheduling to copy a DB from Server A to B?

Thanks

Hi,

You could use an ssis package with a copy database task. Or you could write a stored procedure in which you backup from server A, then restore to server B via a linked server - then schedule stored procedure in SQL Agent.

Jinx.