Is it possible to make a backup from MSDE ? (Y/N)

Hi all;

Is it possible to make a backup from MSDE ?? (Y/N)

The problem: I am going to develop an application for a small company and it don't like to spend more $$ rather than some $$ for the App.

So, I don't know if it is possible to do a backup from MSDE or not?

BTW: How much MS SQL Sever200 will cost per a PC? (any idea even approx.)??

Thanks in advanced!

~~CS4Ever~~there's the T-SQL BACKUP DATABASE statement :

BACKUP DATABASE { database_name | @.database_name_var }
TO < backup_device > [ ,...n ]
[ WITH
 [ BLOCKSIZE = { blocksize | @.blocksize_variable } ]
 [ [ , ] DESCRIPTION = { 'text' | @.text_variable } ]
 [ [ , ] DIFFERENTIAL ]
 [ [ , ] EXPIREDATE = { date | @.date_var }
 | RETAINDAYS = { days | @.days_var } ]
 [ [ , ] PASSWORD = { password | @.password_variable } ]
 [ [ , ] FORMAT | NOFORMAT ]
 [ [ , ] { INIT | NOINIT } ]
 [ [ , ] MEDIADESCRIPTION = { 'text' | @.text_variable } ]
 [ [ , ] MEDIANAME = { media_name | @.media_name_variable } ]
 [ [ , ] MEDIAPASSWORD = { mediapassword | @.mediapassword_variable } ]
 [ [ , ] NAME = { backup_set_name | @.backup_set_name_var } ]
 [ [ , ] { NOSKIP | SKIP } ]
 [ [ , ] { NOREWIND | REWIND } ]
 [ [ , ] { NOUNLOAD | UNLOAD } ]
 [ [ , ] RESTART ]
 [ [ , ] STATS [ = percentage ] ]
]

> How much MS SQL Sever200 will cost per a PC?

Given that it's 1800 years out of date, probably pretty cheap ;-)

(joke!) - have a lookhere|||And once backed up is it possible to restore the database?

is it possible to install MSDE after SQL2000?

i installed MSDE _AFTER_ i installed sql2000. i finally got the install to work by specifying the instance name, but i can't connect to my msde instance via enterprise manager. i tried \mycomputer\vsdotnet (the instance name) but it says it's not there. any ideas?nevermind, the instance was netsdk, not vsdotnet.

is it possible to install msde 2000 in win98

I am developing a project in Vb.net
using MSDE 2000 as backend.
I want to deployment my project in win98 OS PCs.
is it possible to install msde 2000 in win98
bye
S.MuhilanOriginally posted by S_Muhilan
I am developing a project in Vb.net
using MSDE 2000 as backend.
I want to deployment my project in win98 OS PCs.
is it possible to install msde 2000 in win98

bye
S.Muhilan

Yes You Can! It is possbile!

MSDE 2000 is a royalty-free, redistributable database engine that is fully compatible with SQL Server. MSDE 2000 is designed to run on Microsoft Windows 98, Windows Millennium Edition (Windows Me), Microsoft Windows NT Workstation version 4.0 (with Service Pack 5 or later), and Windows 2000 Professional as an embedded database for custom applications that require a local database engine.|||Be aware restrictions like database max size is 2GB only and restricted usage of memory and not all the features are available like SQL Server.

http://www.microsoft.com/sql/techinfo/development/2000/MSDEintegration.asp for further information.

Is it possible to get MSDE & SQL Server 2005 Express run on the same machine?

Hi guys,

I'm just wondering if the MSDE & SQL Server 2005 Express can run on the same machine(winxp) without conflicts. Because I need both the reporting services & the publication functionality of replication.

Thanks in advance.

Hi,

yes running both instances on the same system is possible.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de

|||

Hi,

Yes as said you can run both on same machine without any problem, my machine have both installed on it.

Hemantgiri S. Goswami

|||Thanks guys. I appreciate ur time. :)

Is it MSDE or SQLServer

