MSDB database restore: number

Showing posts with label number. Show all posts

Wednesday, March 21, 2012

MSDE 1.0 TO MSDE 2000 Release A

I've used MSDE 1.0 for a number of years.
Today I downloaded Release A with the intention of installing it, but when I
attempt to run Setup I get a dialog saying "The instance name specified is
invalid." What could be causing this?
Also... what impact will an installation of MSDE 2000 have on my existing
MSDE 1.0 databases? Is there a procedure I should be following?
Thanks in advance.
Nancy
hi Nancy,
"Nancy Lorieau" <NancyLorieau@.discussions.microsoft.com> ha scritto nel
messaggio news:81D8BF32-88C8-4F0C-AE24-0C8BCC213BC5@.microsoft.com...
> I've used MSDE 1.0 for a number of years.
> Today I downloaded Release A with the intention of installing it, but when
I
> attempt to run Setup I get a dialog saying "The instance name specified is
> invalid." What could be causing this?
>
personally I never "upgraded" MSDE 1.0 instance to MSDE 2000 ... I always
backedup the users database and restored them on the MSDE2000 new instance
after uninstalling MSDE 1.0.. but I had no reason to maintain the MSDE 1.0
instance at all...
anyway,
http://msdn.microsoft.com/library/de...stsql_84xl.asp
reports you have to add the
UPGRADE=1 UPGRADEUSER=username UPGRADEPWD=userpwd
commandline parameters to your call to the setup.exe bootstrap installer...

> Also... what impact will an installation of MSDE 2000 have on my existing
> MSDE 1.0 databases? Is there a procedure I should be following?
the users databases will be upgraded to MSDE 2000 level... you coul'd be
affected by cross database ownership chaining, which behaviour has been
changed... further info at
http://msdn.microsoft.com/library/de...onfig_8d7m.asp
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.8.0 - DbaMgr ver 0.54.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply

Monday, March 19, 2012

MSDE > SQL Express

We have a product on the market, with 100k or so installs that use MSDE as its database (desktop application in .net). Our number 1 complaint is massive installation problems with MSDE.

Now, we are stuck a bit - first, we need to release a Vista Compatible version - which means no MSDE. We also need to migrate users from MSDE to SQL Express, with no data loss (we deal with financial information, and people tend to have zero tolerance for data loss here).

So, I have large scale reservations for two reasons - first, Microsoft's track record in supporting and making MSDE in the past has not been stellar.

With that said - are the multiple installation failure issues fixed in SQL Express? Did MS make the effort to get SQL Express to install on Win2k/XP/Vista improved? Are their benchmark figures out there regarding SQL Express install failure rates?

Additionally, can I get some information regarding MSDE to SQL Express upgrades done during for existing customers?

jason

Hi Jason,

Great strides have been made in installation for SQL Express and it is much better than MSDE. This is not to say there are no issues, a quick search of this forum will confirm that there are, but I have not seen the kind of wholesale failures that were common with MSDE. I think SQL Express is way better for install than MSDE.

I don't know of anyone that tracks benchmarks such as you describe, sorry. I can point you to an article that we have that describes best practices for upgrading from MSDE to SQL Express, you can find it here. I have confidence that our upgrade procedure will not harm or lose our data since your database files are just left in place and then attached once the new server is installed, but I would be remise to not remind you that you should take responsibility for protecting your own important data.

I'd say that it's critical to backup your databases as a first step of any migration process. Additionally, you may want to consider doing a side by side upgrade in stead of in place to give you maximum control. During a side by side upgrade, you manually move your databases, so you can choose to use a copy (leaving the original safe) or even migrate your data by restoring a backup rather than using the original mdf. One thing to remember, once the database is converted to SQL 2005, it can't go back to 2000 format. If you are concerned that you might want to roll back the migration, you need to ensure that you keep a copy of the 2000 format database around until migration is complete.

Mike

Monday, March 12, 2012

MSDE & SQL 2000 same server

Hi Andrea,
I was just wondering.. does the 16 instance number apply to total of msde and sql server on a machine or does it mean 16 each.
Thanks
same old newbie
Total.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"new bie" <anonymous@.discussions.microsoft.com> wrote in message
news:8E4A2EF4-1D3F-44A5-9350-AA8238BC73E2@.microsoft.com...
> Hi Andrea,
> I was just wondering.. does the 16 instance number apply to total of msde and sql server on a machine or
does it mean 16 each.
> Thanks
> same old newbie
|||Thanks Tibor

Friday, March 9, 2012

MSDE

Wednesday, March 7, 2012

MSDE

