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

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 (AT) dnartreb (DOT) noraa> wrote

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 (AT) dont (DOT) spam.me.cips.ca> wrote

Sorry meant Aaron


First of all thanks Aaron.

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.

"jpBless" <jp3blessNoSpam (AT) hotmail (DOT) com> wrote

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.

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 (AT) hotmail (DOT) com> wrote

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 (AT) dont (DOT) spam.me.cips.ca> wrote

jpBless (jp3blessNoSpam (AT) hotmail (DOT) com) writes:
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:

More exactly you need .Net Framework 3.5 SP1. Only 3.5 won't do.



--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) 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/prodinf...ons/books.mspx

Thanks... I will post the exact message when I get to the location where I
am battling this SQL demon. Again, thanks.


"Aaron Bertrand [SQL Server MVP]" <ten.xoc (AT) dnartreb (DOT) noraa> wrote

Thanks Tom... I will post the message when I encounter it again


"Tom Moreau" <tom (AT) dont (DOT) spam.me.cips.ca> wrote

Tom
I think in SQL Server 2008 we will be better of using
ALTER USER ...WITH LOGIN ='Login' , what do you think?


"Tom Moreau" <tom (AT) dont (DOT) spam.me.cips.ca> wrote