Hi All
How can i see if the database running is a SQL server or a MSDE?
regards,
Erik Visser
SELECT @.@.VERSION
It will return something like:
MSDE:
Microsoft SQL Server 2000 - 8.00.194 (Intel X86) Aug 6 2000 00:57:48
Copyright (c) 1988-2000 Microsoft Corporation Desktop Engine on Windows NT
5.0 (Build 2195: Service Pack 4)
SQL SERVER:
Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22:05
Copyright (c) 1988-2003 Microsoft Corporation Standard Edition on Windows
NT 5.0 (Build 2195: Service Pack 4)
Cheers,
James Goodman
"Erik Visser" <evisser@.hotmail.com> wrote in message
news:c6t01m$fnglv$1@.ID-206424.news.uni-berlin.de...
> Hi All
> How can i see if the database running is a SQL server or a MSDE?
> regards,
> Erik Visser
>
|||> SELECT @.@.VERSION
Yep, this works.
Thanks!
Erik
|||In addition to what James wrote, the SERVERPROPERTY(Edition) function would
probably give you a more direct (and system readable) option.
HTH,
Greg Low (MVP)
MSDE Manager SQL Tools
www.whitebearconsulting.com
"Erik Visser" <evisser@.hotmail.com> wrote in message
news:c6t7ka$fvc1o$1@.ID-206424.news.uni-berlin.de...
> Yep, this works.
> Thanks!
> Erik
>
|||On a similar topic, is there a reliable way to tell if the "full" SQL Server
is simply installed (not MSDE), perhaps through registry entries? I'd like
to determine in my installer whether or not the user has the full SQL Server
installed already and if they do, use that instead of installing MSDE.
"Greg Low (MVP)" <greglow@.lowell.com.au> wrote in message
news:ugq1obqLEHA.2660@.TK2MSFTNGP09.phx.gbl...
> In addition to what James wrote, the SERVERPROPERTY(Edition) function
would
> probably give you a more direct (and system readable) option.
> HTH,
> --
> Greg Low (MVP)
> MSDE Manager SQL Tools
> www.whitebearconsulting.com
>
> "Erik Visser" <evisser@.hotmail.com> wrote in message
> news:c6t7ka$fvc1o$1@.ID-206424.news.uni-berlin.de...
>
|||I installed MSDE 2000A in a computer but that's not what I get when I do
that:
here is what I get:
Microsoft SQL Server 2000 - 8.00.760 (Intel X86)
(1 row(s) affected)
"James" <jamesATnorton-associates.co.ukREMOVE> wrote in message
news:ukw1ngpLEHA.268@.TK2MSFTNGP11.phx.gbl...
> SELECT @.@.VERSION
> It will return something like:
> MSDE:
> Microsoft SQL Server 2000 - 8.00.194 (Intel X86) Aug 6 2000 00:57:48
> Copyright (c) 1988-2000 Microsoft Corporation Desktop Engine on Windows
NT
> 5.0 (Build 2195: Service Pack 4)
>
> SQL SERVER:
> Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22:05
> Copyright (c) 1988-2003 Microsoft Corporation Standard Edition on Windows
> NT 5.0 (Build 2195: Service Pack 4)
>
> --
> Cheers,
> James Goodman
> "Erik Visser" <evisser@.hotmail.com> wrote in message
> news:c6t01m$fnglv$1@.ID-206424.news.uni-berlin.de...
>
|||Hi JJ,
You'll find pretty much everything you need with the SERVERPROPERTY
function. With it's different parameters, it can tell you everything from
service pack levels to collations to clustering details to licensing styles,
etc.
HTH,
Greg Low (MVP)
MSDE Manager SQL Tools
www.whitebearconsulting.com
"JJ" <jjjj@.nospam.com> wrote in message
news:OCf8aOrLEHA.340@.TK2MSFTNGP11.phx.gbl...
> On a similar topic, is there a reliable way to tell if the "full" SQL
Server
> is simply installed (not MSDE), perhaps through registry entries? I'd
like
> to determine in my installer whether or not the user has the full SQL
Server
> installed already and if they do, use that instead of installing MSDE.
>
> "Greg Low (MVP)" <greglow@.lowell.com.au> wrote in message
> news:ugq1obqLEHA.2660@.TK2MSFTNGP09.phx.gbl...
> would
>
|||Execute into text and copy the whole result here.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Francisco" <nomail@.baseball.net> wrote in message news:ubxIggrLEHA.2244@.tk2msftngp13.phx.gbl...
> I installed MSDE 2000A in a computer but that's not what I get when I do
> that:
> here is what I get:
>
> ----
> Microsoft SQL Server 2000 - 8.00.760 (Intel X86)
> (1 row(s) affected)
>
>
> "James" <jamesATnorton-associates.co.ukREMOVE> wrote in message
> news:ukw1ngpLEHA.268@.TK2MSFTNGP11.phx.gbl...
> NT
>
|||Here's the registry root for SQL Server for a default instance (and earlier versions)
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer
And below is for the named instances:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server
Above should give you a starting point.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"JJ" <jjjj@.nospam.com> wrote in message news:OCf8aOrLEHA.340@.TK2MSFTNGP11.phx.gbl...
> On a similar topic, is there a reliable way to tell if the "full" SQL Server
> is simply installed (not MSDE), perhaps through registry entries? I'd like
> to determine in my installer whether or not the user has the full SQL Server
> installed already and if they do, use that instead of installing MSDE.
>
> "Greg Low (MVP)" <greglow@.lowell.com.au> wrote in message
> news:ugq1obqLEHA.2660@.TK2MSFTNGP09.phx.gbl...
> would
>
|||Using Query Analyzer? And results in text? Or something else?
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"Francisco" <nomail@.baseball.net> wrote in message
news:ubxIggrLEHA.2244@.tk2msftngp13.phx.gbl...
>I installed MSDE 2000A in a computer but that's not what I get when I do
> that:
> here is what I get:
>
> ----
> Microsoft SQL Server 2000 - 8.00.760 (Intel X86)
> (1 row(s) affected)
>
>
> "James" <jamesATnorton-associates.co.ukREMOVE> wrote in message
> news:ukw1ngpLEHA.268@.TK2MSFTNGP11.phx.gbl...
> NT
>

