MSDE and installing MS SQL server 2000

Sorry if this is a stupid question , i'm a newbie to SQL server and MSDE. I
read the installation manual but couldn't find the answer:-;
Question:
I've a server running MSDE latest patches etc.
I just purchaced MS SQL server 2000 standaard edition.
Does the installation of MS sql 2000 server takes care of copying and using
the old MSDE database(s)?
There is one application using MSDE with MSSQLSERVER as named instance, I
Think :-?
Or do i need to desintall MSDE?
Thanks for the time
Hi,
SQL Server standard edition Installation will not copy the existing
databases. Databases
you need to copy manually.
Easy approach is:-
1. Install SQL 2000 with same service pack in new machine as old
2. Stop MSSQL Server and SQL Agent service is Old server as well as in new
server
3. Copy MDF and LDF files to the new server (Incluing system databases -
Master, msdb, tempdb, model),
It is a must that you should copy the folders to same folders
as in old server
4. Start MSSQl Server service in new server
5. Login to Query Analyzer in new machine and change the SQL server name
select @.@.servername
-- The name should be old server name
Execute below script to change the server name, this step is no required
if you do not want to change server name.
sp_dropserver <servername>
go
sp_addserver <newserver_name>,local
6. Stop and start MSSQL Server and SQl agent service. Login to Enterprise
manager and see whether all your databases are up.
Note:
Ensure that you install the new SQL server with the same directory structure
as old and copy the MDF and LDF to the same folders. otherwise the database
will not come online.
You can also look into the below links to move the databases.
move the data via backup and restore
http://support.microsoft.com/default...;en-us;Q304692
sp_detach_db and sp_attach_db
http://support.microsoft.com/support.../q224/0/71.asp
one more option -- the copy database wizard
http://support.microsoft.com/default...;en-us;Q274463
PRB: User Logon and/or Permission Errors After Restoring Dump (Q168001)
http://support.microsoft.com/default...;en-us;Q168001
Thanks
Hari
SQL Server MVP
"lau" <lau@.discussions.microsoft.com> wrote in message
news:66F50CDB-4DED-4E50-B7FE-45E0CE5AFCA4@.microsoft.com...
> Sorry if this is a stupid question , i'm a newbie to SQL server and MSDE.
> I
> read the installation manual but couldn't find the answer:-;
> Question:
> I've a server running MSDE latest patches etc.
> I just purchaced MS SQL server 2000 standaard edition.
> Does the installation of MS sql 2000 server takes care of copying and
> using
> the old MSDE database(s)?
> There is one application using MSDE with MSSQLSERVER as named instance, I
> Think :-?
>
> Or do i need to desintall MSDE?
> Thanks for the time
>

MSDE and installing MS SQL server 2000

Sorry if this is a stupid question , i'm a newbie to SQL server and MSDE. I
read the installation manual but couldn't find the answer:-;
Question:
I've a server running MSDE latest patches etc.
I just purchaced MS SQL server 2000 standaard edition.
Does the installation of MS sql 2000 server takes care of copying and using
the old MSDE database(s)?
There is one application using MSDE with MSSQLSERVER as named instance, I
Think :-?
Or do i need to desintall MSDE?
Thanks for the timeHi,
SQL Server standard edition Installation will not copy the existing
databases. Databases
you need to copy manually.
Easy approach is:-
1. Install SQL 2000 with same service pack in new machine as old
2. Stop MSSQL Server and SQL Agent service is Old server as well as in new
server
3. Copy MDF and LDF files to the new server (Incluing system databases -
Master, msdb, tempdb, model),
It is a must that you should copy the folders to same folders
as in old server
4. Start MSSQl Server service in new server
5. Login to Query Analyzer in new machine and change the SQL server name
select @.@.servername
-- The name should be old server name
Execute below script to change the server name, this step is no required
if you do not want to change server name.
sp_dropserver <servername>
go
sp_addserver <newserver_name>,local
6. Stop and start MSSQL Server and SQl agent service. Login to Enterprise
manager and see whether all your databases are up.
Note:
Ensure that you install the new SQL server with the same directory structure
as old and copy the MDF and LDF to the same folders. otherwise the database
will not come online.
----
--
You can also look into the below links to move the databases.
move the data via backup and restore
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q304692
sp_detach_db and sp_attach_db
http://support.microsoft.com/support/kb/articles/q224/0/71.asp
one more option -- the copy database wizard
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q274463
PRB: User Logon and/or Permission Errors After Restoring Dump (Q168001)
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q168001
Thanks
Hari
SQL Server MVP
"lau" <lau@.discussions.microsoft.com> wrote in message
news:66F50CDB-4DED-4E50-B7FE-45E0CE5AFCA4@.microsoft.com...
> Sorry if this is a stupid question , i'm a newbie to SQL server and MSDE.
> I
> read the installation manual but couldn't find the answer:-;
> Question:
> I've a server running MSDE latest patches etc.
> I just purchaced MS SQL server 2000 standaard edition.
> Does the installation of MS sql 2000 server takes care of copying and
> using
> the old MSDE database(s)?
> There is one application using MSDE with MSSQLSERVER as named instance, I
> Think :-?
>
> Or do i need to desintall MSDE?
> Thanks for the time
>

