 | |
Move SQL2008 Express to another machine
microsoft.public.sqlserver.tools microsoft.public.sqlserver.tools
 |
| | Thread Tools | Display Modes |
#11
 
| |||
| |||
|
Re: Move SQL2008 Express to another machine -
05-01-2009
, 09:19 AM
|
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 in message news:uB9UhilyJHA.3896 (AT) TK2MSFTNGP06 (DOT) 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 (AT) dont (DOT) spam.me.cips.ca> wrote in message news:usEbLUlyJHA.1432 (AT) TK2MSFTNGP02 (DOT) 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 (AT) hotmail (DOT) com> wrote in message news:eQ$qtFlyJHA.3476 (AT) TK2MSFTNGP05 (DOT) 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 |
#12
| |||
| |||
|
|
jpBless (jp3blessNoSpam (AT) hotmail (DOT) 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, 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 |
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.