Is it easy to upgrade from MSDE to Full blown SQL v2000

Hi,

Noob here....

Got server running app approaching 2gig limit using MSDE version of SQL. I've purchased the full version and just checking if there is anymore to it than inserting the CD and letting it find the MSDE version and upgrade it.

Also, don't remember getting a keycode with the CD - is this right?

Thanks for help :)

Kenny

(bump)

anyone?

|||

I have gone from 2000 msde to 2000 developers edition and never had a problem.

Do a backup of your databases and give it a try.

|||

I wish I had the same easy experience. So far my upgrade from MSDE 2k to full SQL never gives me the "Upgrade" option. I have to install a new instance.

This is in the course of migrating a SharePoint Services installation from the default MSDE database to SQL.

As this test server had SharePoint portal uninstalled and SQL 2k developer uninstalled, then SharePoint Services by themselves re installed, I wonder if the install wizard just somehow does not see the MSDE instance.

My co workers think I am making this up.. Any ideas as to why no upgrade?

Is it easy to upgrade from MSDE to Full blown SQL v2000

Hi,

Noob here....

Got server running app approaching 2gig limit using MSDE version of SQL. I've purchased the full version and just checking if there is anymore to it than inserting the CD and letting it find the MSDE version and upgrade it.

Also, don't remember getting a keycode with the CD - is this right?

Thanks for help :)

Kenny

(bump)

anyone?

|||

I have gone from 2000 msde to 2000 developers edition and never had a problem.

Do a backup of your databases and give it a try.

|||

I wish I had the same easy experience. So far my upgrade from MSDE 2k to full SQL never gives me the "Upgrade" option. I have to install a new instance.

This is in the course of migrating a SharePoint Services installation from the default MSDE database to SQL.

As this test server had SharePoint portal uninstalled and SQL 2k developer uninstalled, then SharePoint Services by themselves re installed, I wonder if the install wizard just somehow does not see the MSDE instance.

My co workers think I am making this up.. Any ideas as to why no upgrade?

Is it easy to upgrade from MSDE to Full blown SQL v2000

Hi,

Noob here....

Got server running app approaching 2gig limit using MSDE version of SQL. I've purchased the full version and just checking if there is anymore to it than inserting the CD and letting it find the MSDE version and upgrade it.

Also, don't remember getting a keycode with the CD - is this right?

Thanks for help :)

Kenny

(bump)

