MSDE query

I use a database product that utilises MSDE 2000. The database creates a
second database called " databasename_data_1.mdf" database when installed.
I noticed after detaching and moving the database that this secondary
database had not attached correctly. However when I tried to reattach it
using the
exec sp_attach_db command it stated that the "databasename_data_1" already
existed. However when I tried to reattach it using the sp_detach_db command
the error message stated it not exist?
If any one has any ideas?
Peter
"Peter M" <PeterM@.discussions.microsoft.com> wrote in message
news:C2B01189-C78A-4738-A932-18837A63EC16@.microsoft.com...
> I use a database product that utilises MSDE 2000. The database creates a
> second database called " databasename_data_1.mdf" database when
installed.
> I noticed after detaching and moving the database that this secondary
> database had not attached correctly. However when I tried to reattach it
> using the
> exec sp_attach_db command it stated that the "databasename_data_1" already
> existed. However when I tried to reattach it using the sp_detach_db
command
> the error message stated it not exist?
> If any one has any ideas?
> Peter
What does SELECT * FROM sysdatabases tell you?
Rick Sawtell
MCT, MCSD, MCDBA
|||Rick, I will check when back onsite. Do you know much about this
*_data_1.mdf structure. I was not sure if it made a difference when
detaching and reattaching whether one had to be done before the other.
regards
Peter
"Rick Sawtell" wrote:

> "Peter M" <PeterM@.discussions.microsoft.com> wrote in message
> news:C2B01189-C78A-4738-A932-18837A63EC16@.microsoft.com...
> installed.
> command
>
> What does SELECT * FROM sysdatabases tell you?
>
> Rick Sawtell
> MCT, MCSD, MCDBA
>
>

MSDE query

I use a database product that utilises MSDE 2000. The database creates a
second database called " databasename_data_1.mdf" database when installed.
I noticed after detaching and moving the database that this secondary
database had not attached correctly. However when I tried to reattach it
using the
exec sp_attach_db command it stated that the "databasename_data_1" already
existed. However when I tried to reattach it using the sp_detach_db command
the error message stated it not exist'
If any one has any ideas'
Peter"Peter M" <PeterM@.discussions.microsoft.com> wrote in message
news:C2B01189-C78A-4738-A932-18837A63EC16@.microsoft.com...
> I use a database product that utilises MSDE 2000. The database creates a
> second database called " databasename_data_1.mdf" database when
installed.
> I noticed after detaching and moving the database that this secondary
> database had not attached correctly. However when I tried to reattach it
> using the
> exec sp_attach_db command it stated that the "databasename_data_1" already
> existed. However when I tried to reattach it using the sp_detach_db
command
> the error message stated it not exist'
> If any one has any ideas'
> Peter
What does SELECT * FROM sysdatabases tell you?
Rick Sawtell
MCT, MCSD, MCDBA|||Rick, I will check when back onsite. Do you know much about this
*_data_1.mdf structure. I was not sure if it made a difference when
detaching and reattaching whether one had to be done before the other.
regards
Peter
"Rick Sawtell" wrote:

> "Peter M" <PeterM@.discussions.microsoft.com> wrote in message
> news:C2B01189-C78A-4738-A932-18837A63EC16@.microsoft.com...
> installed.
> command
>
> What does SELECT * FROM sysdatabases tell you?
>
> Rick Sawtell
> MCT, MCSD, MCDBA
>
>

MSDE query

I use a database product that utilises MSDE 2000. The database creates a
second database called " databasename_data_1.mdf" database when installed.
I noticed after detaching and moving the database that this secondary
database had not attached correctly. However when I tried to reattach it
using the
exec sp_attach_db command it stated that the "databasename_data_1" already
existed. However when I tried to reattach it using the sp_detach_db command
the error message stated it not exist'
If any one has any ideas'
Peter"Peter M" <PeterM@.discussions.microsoft.com> wrote in message
news:C2B01189-C78A-4738-A932-18837A63EC16@.microsoft.com...
> I use a database product that utilises MSDE 2000. The database creates a
> second database called " databasename_data_1.mdf" database when
installed.
> I noticed after detaching and moving the database that this secondary
> database had not attached correctly. However when I tried to reattach it
> using the
> exec sp_attach_db command it stated that the "databasename_data_1" already
> existed. However when I tried to reattach it using the sp_detach_db
command
> the error message stated it not exist'
> If any one has any ideas'
> Peter
What does SELECT * FROM sysdatabases tell you?
Rick Sawtell
MCT, MCSD, MCDBA|||Rick, I will check when back onsite. Do you know much about this
*_data_1.mdf structure. I was not sure if it made a difference when
detaching and reattaching whether one had to be done before the other.
regards
Peter
"Rick Sawtell" wrote:
> "Peter M" <PeterM@.discussions.microsoft.com> wrote in message
> news:C2B01189-C78A-4738-A932-18837A63EC16@.microsoft.com...
> > I use a database product that utilises MSDE 2000. The database creates a
> > second database called " databasename_data_1.mdf" database when
> installed.
> > I noticed after detaching and moving the database that this secondary
> > database had not attached correctly. However when I tried to reattach it
> > using the
> > exec sp_attach_db command it stated that the "databasename_data_1" already
> > existed. However when I tried to reattach it using the sp_detach_db
> command
> > the error message stated it not exist'
> > If any one has any ideas'
> > Peter
>
> What does SELECT * FROM sysdatabases tell you?
>
> Rick Sawtell
> MCT, MCSD, MCDBA
>
>

