Showing posts with label sql2005. Show all posts
Showing posts with label sql2005. Show all posts
Friday, March 23, 2012
MSDE 2000 installed on SQL 2005 Server
I have a vendor suggesting that we install MSDE 2000 on our SQL 2005 server. They don't support SQL2005 yet and believe that this would be a supported installation of Microsoft products. Would this really be supported?We do support MSDE2000 and SQL Server 2005 side by side on the same box.|||Thank you very much. I feel comfortable proceeding with this enviroment now.sql
MSDE 2000 and SQL2005
I have to install MSDE 2000 with a backup application (CommVault Express
6.1) that does not yet support SQL 2005. I also need to install 2005 for
apps that will utilize this version. Are there any known problems with
running both of these versions of SQL on the same server?
Thanks,
Mark B.I have installed 2000 & 2005 on the same server before and they both work.
The 2000 install is the default instance and the 2005 is the named instance.
The only issue might be whether your server has enough resources to handle
both. Memory in particular. I don't think that both instaces share the same
memory space so you would have to make sure there is enough for both.
"Mark Bohlsen" wrote:
> I have to install MSDE 2000 with a backup application (CommVault Express
> 6.1) that does not yet support SQL 2005. I also need to install 2005 for
> apps that will utilize this version. Are there any known problems with
> running both of these versions of SQL on the same server?
> Thanks,
> Mark B.
>
>|||Yes, I agree with Michael. SQL Server 2000 including MSDE2000 can coexist
with SQL Server 2005 instances on the same computer. Considering SQL Server
performance, your computer may need much more memory and disk space for the
coexistance.
Please feel free to let us know if you need further assistance. Have a good
day!
Best regards,
Charles Wang
Microsoft Online Community Support
========================================
=============
When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from this issue.
========================================
==============
This posting is provided "AS IS" with no warranties, and confers no rights.
========================================
==============|||What about MSDE 2000 and SQL 2000 on the same server? Almost every website
I
read on this topic says something different.
I have a server that currently runs two named instances of MSDE 2000 SP3a.
I want to install SQL2000 (as the default instance) on the server (the serve
r
is light duty, but has 3GB of RAM). I'd imagine I could upgrade the MSDE
databases to SQL 2000 first, but I rather not since the MSDE instances are
working fine.
- Kevin
"Charles Wang[MSFT]" wrote:
> Yes, I agree with Michael. SQL Server 2000 including MSDE2000 can coexist
> with SQL Server 2005 instances on the same computer. Considering SQL Serve
r
> performance, your computer may need much more memory and disk space for th
e
> coexistance.
> Please feel free to let us know if you need further assistance. Have a goo
d
> day!
> Best regards,
> Charles Wang
> Microsoft Online Community Support
> ========================================
=============
> When responding to posts, please "Reply to Group" via
> your newsreader so that others may learn and benefit
> from this issue.
> ========================================
==============
> This posting is provided "AS IS" with no warranties, and confers no rights
.
> ========================================
==============
>
>
6.1) that does not yet support SQL 2005. I also need to install 2005 for
apps that will utilize this version. Are there any known problems with
running both of these versions of SQL on the same server?
Thanks,
Mark B.I have installed 2000 & 2005 on the same server before and they both work.
The 2000 install is the default instance and the 2005 is the named instance.
The only issue might be whether your server has enough resources to handle
both. Memory in particular. I don't think that both instaces share the same
memory space so you would have to make sure there is enough for both.
"Mark Bohlsen" wrote:
> I have to install MSDE 2000 with a backup application (CommVault Express
> 6.1) that does not yet support SQL 2005. I also need to install 2005 for
> apps that will utilize this version. Are there any known problems with
> running both of these versions of SQL on the same server?
> Thanks,
> Mark B.
>
>|||Yes, I agree with Michael. SQL Server 2000 including MSDE2000 can coexist
with SQL Server 2005 instances on the same computer. Considering SQL Server
performance, your computer may need much more memory and disk space for the
coexistance.
Please feel free to let us know if you need further assistance. Have a good
day!
Best regards,
Charles Wang
Microsoft Online Community Support
========================================
=============
When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from this issue.
========================================
==============
This posting is provided "AS IS" with no warranties, and confers no rights.
========================================
==============|||What about MSDE 2000 and SQL 2000 on the same server? Almost every website
I
read on this topic says something different.
I have a server that currently runs two named instances of MSDE 2000 SP3a.
I want to install SQL2000 (as the default instance) on the server (the serve
r
is light duty, but has 3GB of RAM). I'd imagine I could upgrade the MSDE
databases to SQL 2000 first, but I rather not since the MSDE instances are
working fine.
- Kevin
"Charles Wang[MSFT]" wrote:
> Yes, I agree with Michael. SQL Server 2000 including MSDE2000 can coexist
> with SQL Server 2005 instances on the same computer. Considering SQL Serve
r
> performance, your computer may need much more memory and disk space for th
e
> coexistance.
> Please feel free to let us know if you need further assistance. Have a goo
d
> day!
> Best regards,
> Charles Wang
> Microsoft Online Community Support
> ========================================
=============
> When responding to posts, please "Reply to Group" via
> your newsreader so that others may learn and benefit
> from this issue.
> ========================================
==============
> This posting is provided "AS IS" with no warranties, and confers no rights
.
> ========================================
==============
>
>
MSDE 2000 and SQL2005
I have to install MSDE 2000 with a backup application (CommVault Express
6.1) that does not yet support SQL 2005. I also need to install 2005 for
apps that will utilize this version. Are there any known problems with
running both of these versions of SQL on the same server?
Thanks,
Mark B.
I have installed 2000 & 2005 on the same server before and they both work.
The 2000 install is the default instance and the 2005 is the named instance.
The only issue might be whether your server has enough resources to handle
both. Memory in particular. I don't think that both instaces share the same
memory space so you would have to make sure there is enough for both.
"Mark Bohlsen" wrote:
> I have to install MSDE 2000 with a backup application (CommVault Express
> 6.1) that does not yet support SQL 2005. I also need to install 2005 for
> apps that will utilize this version. Are there any known problems with
> running both of these versions of SQL on the same server?
> Thanks,
> Mark B.
>
>
|||Yes, I agree with Michael. SQL Server 2000 including MSDE2000 can coexist
with SQL Server 2005 instances on the same computer. Considering SQL Server
performance, your computer may need much more memory and disk space for the
coexistance.
Please feel free to let us know if you need further assistance. Have a good
day!
Best regards,
Charles Wang
Microsoft Online Community Support
================================================== ===
When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from this issue.
================================================== ====
This posting is provided "AS IS" with no warranties, and confers no rights.
================================================== ====
|||What about MSDE 2000 and SQL 2000 on the same server? Almost every website I
read on this topic says something different.
I have a server that currently runs two named instances of MSDE 2000 SP3a.
I want to install SQL2000 (as the default instance) on the server (the server
is light duty, but has 3GB of RAM). I'd imagine I could upgrade the MSDE
databases to SQL 2000 first, but I rather not since the MSDE instances are
working fine.
- Kevin
"Charles Wang[MSFT]" wrote:
> Yes, I agree with Michael. SQL Server 2000 including MSDE2000 can coexist
> with SQL Server 2005 instances on the same computer. Considering SQL Server
> performance, your computer may need much more memory and disk space for the
> coexistance.
> Please feel free to let us know if you need further assistance. Have a good
> day!
> Best regards,
> Charles Wang
> Microsoft Online Community Support
> ================================================== ===
> When responding to posts, please "Reply to Group" via
> your newsreader so that others may learn and benefit
> from this issue.
> ================================================== ====
> This posting is provided "AS IS" with no warranties, and confers no rights.
> ================================================== ====
>
>
sql
6.1) that does not yet support SQL 2005. I also need to install 2005 for
apps that will utilize this version. Are there any known problems with
running both of these versions of SQL on the same server?
Thanks,
Mark B.
I have installed 2000 & 2005 on the same server before and they both work.
The 2000 install is the default instance and the 2005 is the named instance.
The only issue might be whether your server has enough resources to handle
both. Memory in particular. I don't think that both instaces share the same
memory space so you would have to make sure there is enough for both.
"Mark Bohlsen" wrote:
> I have to install MSDE 2000 with a backup application (CommVault Express
> 6.1) that does not yet support SQL 2005. I also need to install 2005 for
> apps that will utilize this version. Are there any known problems with
> running both of these versions of SQL on the same server?
> Thanks,
> Mark B.
>
>
|||Yes, I agree with Michael. SQL Server 2000 including MSDE2000 can coexist
with SQL Server 2005 instances on the same computer. Considering SQL Server
performance, your computer may need much more memory and disk space for the
coexistance.
Please feel free to let us know if you need further assistance. Have a good
day!
Best regards,
Charles Wang
Microsoft Online Community Support
================================================== ===
When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from this issue.
================================================== ====
This posting is provided "AS IS" with no warranties, and confers no rights.
================================================== ====
|||What about MSDE 2000 and SQL 2000 on the same server? Almost every website I
read on this topic says something different.
I have a server that currently runs two named instances of MSDE 2000 SP3a.
I want to install SQL2000 (as the default instance) on the server (the server
is light duty, but has 3GB of RAM). I'd imagine I could upgrade the MSDE
databases to SQL 2000 first, but I rather not since the MSDE instances are
working fine.
- Kevin
"Charles Wang[MSFT]" wrote:
> Yes, I agree with Michael. SQL Server 2000 including MSDE2000 can coexist
> with SQL Server 2005 instances on the same computer. Considering SQL Server
> performance, your computer may need much more memory and disk space for the
> coexistance.
> Please feel free to let us know if you need further assistance. Have a good
> day!
> Best regards,
> Charles Wang
> Microsoft Online Community Support
> ================================================== ===
> When responding to posts, please "Reply to Group" via
> your newsreader so that others may learn and benefit
> from this issue.
> ================================================== ====
> This posting is provided "AS IS" with no warranties, and confers no rights.
> ================================================== ====
>
>
sql
MSDE 2000 and SQL2005
I have to install MSDE 2000 with a backup application (CommVault Express
6.1) that does not yet support SQL 2005. I also need to install 2005 for
apps that will utilize this version. Are there any known problems with
running both of these versions of SQL on the same server?
Thanks,
Mark B.I have installed 2000 & 2005 on the same server before and they both work.
The 2000 install is the default instance and the 2005 is the named instance.
The only issue might be whether your server has enough resources to handle
both. Memory in particular. I don't think that both instaces share the same
memory space so you would have to make sure there is enough for both.
"Mark Bohlsen" wrote:
> I have to install MSDE 2000 with a backup application (CommVault Express
> 6.1) that does not yet support SQL 2005. I also need to install 2005 for
> apps that will utilize this version. Are there any known problems with
> running both of these versions of SQL on the same server?
> Thanks,
> Mark B.
>
>|||Yes, I agree with Michael. SQL Server 2000 including MSDE2000 can coexist
with SQL Server 2005 instances on the same computer. Considering SQL Server
performance, your computer may need much more memory and disk space for the
coexistance.
Please feel free to let us know if you need further assistance. Have a good
day!
Best regards,
Charles Wang
Microsoft Online Community Support
=====================================================When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from this issue.
======================================================This posting is provided "AS IS" with no warranties, and confers no rights.
======================================================|||What about MSDE 2000 and SQL 2000 on the same server? Almost every website I
read on this topic says something different.
I have a server that currently runs two named instances of MSDE 2000 SP3a.
I want to install SQL2000 (as the default instance) on the server (the server
is light duty, but has 3GB of RAM). I'd imagine I could upgrade the MSDE
databases to SQL 2000 first, but I rather not since the MSDE instances are
working fine.
- Kevin
"Charles Wang[MSFT]" wrote:
> Yes, I agree with Michael. SQL Server 2000 including MSDE2000 can coexist
> with SQL Server 2005 instances on the same computer. Considering SQL Server
> performance, your computer may need much more memory and disk space for the
> coexistance.
> Please feel free to let us know if you need further assistance. Have a good
> day!
> Best regards,
> Charles Wang
> Microsoft Online Community Support
> =====================================================> When responding to posts, please "Reply to Group" via
> your newsreader so that others may learn and benefit
> from this issue.
> ======================================================> This posting is provided "AS IS" with no warranties, and confers no rights.
> ======================================================>
>
6.1) that does not yet support SQL 2005. I also need to install 2005 for
apps that will utilize this version. Are there any known problems with
running both of these versions of SQL on the same server?
Thanks,
Mark B.I have installed 2000 & 2005 on the same server before and they both work.
The 2000 install is the default instance and the 2005 is the named instance.
The only issue might be whether your server has enough resources to handle
both. Memory in particular. I don't think that both instaces share the same
memory space so you would have to make sure there is enough for both.
"Mark Bohlsen" wrote:
> I have to install MSDE 2000 with a backup application (CommVault Express
> 6.1) that does not yet support SQL 2005. I also need to install 2005 for
> apps that will utilize this version. Are there any known problems with
> running both of these versions of SQL on the same server?
> Thanks,
> Mark B.
>
>|||Yes, I agree with Michael. SQL Server 2000 including MSDE2000 can coexist
with SQL Server 2005 instances on the same computer. Considering SQL Server
performance, your computer may need much more memory and disk space for the
coexistance.
Please feel free to let us know if you need further assistance. Have a good
day!
Best regards,
Charles Wang
Microsoft Online Community Support
=====================================================When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from this issue.
======================================================This posting is provided "AS IS" with no warranties, and confers no rights.
======================================================|||What about MSDE 2000 and SQL 2000 on the same server? Almost every website I
read on this topic says something different.
I have a server that currently runs two named instances of MSDE 2000 SP3a.
I want to install SQL2000 (as the default instance) on the server (the server
is light duty, but has 3GB of RAM). I'd imagine I could upgrade the MSDE
databases to SQL 2000 first, but I rather not since the MSDE instances are
working fine.
- Kevin
"Charles Wang[MSFT]" wrote:
> Yes, I agree with Michael. SQL Server 2000 including MSDE2000 can coexist
> with SQL Server 2005 instances on the same computer. Considering SQL Server
> performance, your computer may need much more memory and disk space for the
> coexistance.
> Please feel free to let us know if you need further assistance. Have a good
> day!
> Best regards,
> Charles Wang
> Microsoft Online Community Support
> =====================================================> When responding to posts, please "Reply to Group" via
> your newsreader so that others may learn and benefit
> from this issue.
> ======================================================> This posting is provided "AS IS" with no warranties, and confers no rights.
> ======================================================>
>
Monday, March 19, 2012
MSDE -> SQL2005Express
Hello, Can I upgrade MSDE to SQL2005 Express without lost any DB.
Thank you very much for help.
Best regards
hi,
Petr Jirman wrote:
> Hello, Can I upgrade MSDE to SQL2005 Express without lost any DB.
> Thank you very much for help.
> Best regards
yes, you can .. http://msdn2.microsoft.com/en-us/library/ms143393.aspx
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz http://italy.mvps.org
DbaMgr2k ver 0.21.0 - DbaMgr ver 0.65.0 and further SQL Tools
-- remove DMO to reply
|||Hello,
There will not be any data loss.
1. Install SQL Express
2. Backup the databases in MSDE
3. Restore the backup in SQL Express.
Thanks
Hari
"Petr Jirman" <PetrJirman@.discussions.microsoft.com> wrote in message
news:183A89E5-48F3-4A58-9D91-327DC3FFEA15@.microsoft.com...
> Hello, Can I upgrade MSDE to SQL2005 Express without lost any DB.
> Thank you very much for help.
> Best regards
|||Hi, thank you
PLS Do you know how can I make upgrade ? I would like upgrade with CMD
command. I have 263 instance of MSDE and I cannot say the SA password to any
other peaple (they is only PC worker).
"Andrea Montanari" wrote:
> hi,
> Petr Jirman wrote:
> yes, you can .. http://msdn2.microsoft.com/en-us/library/ms143393.aspx
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz http://italy.mvps.org
> DbaMgr2k ver 0.21.0 - DbaMgr ver 0.65.0 and further SQL Tools
> -- remove DMO to reply
>
>
|||hi,
Petr Jirman wrote:
> Hi, thank you
> PLS Do you know how can I make upgrade ? I would like upgrade with CMD
> command. I have 263 instance of MSDE and I cannot say the SA password
> to any other peaple (they is only PC worker).
aghhh!!!
you could prepare a "setting" file that will "include" the "secret" sa pwd
to be consumed so that you only have to burn a cd with SQLExpress installer
and the setting ini file and perform, for each computer, the required
installation.. the installer must be called, in that scenario, including the
setting file parameter..
or you can include in the cd a batch file calling the installer with all
required parameters..
you can have a look at all supported parameters at
http://msdn2.microsoft.com/en-us/library/ms144259.aspx, including setting's
ini file ...
when finished you have to trash the cd :D
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz http://italy.mvps.org
DbaMgr2k ver 0.21.0 - DbaMgr ver 0.65.0 and further SQL Tools
-- remove DMO to reply
|||Consider that when you convert your MSDE (SQL Server 2000) by attaching the
..MDF file to a SQL Server 2005 Express master database, the file itself will
be morphed and made unreadable by MSDE. When the conversion is done, the
database compatibility level will be set to 8.0 (SQL Server 2000) so most of
the SQL Server 2005 features won't work against the newly converted
database. To correct this, you'll need to use SQL Server Enterprise Manager
Express to change the Compatibility Level to 9.0. When you do the engine
scrubs the database looking for issues that you might need to correct before
it can be fully 9.0 (SQL Server 2005) compatible.
I discuss these issues in more detail in my book.
hth
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest books:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition) and
Hitchhiker's Guide to SQL Server 2005 Compact Edition
------
"Petr Jirman" <PetrJirman@.discussions.microsoft.com> wrote in message
news:183A89E5-48F3-4A58-9D91-327DC3FFEA15@.microsoft.com...
> Hello, Can I upgrade MSDE to SQL2005 Express without lost any DB.
> Thank you very much for help.
> Best regards
Thank you very much for help.
Best regards
hi,
Petr Jirman wrote:
> Hello, Can I upgrade MSDE to SQL2005 Express without lost any DB.
> Thank you very much for help.
> Best regards
yes, you can .. http://msdn2.microsoft.com/en-us/library/ms143393.aspx
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz http://italy.mvps.org
DbaMgr2k ver 0.21.0 - DbaMgr ver 0.65.0 and further SQL Tools
-- remove DMO to reply
|||Hello,
There will not be any data loss.
1. Install SQL Express
2. Backup the databases in MSDE
3. Restore the backup in SQL Express.
Thanks
Hari
"Petr Jirman" <PetrJirman@.discussions.microsoft.com> wrote in message
news:183A89E5-48F3-4A58-9D91-327DC3FFEA15@.microsoft.com...
> Hello, Can I upgrade MSDE to SQL2005 Express without lost any DB.
> Thank you very much for help.
> Best regards
|||Hi, thank you
PLS Do you know how can I make upgrade ? I would like upgrade with CMD
command. I have 263 instance of MSDE and I cannot say the SA password to any
other peaple (they is only PC worker).
"Andrea Montanari" wrote:
> hi,
> Petr Jirman wrote:
> yes, you can .. http://msdn2.microsoft.com/en-us/library/ms143393.aspx
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz http://italy.mvps.org
> DbaMgr2k ver 0.21.0 - DbaMgr ver 0.65.0 and further SQL Tools
> -- remove DMO to reply
>
>
|||hi,
Petr Jirman wrote:
> Hi, thank you
> PLS Do you know how can I make upgrade ? I would like upgrade with CMD
> command. I have 263 instance of MSDE and I cannot say the SA password
> to any other peaple (they is only PC worker).
aghhh!!!
you could prepare a "setting" file that will "include" the "secret" sa pwd
to be consumed so that you only have to burn a cd with SQLExpress installer
and the setting ini file and perform, for each computer, the required
installation.. the installer must be called, in that scenario, including the
setting file parameter..
or you can include in the cd a batch file calling the installer with all
required parameters..
you can have a look at all supported parameters at
http://msdn2.microsoft.com/en-us/library/ms144259.aspx, including setting's
ini file ...
when finished you have to trash the cd :D
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz http://italy.mvps.org
DbaMgr2k ver 0.21.0 - DbaMgr ver 0.65.0 and further SQL Tools
-- remove DMO to reply
|||Consider that when you convert your MSDE (SQL Server 2000) by attaching the
..MDF file to a SQL Server 2005 Express master database, the file itself will
be morphed and made unreadable by MSDE. When the conversion is done, the
database compatibility level will be set to 8.0 (SQL Server 2000) so most of
the SQL Server 2005 features won't work against the newly converted
database. To correct this, you'll need to use SQL Server Enterprise Manager
Express to change the Compatibility Level to 9.0. When you do the engine
scrubs the database looking for issues that you might need to correct before
it can be fully 9.0 (SQL Server 2005) compatible.
I discuss these issues in more detail in my book.
hth
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest books:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition) and
Hitchhiker's Guide to SQL Server 2005 Compact Edition
------
"Petr Jirman" <PetrJirman@.discussions.microsoft.com> wrote in message
news:183A89E5-48F3-4A58-9D91-327DC3FFEA15@.microsoft.com...
> Hello, Can I upgrade MSDE to SQL2005 Express without lost any DB.
> Thank you very much for help.
> Best regards
Subscribe to:
Posts (Atom)