anyone?

|||

I have gone from 2000 msde to 2000 developers edition and never had a problem.

Do a backup of your databases and give it a try.

|||

I wish I had the same easy experience. So far my upgrade from MSDE 2k to full SQL never gives me the "Upgrade" option. I have to install a new instance.

This is in the course of migrating a SharePoint Services installation from the default MSDE database to SQL.

As this test server had SharePoint portal uninstalled and SQL 2k developer uninstalled, then SharePoint Services by themselves re installed, I wonder if the install wizard just somehow does not see the MSDE instance.

My co workers think I am making this up.. Any ideas as to why no upgrade?

Is bug 351711 fixed in MSDE 2000 SP1 or later?

I'm reading this article http://support.microsoft.com/?id=285100. I wonder
whether it is fixed or not in MSDE 2000 installation. If yes, fixed in which
SP?
The hot fix is released JAN-22-2001 and the article is Last Review : October
7, 2005. The article does not mention anything about whether the hot fix is
included in SP and it does not mention which SP does this bug applies to. By
reading the article, I will assume this only applies to MSDE 2000 without SP
and fixed in SP1. But can I assume that?Just download the latest MSDE version (Microsoft SQL Server 2000 Service Pack
4
http://www.microsoft.com/downloads/details.aspx?familyid=8E2DFC8D-C20E-4446-99A9-B7F0213F8BC5&displaylang=en
or directly from
http://www.microsoft.com/downloads/info.aspx?na=46&p=6&SrcDisplayLang=en&SrcCategoryId=&SrcFamilyId=8E2DFC8D-C20E-4446-99A9-B7F0213F8BC5&u=http%3a%2f%2fdownload.microsoft.com%2fdownload%2f1%2fb%2fd%2f1bdf5b78-584e-4de0-b36f-c44e06b0d2a3%2fSQL2000.MSDE-KB884525-SP4-x86-ENU.EXE&oRef=http%3a%2f%2fwww.microsoft.com%2fdownloads%2fdetails.aspx%3fFamilyId%3d413744D1-A0BC-479F-BAFA-E4B278EB9147%26displaylang%3den
"Peter" wrote:
> I'm reading this article http://support.microsoft.com/?id=285100. I wonder
> whether it is fixed or not in MSDE 2000 installation. If yes, fixed in which
> SP?
> The hot fix is released JAN-22-2001 and the article is Last Review : October
> 7, 2005. The article does not mention anything about whether the hot fix is
> included in SP and it does not mention which SP does this bug applies to. By
> reading the article, I will assume this only applies to MSDE 2000 without SP
> and fixed in SP1. But can I assume that?

Is bug 351711 fixed in MSDE 2000 SP1 or later?

I'm reading this article http://support.microsoft.com/?id=285100. I wonder
whether it is fixed or not in MSDE 2000 installation. If yes, fixed in whic
h
SP?
The hot fix is released JAN-22-2001 and the article is Last Review : October
7, 2005. The article does not mention anything about whether the hot fix i
s
included in SP and it does not mention which SP does this bug applies to. By
reading the article, I will assume this only applies to MSDE 2000 without SP
and fixed in SP1. But can I assume that?Just download the latest MSDE version (Microsoft SQL Server 2000 Service Pac
k
4)
http://www.microsoft.com/downloads/...&displaylang=en
or directly from:
http://www.microsoft.com/downloads/...r />
.MSDE-KB8
84525-SP4-x86-ENU.EXE&oRef=http%3a%2f%2fwww.microsoft.com%2fdownloads%2fdeta
ils.aspx%3fFamilyId%3d413744D1-A0BC-479F-BAFA-E4B278EB9147%26displaylang%3de
n
"Peter" wrote:

> I'm reading this article http://support.microsoft.com/?id=285100. I wonde
r
> whether it is fixed or not in MSDE 2000 installation. If yes, fixed in wh
ich
> SP?
> The hot fix is released JAN-22-2001 and the article is Last Review : Octob
er
> 7, 2005. The article does not mention anything about whether the hot fix
is
> included in SP and it does not mention which SP does this bug applies to.
By
> reading the article, I will assume this only applies to MSDE 2000 without
SP
> and fixed in SP1. But can I assume that?