"Tom Moreau" <tom@dont.spam.me.cips.ca> wrote in message
news:usEbLUlyJHA.1432@TK2MSFTNGP02.phx.gbl...
> Once you sort out your install issues, you can do a backup and restore.
> Be
> sure to check out sp_change_users_login in the BOL.
>
> --
>   Tom
>
> ----------------------------------------------------
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
> SQL Server MVP
> Toronto, ON   Canada
> https://mvp.support.microsoft.com/profile/Tom.Moreau
>
>
> "jpBless" <jp3blessNoSpam@hotmail.com> wrote in message
> news:eQ$qtFlyJHA.3476@TK2MSFTNGP05.phx.gbl...
> I need to move SQL 2008 Express from XP to Vista Machine. Currently both
> machines are same LAN. My previous attempts at "backup and restore"
> database
> failed... so I am wondering if anyone would be kind enough to help....
>
> I am not that experienced with SQL servers. I figure I have to install SQL
> server express in the new Vista machine... which so far is giving me a
> headache. I get the error "You need to download and install dotnet
> framework
> 3.0 or above. I installed 3.5 ( I think) and still get the same error. Are
> there known installation issues when installing SQL Express 2008 on a
> Vista
> machine?
>
> Assuming the installation on Vista goes through... how do I move an
> existing
> databse (table structure and data to the new installation) as I plan to
> get
> rid of the XP machine?
>
> Please help. Thanks in advance
>
>

"Tom Moreau" <tom@dont.spam.me.cips.ca> wrote in message
news:usEbLUlyJHA.1432@TK2MSFTNGP02.phx.gbl...
> Once you sort out your install issues, you can do a backup and restore.
> Be
> sure to check out sp_change_users_login in the BOL.
>
> --
>   Tom
>
> ----------------------------------------------------
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
> SQL Server MVP
> Toronto, ON   Canada
> https://mvp.support.microsoft.com/profile/Tom.Moreau
>
>
> "jpBless" <jp3blessNoSpam@hotmail.com> wrote in message
> news:eQ$qtFlyJHA.3476@TK2MSFTNGP05.phx.gbl...
> I need to move SQL 2008 Express from XP to Vista Machine. Currently both
> machines are same LAN. My previous attempts at "backup and restore"
> database
> failed... so I am wondering if anyone would be kind enough to help....
>
> I am not that experienced with SQL servers. I figure I have to install SQL
> server express in the new Vista machine... which so far is giving me a
> headache. I get the error "You need to download and install dotnet
> framework
> 3.0 or above. I installed 3.5 ( I think) and still get the same error. Are
> there known installation issues when installing SQL Express 2008 on a
> Vista
> machine?
>
> Assuming the installation on Vista goes through... how do I move an
> existing
> databse (table structure and data to the new installation) as I plan to
> get
> rid of the XP machine?
>
> Please help. Thanks in advance
>
>

"Tom Moreau" <tom@dont.spam.me.cips.ca> wrote in message
news:uL4P4qlyJHA.1416@TK2MSFTNGP04.phx.gbl...
> sp_change_users_login  is a system stored procedure that re-aligns users
> and
> logins.  BOL is the Books Online - the online documentation.  We're going
> to
> need very specific error messages in order to help you out.
>
> --
>   Tom
>
> ----------------------------------------------------
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
> SQL Server MVP
> Toronto, ON   Canada
> https://mvp.support.microsoft.com/profile/Tom.Moreau
>
>
> "jpBless" <jp3blessNoSpam@hotmail.com> wrote in message
> news:uB9UhilyJHA.3896@TK2MSFTNGP06.phx.gbl...
> Thanks Tom... what is sp_change_users_login in the BOL?
>
> Probably that's why my previous attempts at backup and restore failed in
> the past
>
>
> "Tom Moreau" <tom@dont.spam.me.cips.ca> wrote in message
> news:usEbLUlyJHA.1432@TK2MSFTNGP02.phx.gbl...
>> Once you sort out your install issues, you can do a backup and restore.
>> Be
>> sure to check out sp_change_users_login in the BOL.
>>
>> --
>>   Tom
>>
>> ----------------------------------------------------
>> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
>> SQL Server MVP
>> Toronto, ON   Canada
>> https://mvp.support.microsoft.com/profile/Tom.Moreau
>>
>>
>> "jpBless" <jp3blessNoSpam@hotmail.com> wrote in message
>> news:eQ$qtFlyJHA.3476@TK2MSFTNGP05.phx.gbl...
>> I need to move SQL 2008 Express from XP to Vista Machine. Currently both
>> machines are same LAN. My previous attempts at "backup and restore"
>> database
>> failed... so I am wondering if anyone would be kind enough to help....
>>
>> I am not that experienced with SQL servers. I figure I have to install
>> SQL
>> server express in the new Vista machine... which so far is giving me a
>> headache. I get the error "You need to download and install dotnet
>> framework
>> 3.0 or above. I installed 3.5 ( I think) and still get the same error.
>> Are
>> there known installation issues when installing SQL Express 2008 on a
>> Vista
>> machine?
>>
>> Assuming the installation on Vista goes through... how do I move an
>> existing
>> databse (table structure and data to the new installation) as I plan to
>> get
>> rid of the XP machine?
>>
>> Please help. Thanks in advance
>>
>>
>
>

