"mrdenny" <mrdenny@mrdenny.com> wrote in message
news:1152895365.186189.152340@i42g2000cwa.googlegroups.com...
> You've got a couple of options.
>
> 1. Install SQL 2005 Express edition (it's a crippled version of SQL
> 2005, 1 CPU, 1 GB of RAM, 4 GB database max)
> 2. Install the database on another server and have the web server
> access that database
> 3. Update the web server from Web Edition to Standard Edition
>
> Denny
>
> Tom wrote:
> > How, then is the best way to get the database to the webserver?
> >
> > Thanks,
> > Tom
> >
> > "mrdenny" <mrdenny@mrdenny.com> wrote in message
> > news:1152827746.575171.149350@b28g2000cwb.googlegroups.com...
> > > If all you have installed is the SQL Server 2005 Managment Studio that
> > > you can not restore the database. You have to have the database
engine
> > > installed on the server in order to restore the database. Most
> > > versions of SQL (2000 or 2005) will not install on the Web Edition of
> > > Windows 2003.
> > >
> > > Denny
> > > Tom wrote:
> > > > I have an SQL 2000 database that is backed up every evening with
> > enterprise
> > > > manager. I need to be able to restore the database to a separate
machine
> > > > running Windows 2003 Web Server Edition, for client access to that
data.
> > I
> > > > have installed SQL 2005 Server Management Studio on the Webserver ,
> > however
> > > > I see no way to restore the database. Any suggestions?
> > > >
> > > > Thanks,
> > > > Tom
> > >
>