restoring db from web applications..

i am a computer sciences engineering student and and we have an assignment to create a web project with a database.

Our lecturers will store our submissions on a db server but they want our projects enable the restoring our own databases..

that is, they wanna be able to have a copy of our databases to a new db that they have just created.. and they want us to enable this feature in an install.aspx page in our project.. the new db is guaranteed that will have the same name as ours..

so now what i am supposed to include in install.aspx?

Hey,

What database type are we talking about, Oracle, SQL Server, etc?

|||

the database type is SQL Server 2005 database.. .. and the project is a Visual Studio 2005 ASp .NET 2.0 web application..

|||

Hey,

Look at the SMO API, which does have the ability to backup and restore. You can find plenty of resources on the web. Is it SQL 2005 or SQL Express? I don't know if you can with Express...

|||it is SQL Express ...|||

Hey,

I did find something that used SMO API with SQL Express.

Brian