I have a SQL Server 2008 running on a remote host (I bought it through a webhosting company).
My website is ready for testing, and I need to backup the database, so I can reset everything that I wrote in the tables, when testing is finished.
What I would prefer is to have a button in the administration site that can reset the database with the backup, when clicked. Is this possible?
How can I accomplish this with SQL Server Management Studio?