Attach Detach or backup and restore should work and make sure you set the db compatability at 2008 level ( Maybe its 100 now, I know that 2005 was 90)
Z Edward Ziots Network Engineer Lifespan Organization MCSE,MCSA,MCP+I, ME, CCA, Security +, Network + ezi...@lifespan.org Phone:401-639-3505 ________________________________ From: Benjamin Zachary - Lists [mailto:li...@levelfive.us] Sent: Friday, February 27, 2009 8:44 PM To: NT System Admin Issues Subject: RE: SQL 2005 to 2008 Upgrade I had to do not an upgrade but move a bunch of databases, I just detached, copied over and attached to the 2008 server without incident. So from a db standpoint probably pretty straight forward. From: Roger Wright [mailto:rwri...@evatone.com] Sent: Friday, February 27, 2009 1:47 PM To: NT System Admin Issues Subject: SQL 2005 to 2008 Upgrade Any caveats regarding an in place upgrade from SQL 2005 to SQL 2008? Roger Wright Network Administrator Evatone, Inc. 727.572.7076 x388 _____ "I had amnesia once - or twice." - S.W. ~ Finally, powerful endpoint security that ISN'T a resource hog! ~ ~ <http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/> ~
<<image001.jpg>>