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

Restoring database in SQL - 7

Hi,
Some times, I am getting problem when I am restoring my SQL - 7 database ,
is there any web page which can clear the concept of restore/backup.
Thanks in advance
Hardik ShahBooks Online (the documentation that comes with SQL Server) is the best plac
e to start.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"h" <har_sha_99@.hotmail.com> wrote in message news:ud68KAGaGHA.3896@.TK2MSFTNGP05.phx.gbl...[
vbcol=seagreen]
> Hi,
> Some times, I am getting problem when I am restoring my SQL - 7 database ,
> is there any web page which can clear the concept of restore/backup.
> Thanks in advance
> Hardik Shah
>[/vbcol]|||h wrote:
> Hi,
> Some times, I am getting problem when I am restoring my SQL - 7 database ,
> is there any web page which can clear the concept of restore/backup.
> Thanks in advance
> Hardik Shah
>
As Tibor mentions, Books On Line is a good place to start, but you could
also try to describe the problems you have - then there might be
somebody in here that can help you.
Regards
Steen|||Hi,
my problem is :-
I have installed SQL - 7 at my home and work. instance name of both SQL is
differ.
I have created mydata.bak file at home and trying to restore at work, but I
am fail .
Any hints will be sincerly appreciated.
Hardik Shah
"Steen Persson (DK)" <spe@.REMOVEdatea.dk> wrote in message
news:#3D9oKHaGHA.428@.TK2MSFTNGP02.phx.gbl...
> h wrote:
,[vbcol=seagreen]
> As Tibor mentions, Books On Line is a good place to start, but you could
> also try to describe the problems you have - then there might be
> somebody in here that can help you.
> Regards
> Steen|||h wrote:
> Hi,
> my problem is :-
> I have installed SQL - 7 at my home and work. instance name of both SQL is
> differ.
> I have created mydata.bak file at home and trying to restore at work, but
I
> am fail .
> Any hints will be sincerly appreciated.
> Hardik Shah
>
It would still be a lot easier to give you some hints if you could tell
how you're doing the restore and which error message you get.
Regards
Steen

Restoring database in SQL - 7

Hi,
Some times, I am getting problem when I am restoring my SQL - 7 database ,
is there any web page which can clear the concept of restore/backup.
Thanks in advance
Hardik ShahBooks Online (the documentation that comes with SQL Server) is the best place to start.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"h" <har_sha_99@.hotmail.com> wrote in message news:ud68KAGaGHA.3896@.TK2MSFTNGP05.phx.gbl...
> Hi,
> Some times, I am getting problem when I am restoring my SQL - 7 database ,
> is there any web page which can clear the concept of restore/backup.
> Thanks in advance
> Hardik Shah
>|||h wrote:
> Hi,
> Some times, I am getting problem when I am restoring my SQL - 7 database ,
> is there any web page which can clear the concept of restore/backup.
> Thanks in advance
> Hardik Shah
>
As Tibor mentions, Books On Line is a good place to start, but you could
also try to describe the problems you have - then there might be
somebody in here that can help you.
Regards
Steen|||Hi,
my problem is :-
I have installed SQL - 7 at my home and work. instance name of both SQL is
differ.
I have created mydata.bak file at home and trying to restore at work, but I
am fail .
Any hints will be sincerly appreciated.
Hardik Shah
"Steen Persson (DK)" <spe@.REMOVEdatea.dk> wrote in message
news:#3D9oKHaGHA.428@.TK2MSFTNGP02.phx.gbl...
> h wrote:
> > Hi,
> >
> > Some times, I am getting problem when I am restoring my SQL - 7 database
,
> > is there any web page which can clear the concept of restore/backup.
> >
> > Thanks in advance
> >
> > Hardik Shah
> >
> >
> As Tibor mentions, Books On Line is a good place to start, but you could
> also try to describe the problems you have - then there might be
> somebody in here that can help you.
> Regards
> Steen|||h wrote:
> Hi,
> my problem is :-
> I have installed SQL - 7 at my home and work. instance name of both SQL is
> differ.
> I have created mydata.bak file at home and trying to restore at work, but I
> am fail .
> Any hints will be sincerly appreciated.
> Hardik Shah
>
It would still be a lot easier to give you some hints if you could tell
how you're doing the restore and which error message you get.
Regards
Steen