Move MSDE from one workstation to another one

There is an application using MSDE as the database engine.
Since we have to replace that machine with a new one, we
would like to know what is the best way to migrate the
database ?
Should we
1) Install the application from setup CD
2) Detach the newly created MSDE database
3) Attach the old MSDE MDF database (The one from the
previous workstation) ?
Is it necessary for us to detach the LDF file ? Why ?
"Daniel" <anonymous@.discussions.microsoft.com> schrieb im Newsbeitrag
news:15e501c540b0$50823720$a501280a@.phx.gbl...
> There is an application using MSDE as the database engine.
> Since we have to replace that machine with a new one, we
> would like to know what is the best way to migrate the
> database ?
> Should we
> 1) Install the application from setup CD
Thats always a good point.

> 2) Detach the newly created MSDE database
If you mean detaching the database rom the "old" server you are right.
But you need not to create a new one, because attaching process "creates" a
new one on his own ( but it doesnt create, it attaches the old as the name
you had before)

> 3) Attach the old MSDE MDF database (The one from the
> previous workstation) ?
Yes.

> Is it necessary for us to detach the LDF file ? Why ?
LDF File is necessary, because db concistecy is based on this files.
Perhaps youll have s deeper look in:
http://www.mssqlcity.com/Articles/Ad...h_database.htm
http://support.microsoft.com/default...b;en-us;224071
HTH, Jens Smeyer.
http://www.sqlserver2005.de
|||Thank you for your reply.
The reason why I mention detach the newly created database=20
is I believe that during installation of the application,=20
a brand new MSDE database will be installed automatically=20
and I have to get rid of it BEFORE attaching the MDF & LDF=20
files from the old machine.
Is it necessary for me to worry over the SQL Login /=20
Database user ? I have already found that the password=20
for SA is *blank*.
Thanks
>--Original Message--
>"Daniel" <anonymous@.discussions.microsoft.com> schrieb im=20
Newsbeitrag=20[vbcol=seagreen]
>news:15e501c540b0$50823720$a501280a@.phx.gbl...
engine.
>Thats always a good point.
>
>If you mean detaching the database rom the "old" server=20
you are right.
>But you need not to create a new one, because attaching=20
process "creates" a=20
>new one on his own ( but it doesn=B4t create, it attaches=20
the old as the name=20
>you had before)
>
>Yes.
>
>LDF File is necessary, because db concistecy is based on=20
this files.
>
>Perhaps you=B4ll have s deeper look in:
>
>http://www.mssqlcity.com/Articles/Ad...h_database.htm
>http://support.microsoft.com/default.aspx?scid=3Dkb;en-
us;224071
>
>HTH, Jens S=FC=DFmeyer.
>--
>http://www.sqlserver2005.de
>--
>
>.
>
|||Look here: http://support.microsoft.com/kb/246133/
Existing Users doesnt exists on the server basis anymore, there is a
article to
transfer these logins and not to recreate these users, as long as you have
hundreds of users (which indeed, i guess you dont have in this case)
"I have already found that the password
for SA is *blank*."
-Complicate Password --> Good !
-Blank Password --> Bad ! (Security Leak)
But beware of changing the Password without considering your software vendor
(if youhave one) because it could be, that he relies on that one hardcoded
(Yeah there are some if those around who do this URGH)
HTH, Jens Smeyer.
http://www.sqlserver2005.de
"Daniel" <anonymous@.discussions.microsoft.com> schrieb im Newsbeitrag
news:0a1d01c540b6$35194040$a401280a@.phx.gbl...
Thank you for your reply.
The reason why I mention detach the newly created database
is I believe that during installation of the application,
a brand new MSDE database will be installed automatically
and I have to get rid of it BEFORE attaching the MDF & LDF
files from the old machine.
Is it necessary for me to worry over the SQL Login /
Database user ? I have already found that the password
for SA is *blank*.
Thanks
>--Original Message--
>"Daniel" <anonymous@.discussions.microsoft.com> schrieb im
Newsbeitrag[vbcol=seagreen]
>news:15e501c540b0$50823720$a501280a@.phx.gbl...
engine.
>Thats always a good point.
>
>If you mean detaching the database rom the "old" server
you are right.
>But you need not to create a new one, because attaching
process "creates" a
>new one on his own ( but it doesnt create, it attaches
the old as the name
>you had before)
>
>Yes.
>
>LDF File is necessary, because db concistecy is based on
this files.
>
>Perhaps youll have s deeper look in:
>
>http://www.mssqlcity.com/Articles/Ad...h_database.htm
>http://support.microsoft.com/default.aspx?scid=kb;en-
us;224071
>
>HTH, Jens Smeyer.
>--
>http://www.sqlserver2005.de
>--
>
>.
>