MSDE / SQL Server

rDear all,
I have been reading the latest post on the exchangeability between MSDE and
SQL Server 2000.
MSDE databases are exchangeable with SQL Server databases, both direction,
except when the database size is greater than 2GB which is the limit for MSDE.
When I move a SQL Server database to MSDE, I have to make a backup from the
database on the sql server and restore it in msde using RESTORE DATABASE
FROM... and it works the same the other direction.
I have downloaded the SQLEVAL.EXE and I am going to install it on my laptop,
on which MSDE is already running. From the discussions running both on a
windows 2000 server should be possible. Can I run both on my laptop? Upon
installing the evaluation version next to MSDE are there any peticular things
I have to take into consideration?
regards,
DannyHi
No issues, but make sure that you install SP3a against the SQL Server 2000
installation.
The MSDE might be the default instance so the SQL Server 2000 installation
will then need to be a named instance.
Regards
Mike
"Danny Gaethofs" wrote:
> rDear all,
> I have been reading the latest post on the exchangeability between MSDE and
> SQL Server 2000.
> MSDE databases are exchangeable with SQL Server databases, both direction,
> except when the database size is greater than 2GB which is the limit for MSDE.
> When I move a SQL Server database to MSDE, I have to make a backup from the
> database on the sql server and restore it in msde using RESTORE DATABASE
> FROM... and it works the same the other direction.
> I have downloaded the SQLEVAL.EXE and I am going to install it on my laptop,
> on which MSDE is already running. From the discussions running both on a
> windows 2000 server should be possible. Can I run both on my laptop? Upon
> installing the evaluation version next to MSDE are there any peticular things
> I have to take into consideration?
> regards,
> Danny|||Dear Mike,
I am a bit confused about what you mean to tell me with default and named
instance. This is probably due to my lack of knowledge of sql server.
How can I indicate or see which one is the default instance?
regards,
Danny
"Mike Epprecht (SQL MVP)" wrote:
> Hi
> No issues, but make sure that you install SP3a against the SQL Server 2000
> installation.
> The MSDE might be the default instance so the SQL Server 2000 installation
> will then need to be a named instance.
> Regards
> Mike
> "Danny Gaethofs" wrote:
> > rDear all,
> >
> > I have been reading the latest post on the exchangeability between MSDE and
> > SQL Server 2000.
> >
> > MSDE databases are exchangeable with SQL Server databases, both direction,
> > except when the database size is greater than 2GB which is the limit for MSDE.
> >
> > When I move a SQL Server database to MSDE, I have to make a backup from the
> > database on the sql server and restore it in msde using RESTORE DATABASE
> > FROM... and it works the same the other direction.
> >
> > I have downloaded the SQLEVAL.EXE and I am going to install it on my laptop,
> > on which MSDE is already running. From the discussions running both on a
> > windows 2000 server should be possible. Can I run both on my laptop? Upon
> > installing the evaluation version next to MSDE are there any peticular things
> > I have to take into consideration?
> >
> > regards,
> > Danny|||You can go to the properties tab in EM of the SQL server and that will list
the name of your server. U can also go to the services in control panel and
look at the MSSQL service to find out the name. Usually the first instance
installed is your server name.
"Danny Gaethofs" wrote:
> Dear Mike,
> I am a bit confused about what you mean to tell me with default and named
> instance. This is probably due to my lack of knowledge of sql server.
> How can I indicate or see which one is the default instance?
> regards,
> Danny
> "Mike Epprecht (SQL MVP)" wrote:
> > Hi
> >
> > No issues, but make sure that you install SP3a against the SQL Server 2000
> > installation.
> >
> > The MSDE might be the default instance so the SQL Server 2000 installation
> > will then need to be a named instance.
> >
> > Regards
> > Mike
> >
> > "Danny Gaethofs" wrote:
> >
> > > rDear all,
> > >
> > > I have been reading the latest post on the exchangeability between MSDE and
> > > SQL Server 2000.
> > >
> > > MSDE databases are exchangeable with SQL Server databases, both direction,
> > > except when the database size is greater than 2GB which is the limit for MSDE.
> > >
> > > When I move a SQL Server database to MSDE, I have to make a backup from the
> > > database on the sql server and restore it in msde using RESTORE DATABASE
> > > FROM... and it works the same the other direction.
> > >
> > > I have downloaded the SQLEVAL.EXE and I am going to install it on my laptop,
> > > on which MSDE is already running. From the discussions running both on a
> > > windows 2000 server should be possible. Can I run both on my laptop? Upon
> > > installing the evaluation version next to MSDE are there any peticular things
> > > I have to take into consideration?
> > >
> > > regards,
> > > Danny