MSDE and installing MS SQL server 2000

Sorry if this is a stupid question , i'm a newbie to SQL server and MSDE. I
read the installation manual but couldn't find the answer:-;
Question:
I've a server running MSDE latest patches etc.
I just purchaced MS SQL server 2000 standaard edition.
Does the installation of MS sql 2000 server takes care of copying and using
the old MSDE database(s)?
There is one application using MSDE with MSSQLSERVER as named instance, I
Think :-?
Or do i need to desintall MSDE?
Thanks for the timeHi,
SQL Server standard edition Installation will not copy the existing
databases. Databases
you need to copy manually.
Easy approach is:-
1. Install SQL 2000 with same service pack in new machine as old
2. Stop MSSQL Server and SQL Agent service is Old server as well as in new
server
3. Copy MDF and LDF files to the new server (Incluing system databases -
Master, msdb, tempdb, model),
It is a must that you should copy the folders to same folders
as in old server
4. Start MSSQl Server service in new server
5. Login to Query Analyzer in new machine and change the SQL server name
select @.@.servername
-- The name should be old server name
Execute below script to change the server name, this step is no required
if you do not want to change server name.
sp_dropserver <servername>
go
sp_addserver <newserver_name>,local
6. Stop and start MSSQL Server and SQl agent service. Login to Enterprise
manager and see whether all your databases are up.
Note:
Ensure that you install the new SQL server with the same directory structure
as old and copy the MDF and LDF to the same folders. otherwise the database
will not come online.
----
--
You can also look into the below links to move the databases.
move the data via backup and restore
http://support.microsoft.com/defaul...b;en-us;Q304692
sp_detach_db and sp_attach_db
http://support.microsoft.com/suppor...s/q224/0/71.asp
one more option -- the copy database wizard
http://support.microsoft.com/defaul...b;en-us;Q274463
PRB: User Logon and/or Permission Errors After Restoring Dump (Q168001)
http://support.microsoft.com/defaul...b;en-us;Q168001
Thanks
Hari
SQL Server MVP
"lau" <lau@.discussions.microsoft.com> wrote in message
news:66F50CDB-4DED-4E50-B7FE-45E0CE5AFCA4@.microsoft.com...
> Sorry if this is a stupid question , i'm a newbie to SQL server and MSDE.
> I
> read the installation manual but couldn't find the answer:-;
> Question:
> I've a server running MSDE latest patches etc.
> I just purchaced MS SQL server 2000 standaard edition.
> Does the installation of MS sql 2000 server takes care of copying and
> using
> the old MSDE database(s)?
> There is one application using MSDE with MSSQLSERVER as named instance, I
> Think :-?
>
> Or do i need to desintall MSDE?
> Thanks for the time
>

MSDE and Full SQL Server

This might be a stupid questions but,
Can you have a MSDE 2000 and SQL server
standard/enterprise on the same machine?
If not, can you have to instances of SQL databse with
different passwords for the 'sa' account in the respective
instances.
Many thanks
NicYou can have up to 16 instances of any edition of SQL Server 2000 (including
MSDE 2000) on a single computer.
sa is just one login that can be a member of the sysadmin fixed server role.
Any login in the sysadmin fixed server role has sys admin priviledges for
that instance of SQL Server. This would extend to any database for the
instance.
--
Alan Brewer [MSFT]
Lead Programming Writer
SQL Server Documentation Team
This posting is provided "AS IS" with no warranties, and confers no rights

MSDE and Full SQL Server

This might be a stupid questions but,
Can you have a MSDE 2000 and SQL server
standard/enterprise on the same machine?
If not, can you have to instances of SQL databse with
different passwords for the 'sa' account in the respective
instances.
Many thanks
NicYou can have up to 16 instances of any edition of SQL Server 2000 (including
MSDE 2000) on a single computer.
sa is just one login that can be a member of the sysadmin fixed server role.
Any login in the sysadmin fixed server role has sys admin priviledges for
that instance of SQL Server. This would extend to any database for the
instance.
Alan Brewer [MSFT]
Lead programming Writer
SQL Server Documentation Team
This posting is provided "AS IS" with no warranties, and confers no rightssql