"Tom Moreau" <tom@dont.spam.me.cips.ca> wrote in message
news:uL4P4qlyJHA.1416@TK2MSFTNGP04.phx.gbl...
> sp_change_users_login  is a system stored procedure that re-aligns users
> and
> logins.  BOL is the Books Online - the online documentation.  We're going
> to
> need very specific error messages in order to help you out.
>
> --
>   Tom
>
> ----------------------------------------------------
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
> SQL Server MVP
> Toronto, ON   Canada
> https://mvp.support.microsoft.com/profile/Tom.Moreau
>
>
> "jpBless" <jp3blessNoSpam@hotmail.com> wrote in message
> news:uB9UhilyJHA.3896@TK2MSFTNGP06.phx.gbl...
> Thanks Tom... what is sp_change_users_login in the BOL?
>
> Probably that's why my previous attempts at backup and restore failed in
> the past
>
>
> "Tom Moreau" <tom@dont.spam.me.cips.ca> wrote in message
> news:usEbLUlyJHA.1432@TK2MSFTNGP02.phx.gbl...
>> Once you sort out your install issues, you can do a backup and restore.
>> Be
>> sure to check out sp_change_users_login in the BOL.
>>
>> --
>>   Tom
>>
>> ----------------------------------------------------
>> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
>> SQL Server MVP
>> Toronto, ON   Canada
>> https://mvp.support.microsoft.com/profile/Tom.Moreau
>>
>>
>> "jpBless" <jp3blessNoSpam@hotmail.com> wrote in message
>> news:eQ$qtFlyJHA.3476@TK2MSFTNGP05.phx.gbl...
>> I need to move SQL 2008 Express from XP to Vista Machine. Currently both
>> machines are same LAN. My previous attempts at "backup and restore"
>> database
>> failed... so I am wondering if anyone would be kind enough to help....
>>
>> I am not that experienced with SQL servers. I figure I have to install
>> SQL
>> server express in the new Vista machine... which so far is giving me a
>> headache. I get the error "You need to download and install dotnet
>> framework
>> 3.0 or above. I installed 3.5 ( I think) and still get the same error.
>> Are
>> there known installation issues when installing SQL Express 2008 on a
>> Vista
>> machine?
>>
>> Assuming the installation on Vista goes through... how do I move an
>> existing
>> databse (table structure and data to the new installation) as I plan to
>> get
>> rid of the XP machine?
>>
>> Please help. Thanks in advance
>>
>>
>
>

