Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
dana123
Starting Member
3 Posts |
 Posted - 2009-07-31 : 15:42:15
|
| We are upgrading to a new server which will be a 2008 standard 32Bit server with SQL 2008 express. How do I move all my databases from the old server which was a 2003 Standard edition 32-bit with SQL 2005 Express? We run backups nightly on the SQL 2005 and have the .mdf files created by the backup. Dana |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2009-07-31 : 21:21:40
|
| you can restore the backups to SQL 2008. Why would you get a new server 32 bit? Might as well go 64x |
 |
|
|
dana123
Starting Member
3 Posts |
Posted - 2009-08-01 : 00:25:18
|
| - Unfortunately, I didn't have a say in the decision making process, so, I am going to have to use 32-bit version. How do I restore to SQL 2008? Do I use the Copy backups wizard in SQL 2008 express? |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2009-08-01 : 00:59:46
|
| http://www.sqlteam.com/article/backup-and-restore-in-sql-server-full-backups |
|
|
|
shah429
Yak Posting Veteran
52 Posts |
Posted - 2009-08-01 : 05:20:24
|
| The copy database wizard uses SSIS to accomplish it's task and express doesn't come with SSIS. So your options are to use attach/detach or backup/restore. Hope that helps. |
|
|
|
|
|
|
New Server will have SQL 2008