Hello
Can anybody give me an idea or a script which can be used to Restore a production Database to Test Database on another server. As I need to do this 3 days a week, I would like to make this automated.
Thanks
Printable View
Hello
Can anybody give me an idea or a script which can be used to Restore a production Database to Test Database on another server. As I need to do this 3 days a week, I would like to make this automated.
Thanks
You can run this as scheduled job:
restore database db_name from disk = '\\host_name\share\file_name' with ...
You have to start sql agent service with domain account that has permission to read backup file, and may need use move option in restore statement if db file path is different on those servers.