msde installation question.

Hi,
When i install MSDE it creates a folder named "Microsoft SQL
Server\80\..." in Program Files why it create this folder? Is there any way
to bypass this folder installation. thanks a lot
hi,
"Shoaib Khanzada" <shoaibkhanzada@.hotmail.com> ha scritto nel messaggio
news:uxeO8cpEEHA.1368@.TK2MSFTNGP11.phx.gbl...
> Hi,
> When i install MSDE it creates a folder named "Microsoft SQL
> Server\80\..." in Program Files why it create this folder? Is there any
way
> to bypass this folder installation. thanks a lot
even when specifying a different path for DATADIR and TARGETDIR, MSDE
requires to install some stuff in \Program Files\...
those files, bynaries and executables, are service pack indipendent (the
always are updated at the higher service pack level) and are shared among
all instances installed on the targe pc...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.6.0 - DbaMgr ver 0.52.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply

MSDE Installation Fails

These are the last 3 lines the log file creates before
the installation stops. Does anyone know how to complete
the installation?
SOFTWARE\Microsoft\Microsoft SQL Server Setup.{E09B48B5-
E141-427A-AB0C-D3605127224A}
Starting custom action InstallSqlRedis
Executing "C:\Program Files\Microsoft SQL Server\80
\Tools\Binn\sqlredis.exe /q:a"
hi,
"Clete" <anonymous@.discussions.microsoft.com> ha scritto nel messaggio
news:19d401c4ad71$b5f839b0$a301280a@.phx.gbl
> These are the last 3 lines the log file creates before
> the installation stops. Does anyone know how to complete
> the installation?
> SOFTWARE\Microsoft\Microsoft SQL Server Setup.{E09B48B5-
> E141-427A-AB0C-D3605127224A}
> Starting custom action InstallSqlRedis
> Executing "C:\Program Files\Microsoft SQL Server\80
> \Tools\Binn\sqlredis.exe /q:a"
try manually installing MDAC 2.7.1 before MSDE ... get MDAC at
http://msdn.microsoft.com/data/Default.aspx
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply

MSDE IMAGE "CLONED"

Can MSDE be cloned? I would like to creates an install of MSDE in an image I
am working on, and create an image of the load. Does anyone know if this
will cause problems for MSDE?
Thanks in advance.
BobS
hi BobS,
"BobS" <bobs@.computertorture.com> ha scritto nel messaggio
news:eF6wWaquEHA.1616@.TK2MSFTNGP10.phx.gbl
> Can MSDE be cloned? I would like to creates an install of MSDE in an
> image I am working on, and create an image of the load. Does anyone
> know if this will cause problems for MSDE?
> Thanks in advance.
> BobS
AFAIK not... you can ghost a complete pc, but not a single MSDE instance
installation... I actually do not understand how do you prepare the "image"
to be burned and distributed... lot of dlls, both standard Win32 and COM
dlls, have to be written to disk, both in private \Microsoft SQL Server\..
and system ... stuff has to be written to the registry... services have to
be installed and negotiated...
I do have really no clues...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Hi Bob,
Apart from Andrea's comments, if you are just talking about creating an
operating system image that contains the MSDE and wanting to clone it, the
main issue relates to renaming the computer. Once you've done that, you
should read
http://msdn.microsoft.com/library/de...stall_5r8f.asp
about renaming a system running sql server.
HTH,
Greg Low [MVP]
MSDE Manager SQL Tools
www.whitebearconsulting.com
"BobS" <bobs@.computertorture.com> wrote in message
news:eF6wWaquEHA.1616@.TK2MSFTNGP10.phx.gbl...
> Can MSDE be cloned? I would like to creates an install of MSDE in an image
> I
> am working on, and create an image of the load. Does anyone know if this
> will cause problems for MSDE?
> Thanks in advance.
> BobS
>
|||Thanks Greg. I'll have a look at the docs. I'm working on a special project,
and must find a way of to get this done.
"Greg Low [MVP]" <greglow@.lowell.com.au> wrote in message
news:O5CbpytuEHA.1988@.TK2MSFTNGP12.phx.gbl...
> Hi Bob,
> Apart from Andrea's comments, if you are just talking about creating an
> operating system image that contains the MSDE and wanting to clone it, the
> main issue relates to renaming the computer. Once you've done that, you
> should read
>
http://msdn.microsoft.com/library/de...stall_5r8f.asp[vbcol=seagreen]
> about renaming a system running sql server.
> HTH,
> --
> Greg Low [MVP]
> MSDE Manager SQL Tools
> www.whitebearconsulting.com
> "BobS" <bobs@.computertorture.com> wrote in message
> news:eF6wWaquEHA.1616@.TK2MSFTNGP10.phx.gbl...
image
>