"Tom Moreau" <tom@dont.spam.me.cips.ca> wrote in message
news:uL4P4qlyJHA.1416@TK2MSFTNGP04.phx.gbl...
> sp_change_users_login  is a system stored procedure that re-aligns users
> and
> logins.  BOL is the Books Online - the online documentation.  We're going
> to
> need very specific error messages in order to help you out.
>
> --
>   Tom
>
> ----------------------------------------------------
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
> SQL Server MVP
> Toronto, ON   Canada
> https://mvp.support.microsoft.com/profile/Tom.Moreau
>
>
> "jpBless" <jp3blessNoSpam@hotmail.com> wrote in message
> news:uB9UhilyJHA.3896@TK2MSFTNGP06.phx.gbl...
> Thanks Tom... what is sp_change_users_login in the BOL?
>
> Probably that's why my previous attempts at backup and restore failed in
> the past
>
>
> "Tom Moreau" <tom@dont.spam.me.cips.ca> wrote in message
> news:usEbLUlyJHA.1432@TK2MSFTNGP02.phx.gbl...
>> Once you sort out your install issues, you can do a backup and restore.
>> Be
>> sure to check out sp_change_users_login in the BOL.
>>
>> --
>>   Tom
>>
>> ----------------------------------------------------
>> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
>> SQL Server MVP
>> Toronto, ON   Canada
>> https://mvp.support.microsoft.com/profile/Tom.Moreau
>>
>>
>> "jpBless" <jp3blessNoSpam@hotmail.com> wrote in message
>> news:eQ$qtFlyJHA.3476@TK2MSFTNGP05.phx.gbl...
>> I need to move SQL 2008 Express from XP to Vista Machine. Currently both
>> machines are same LAN. My previous attempts at "backup and restore"
>> database
>> failed... so I am wondering if anyone would be kind enough to help....
>>
>> I am not that experienced with SQL servers. I figure I have to install
>> SQL
>> server express in the new Vista machine... which so far is giving me a
>> headache. I get the error "You need to download and install dotnet
>> framework
>> 3.0 or above. I installed 3.5 ( I think) and still get the same error.
>> Are
>> there known installation issues when installing SQL Express 2008 on a
>> Vista
>> machine?
>>
>> Assuming the installation on Vista goes through... how do I move an
>> existing
>> databse (table structure and data to the new installation) as I plan to
>> get
>> rid of the XP machine?
>>
>> Please help. Thanks in advance
>>
>>
>
>

"jpBless" <jp3blessNoSpam@hotmail.com> wrote:

> I need to move SQL 2008 Express from XP to Vista Machine. Currently both
> machines are same LAN. My previous attempts at "backup and restore" database
> failed... so I am wondering if anyone would be kind enough to help....
>
> I am not that experienced with SQL servers. I figure I have to install SQL
> server express in the new Vista machine... which so far is giving me a
> headache. I get the error "You need to download and install dotnet framework
> 3.0 or above. I installed 3.5 ( I think) and still get the same error. Are
> there known installation issues when installing SQL Express 2008 on a Vista
> machine?
>
> Assuming the installation on Vista goes through... how do I move an existing
> databse (table structure and data to the new installation) as I plan to get
> rid of the XP machine?
>
> Please help. Thanks in advance
>
>

"Aaron Bertrand [SQL Server MVP]" <ten.xoc@dnartreb.noraa> wrote in message
news:C6205E21.17F5C%ten.xoc@dnartreb.noraa...
> We'd need more information on how your backup and restore attempts failed.
>
>
>
>
>
> On 5/1/09 7:38 AM, in article eQ$qtFlyJHA.3***@TK2MSFTNGP05.phx.gbl,
> "jpBless" <jp3blessNoSpam@hotmail.com> wrote:
>
>> I need to move SQL 2008 Express from XP to Vista Machine. Currently both
>> machines are same LAN. My previous attempts at "backup and restore"
>> database
>> failed... so I am wondering if anyone would be kind enough to help....
>>
>> I am not that experienced with SQL servers. I figure I have to install
>> SQL
>> server express in the new Vista machine... which so far is giving me a
>> headache. I get the error "You need to download and install dotnet
>> framework
>> 3.0 or above. I installed 3.5 ( I think) and still get the same error.
>> Are
>> there known installation issues when installing SQL Express 2008 on a
>> Vista
>> machine?
>>
>> Assuming the installation on Vista goes through... how do I move an
>> existing
>> databse (table structure and data to the new installation) as I plan to
>> get
>> rid of the XP machine?
>>
>> Please help. Thanks in advance
>>
>>
>