We are running MSDE on Windows 2000 Server. The version number SQL2000,
8.00.760, 5.2 (Build 3790:SP1). So, I am running SP3. Is it necessary to
apply SP3a? If it is, is the "SP3a" file the same running on both SQL 2000
and MSDE? Thanks.It says here its not necessary unless you want the new "disable network
protocols" option.
http://www.microsoft.com/downloads/details.aspx?familyid=90dcd52c-0488-4e46-afbf-acace5369fa3&displaylang=en
Also note SP4 is available.
http://www.microsoft.com/downloads/details.aspx?familyid=8E2DFC8D-C20E-4446-99A9-B7F0213F8BC5&displaylang=en
Regards,
Dave Patrick ...Please no email replies - reply in newsgroup.
Microsoft Certified Professional
Microsoft MVP [Windows]
http://www.microsoft.com/protect
"Diane Walker" wrote:
| We are running MSDE on Windows 2000 Server. The version number SQL2000,
| 8.00.760, 5.2 (Build 3790:SP1). So, I am running SP3. Is it necessary
to
| apply SP3a? If it is, is the "SP3a" file the same running on both SQL
2000
| and MSDE? Thanks.
|
||||Thank you very much, Dave.
"Dave Patrick" <DSPatrick@.nospam.gmail.com> wrote in message
news:OaYOqyQ9GHA.3736@.TK2MSFTNGP02.phx.gbl...
> It says here its not necessary unless you want the new "disable network
> protocols" option.
>
http://www.microsoft.com/downloads/details.aspx?familyid=90dcd52c-0488-4e46-afbf-acace5369fa3&displaylang=en
> Also note SP4 is available.
>
http://www.microsoft.com/downloads/details.aspx?familyid=8E2DFC8D-C20E-4446-99A9-B7F0213F8BC5&displaylang=en
>
> --
> Regards,
> Dave Patrick ...Please no email replies - reply in newsgroup.
> Microsoft Certified Professional
> Microsoft MVP [Windows]
> http://www.microsoft.com/protect
> "Diane Walker" wrote:
> | We are running MSDE on Windows 2000 Server. The version number SQL2000,
> | 8.00.760, 5.2 (Build 3790:SP1). So, I am running SP3. Is it
necessary
> to
> | apply SP3a? If it is, is the "SP3a" file the same running on both SQL
> 2000
> | and MSDE? Thanks.
> |
> |
>|||You're welcome.
--
Regards,
Dave Patrick ...Please no email replies - reply in newsgroup.
Microsoft Certified Professional
Microsoft MVP [Windows]
http://www.microsoft.com/protect
"Diane Walker" wrote:
| Thank you very much, Dave.|||Dave,
Do I need to apply SP3a first before applying SP4 or I can apply SP4 without
applying SP3a first? Thanks.
"Dave Patrick" <DSPatrick@.nospam.gmail.com> wrote in message
news:OaYOqyQ9GHA.3736@.TK2MSFTNGP02.phx.gbl...
> It says here its not necessary unless you want the new "disable network
> protocols" option.
>
http://www.microsoft.com/downloads/details.aspx?familyid=90dcd52c-0488-4e46-afbf-acace5369fa3&displaylang=en
> Also note SP4 is available.
>
http://www.microsoft.com/downloads/details.aspx?familyid=8E2DFC8D-C20E-4446-99A9-B7F0213F8BC5&displaylang=en
>
> --
> Regards,
> Dave Patrick ...Please no email replies - reply in newsgroup.
> Microsoft Certified Professional
> Microsoft MVP [Windows]
> http://www.microsoft.com/protect
> "Diane Walker" wrote:
> | We are running MSDE on Windows 2000 Server. The version number SQL2000,
> | 8.00.760, 5.2 (Build 3790:SP1). So, I am running SP3. Is it
necessary
> to
> | apply SP3a? If it is, is the "SP3a" file the same running on both SQL
> 2000
> | and MSDE? Thanks.
> |
> |
>|||No, service packs are cumulative. Each new service pack contains all the
fixes that are in earlier service packs, together with any new fixes. You do
not have to install an earlier service pack before you install the latest
one.
--
Regards,
Dave Patrick ...Please no email replies - reply in newsgroup.
Microsoft Certified Professional
Microsoft MVP [Windows]
http://www.microsoft.com/protect
"Diane Walker" wrote:
| Dave,
|
| Do I need to apply SP3a first before applying SP4 or I can apply SP4
without
| applying SP3a first? Thanks.|||Thank you very much again, Dave.
"Dave Patrick" <DSPatrick@.nospam.gmail.com> wrote in message
news:uAgDh$V9GHA.3352@.TK2MSFTNGP03.phx.gbl...
> No, service packs are cumulative. Each new service pack contains all the
> fixes that are in earlier service packs, together with any new fixes. You
do
> not have to install an earlier service pack before you install the latest
> one.
> --
> Regards,
> Dave Patrick ...Please no email replies - reply in newsgroup.
> Microsoft Certified Professional
> Microsoft MVP [Windows]
> http://www.microsoft.com/protect
> "Diane Walker" wrote:
> | Dave,
> |
> | Do I need to apply SP3a first before applying SP4 or I can apply SP4
> without
> | applying SP3a first? Thanks.
>|||You're welcome.
--
Regards,
Dave Patrick ...Please no email replies - reply in newsgroup.
Microsoft Certified Professional
Microsoft MVP [Windows]
http://www.microsoft.com/protect
"Diane Walker" wrote:
| Thank you very much again, Dave.

Wednesday, March 21, 2012

MSDE 1.0 TO MSDE 2000 Release A

Monday, March 19, 2012

MSDE > SQL Express

Monday, March 12, 2012

MSDE & SQL 2000 same server

Friday, March 9, 2012

MSDE

MSDE

Wednesday, March 7, 2012

MSDE

MSDB database restore

Blog Archive

About Me