MOSS Forum

Ask Question   UnAnswered
Home » Forum » MOSS       RSS Feeds

Moving MOSS to SQL 2005 from 2000

  Asked By: Fallon    Date: Jan 31    Category: MOSS    Views: 662

The subject isn't exactly what I need to know:

I've got an upgraded MOSS install that was updated using the DB
attachment method.

I need to know how I tell MOSS to use the functionality of the SQL 2005
server the DBs now run on.

I've looked at the settings are the DBs are running in SQL 2000
compatibility mode. What happens if I change them SQL 2005 mode? Can
I? Or do I need to do something else?



3 Answers Found

Answer #1    Answered By: Deana Lowery     Answered On: Jan 31

You can change the database compatibility mode to 9 and it shouldn't
cause you any problems. I'm not sure that's going to tell SharePoint it
can use the SQL 2005 features, but it will allow you to use the
reporting features in SQL Management Studio.

Answer #2    Answered By: Felecia Goff     Answered On: Jan 31

MOSS doesn't use any of the new SQL 2005 functionality, but will pick up
its general performance improvement. Is there something specific you
were looking for?

Answer #3    Answered By: David Scott     Answered On: Jan 31

Nope.. just wanted to know if I changed the compatibility modes if it
would cause any issues, or help in performance, etc.

Since I never upgraded the DBs, I was wondering if this would cause

(The upgrade was a DB attachment, so unless MOSS did something... and it
did leave them in mode 80)

Didn't find what you were looking for? Find more on Moving MOSS to SQL 2005 from 2000 Or get search suggestion and latest updates.