"jpBless" <jp3blessNoSpam@hotmail.com> wrote in message
news:eL3oOhlyJHA.4136@TK2MSFTNGP05.phx.gbl...
> First of all thanks Tom...
>
> I created SQL server 2008 express database on one XP machine then tried to
> move the database to another XP machine (having completed SQL installation
> on that machine)... I remember asking for help and many good souls here
> including you pointed me to "backup and restore." I backed up the original
> database in a flash drive but then when I tried to restore it to another
> machine hoping to export the "database with data" to a second machine... I
> get the error... something like "The database do not match" not exactly
> but something to that effect.
>
>
>
> "Aaron Bertrand [SQL Server MVP]" <ten.xoc@dnartreb.noraa> wrote in
> message news:C6205E21.17F5C%ten.xoc@dnartreb.noraa...
>> We'd need more information on how your backup and restore attempts
>> failed.
>>
>>
>>
>>
>>
>> On 5/1/09 7:38 AM, in article eQ$qtFlyJHA.3***@TK2MSFTNGP05.phx.gbl,
>> "jpBless" <jp3blessNoSpam@hotmail.com> wrote:
>>
>>> I need to move SQL 2008 Express from XP to Vista Machine. Currently both
>>> machines are same LAN. My previous attempts at "backup and restore"
>>> database
>>> failed... so I am wondering if anyone would be kind enough to help....
>>>
>>> I am not that experienced with SQL servers. I figure I have to install
>>> SQL
>>> server express in the new Vista machine... which so far is giving me a
>>> headache. I get the error "You need to download and install dotnet
>>> framework
>>> 3.0 or above. I installed 3.5 ( I think) and still get the same error.
>>> Are
>>> there known installation issues when installing SQL Express 2008 on a
>>> Vista
>>> machine?
>>>
>>> Assuming the installation on Vista goes through... how do I move an
>>> existing
>>> databse (table structure and data to the new installation) as I plan to
>>> get
>>> rid of the XP machine?
>>>
>>> Please help. Thanks in advance
>>>
>>>
>>
>
>

"Aaron Bertrand [SQL Server MVP]" <ten.xoc@dnartreb.noraa> wrote in message
news:C620665B.17F71%ten.xoc@dnartreb.noraa...
>
>>  I created SQL server 2008 express database on one XP machine then tried
>> to
>>  move the database to another XP machine (having completed SQL
>> installation
>> on that machine)... I remember asking for help and many good souls here
>> including you pointed me to "backup and restore." I backed up the
>> original
>>  database in a flash drive but then when I tried to restore it to another
>>  machine hoping to export the "database with data" to a second machine...
>> I
>> get the error... something like "The database do not match" not exactly
>> but
>> something to that effect.
>
> Unfortunately I can't help you fix "something to that effect"... If you
> try
> it again and list the *exact* error message (as well as which commands you
> ran) then it might be easier for people to help you.  The process is
> fairly
> simple and a lot of people use it successfully, so I am sure the solution
> in
> this case will be simple as well.  But like I said, we don't have enough
> information to fix it for you right now.
>

"Erland Sommarskog" <esq***@sommarskog.se> wrote in message
news:Xns9BFE9A9CA2460Yazorman@127.0.0.1...
> jpBless (jp3blessNoSpam@hotmail.com) writes:
>> I need to move SQL 2008 Express from XP to Vista Machine. Currently both
>> machines are same LAN. My previous attempts at "backup and restore"
>> database failed... so I am wondering if anyone would be kind enough to
>> help....
>
> Let's take this bit first. Backing up the database is simple:
>
>   BACKUP DATABASE db TO DISK = 'filepath' WITH INIT
>
> Before you leave the source machince, run sp_helpdb and make note of
> the logical names of the database files. That's the first column. If
> your database is named foo, the names may be 'foo' and 'foo_log'.
>
> When you arrive at the other machine, the command is:
>
>   RESTORE DATABASE db FROM DISK = 'filepath'
>      WITH MOVE 'foo'     TO 'dbfilepath/db.mdf',
>           MOVE 'foo_log' TO 'dbfilepath/db.ldf,
>      REPLACE
>
> For the dbfilepath you can pick anywhere on the disk, but most likely
> you want to put the databases where the other databases are. Use sp_helpdb
> on an existing db to find out. (This also permits you to cut and paste
> and save you from some typing.)
>
> It seems from the error message you related, that you missed the
> REPLACE clause.
>
> Now over to the installation woes:
>
>> I am not that experienced with SQL servers. I figure I have to install
>> SQL server express in the new Vista machine... which so far is giving me
>> a headache. I get the error "You need to download and install dotnet
>> framework 3.0 or above. I installed 3.5 ( I think) and still get the
>> same error. Are there known installation issues when installing SQL
>> Express 2008 on a Vista machine?
>
> More exactly you need .Net Framework 3.5 SP1. Only 3.5 won't do.
>
>
>
> --
> Erland Sommarskog, SQL Server MVP, esq***@sommarskog.se
>
> Links for SQL Server Books Online:
> SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
> SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
> SQL 2000:
> http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
>