On a weekly basis, we have to update our SQL Server from another SQL Server. We receive a script file to define the tables and a backup to restore the data.
What would be the best way to execute the script and restore the data without having to go into SQL Server Enterprise Manager?