Moving from SQL 2005 to SQL 2008

	Forums Register Login My Profile Inbox Address Book My Subscription My Forums Member List Search FAQ Ticket List Log Out

Moving from SQL 2005 to SQL 2008

Logged in as: Guest

Users viewing this topic: none

Printable Version

All Forums >> [Archiving & Fax] >> GFI MailArchiver >> Moving from SQL 2005 to SQL 2008

Page: [1]

Message

<< Older Topic Newer Topic >>

Moving from SQL 2005 to SQL 2008 - 21.Oct.2009 1:48:32 PM

BobW

Posts: 20
Joined: 15.Mar.2004
Status: offline

I need to move my MA6 DBs from W2K3 X86/SQL 2005 to W2K8/SQL 2008.

As the installation directories are different (one being X64) the standard move process will not work.

I have tried backing up and restoring with no luck.
I have tried a flat copy.
Tried a copy via the SQL copy utility

WIth the backup and flat methods, MA6 stated the DB could not be used when I tried to attach it.

There must be some easy way to do this, but I am not adept at SQL, to put it nicely.

Thanks,
Bob

Post #: 1

RE: Moving from SQL 2005 to SQL 2008 - 21.Oct.2009 4:49:24 PM

benvincenti

Posts: 163
Joined: 30.Apr.2008
Status: offline

quote:

copy utility

BobW,

To move your SQL databases to SQL 2008, you need to follow the steps at http://kbase.gfi.com/showarticle.asp?id=KBID002314

Regards,
Ben Vincenti

GFI Software - www.gfi.com
Web & Mail Security, Archiving & Fax, Networking & Security

(in reply to BobW)

Post #: 2