Scripting the creation of a database from a backup in SQL Server

I currently have a tediously long process for creating new instances of a CMS we make.

I plan to script as much of the process as I can, using Python.

The first step is creating a database.

Currently it is a manual process where I will create an empty database "MyNewSite" and then select restore from backup and restore it from the "master" db file. Before the restore I change the data and log paths accor开发者_如何学Pythondingly (so they dont overwrite the master).

Is there any way to automate this? I'm not really sure where to begin so any help would be appreciated.

The CMS you make should have a deployment script. All your development process should update upgrade scripts, never touch the database directly. Database updates should be deployed through source code (upgrade scripts) and version control: Version Control and your Database.