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 |
|
Allen
Starting Member
20 Posts |
 Posted - 2011-04-04 : 22:17:09
|
| This is probably the wrong forum for this but:My current e-commerce site is hosted at a provider that only has 2005 and that's what my e-commerce site is in. I want to move to a site that has 2008.Can I do a backup of 2005 and then restore it into a 2008 db? |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2011-04-04 : 22:18:34
|
| yes |
 |
|
|
Allen
Starting Member
20 Posts |
Posted - 2011-04-04 : 22:31:33
|
| I was told by a provider that I was supposed to use the detach/attach method whenconverting the 2005 database to the 2008 version, because it uses a different fileformat.Any truth to this ? |
|
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2011-04-05 : 01:49:13
|
| No.Detach/attach, backup/restore both work. the file format is not radically different, SQL 2008 knows how to read the 2005 (and 2000) files and how to convert them. the converse is not true--Gail ShawSQL Server MVP |
|
|
|
Allen
Starting Member
20 Posts |
Posted - 2011-04-05 : 11:01:59
|
| thanks"Life is hard, but it's harder when you're stupid"!John 'Duke' Wayne |
|
|
|
|
|
|
upgrading from 2005 to 2008