Angel50
Mon Jul 21 15:59:07 CDT 2008
Thanks for all your help.
Sorry, I was in class this past week!
We are going to set up a test farm to practice the upgrade.
Not sure which approach we will take yet.
I forgot to mention that we have a "SQL cluster" to upgrade vs a
single instance
On Jul 14, 8:27=A0pm, Mike Walsh <englantilai...@hotmail.com> wrote:
> This
>
>
http://wss.asaris.de/sites/walsh/Lists/WSSv3%20FAQ/DispForm.aspx?ID=3D103=
4
>
> perhaps
>
> ("Databases: How do you move a WSS 3.0 database to a different SQL Server=
?")
>
> Mike Walsh
>
>
>
> Angel50 wrote:
> > Anja - Correct. =A0The upgrade would be done on the current server/
> > cluster with SQL2000.
> > Either in-place or new instance of SQL 2005. =A0Not sure yet which woul=
d
> > be most recommended!
>
> > You said - "> Any kind of SQL upgrade would not affect Sharepoint as
> > far it is able to
> > connect to the databases fine." =A0 Still have to let sharepoint know
> > that there has been a change - right? When/How?
>
> > Mike Walsh - Do you have any links you can recommend?
>
> > --
>
> > On Jul 14, 6:43 am, "Anja" <Anja_Ame...@hotmail.com> wrote:
> >> As far as I understood the question, upgrade will be performed on the =
server
> >> with SQL 2000.
> >> If the SQL 2005 is planned to be installed on a new box, databases wou=
ld
> >> have to be migrated of course.
>
> >>
http://technet.microsoft.com/en-us/library/cc263299.aspx-Migrate databa=
ses
>
> >> Any kind of SQL upgrade would not affect Sharepoint as far it is able =
to
> >> connect to the databases fine.
> >> The simpliest way is to take a backup of the SQL databases and then co=
nnect
> >> them to the new SQL 2005.
> >> All databases should =A0to be detached and =A0moved off current locati=
on prior
> >> to update.
> >> Unfortunately there is no =A0document from microsoft that would descri=
bed such
> >> scenario in detail.
>
> >> Anyway the best solution would be to built a small test enviroment and=
have
> >> it tested before implementing to the production.
>
> >> Regards,
> >> Anja
>
> >>
http://technet.microsoft.com/en-us/library/ms144267.aspxHowto: Upgrade =
to
> >> SQL Server 2005 (Setup)
>
> >>
http://technet.microsoft.com/en-us/bb530421.aspx-Event Review: Upgradin=
g
> >> to SQL Server 2005 (Session ITPROSQL-10)
>
> >>
http://msdn2.microsoft.com/en-us/library/ms144256(SQL.90).aspx-Upgrade
> >> Advisor tool
>
> >> --
> >> Anja"Mike Walsh" <englantilai...@hotmail.com> wrote in message
>
> >>news:uJaCmnZ5IHA.4268@TK2MSFTNGP02.phx.gbl...
>
> >>> As it's specifically an upgrade of the *SharePoint* dbs from SQL Serv=
er 2K
> >>> to 2005 that's being asked about, I have the feeling that these purel=
y SQL
> >>> Server links aren't going to be enough.
> >>> Mike Walsh
> >>> WSS FAQ
http://www.wssfaq.com/http://wss.collutions.com
> >>> no private questions please
> >>> Anja wrote:
> >>>> Hi,
> >>>> look up these links:
> >>>> SQL Server 2005 Upgrade Handbook:
> >>>>
http://www.microsoft.com/technet/prodtechnol/sql/2005/sqlupgrd.mspx
> >>>> Upgrading to SQL Server 2005:
> >>>>
http://technet.microsoft.com/en-us/library/ms144245.aspx
> >>>> Cheers,
> >>>> Anja
> >>>> "Angel50" <cheru...@gmail.com> wrote in message
> >>>>news:1894531d-8fff-4b41-b66c-43f023371eee@34g2000hsh.googlegroups.com=
...
> >>>>> ALL;
> >>>>> We have a sharepoint 2007 SP1 server farm with a sql 2000 server
> >>>>> cluster as its database.
> >>>>> We would like to upgrade the database on this farm from sql 2000 to
> >>>>> sql 2005.
> >>>>> Are there any white papers that address this particular upgrade
> >>>>> or a site with specific information on the upgrade.
> >>>>> All the reference that I have been able to find via google is too
> >>>>> simplified (even on this groups).
> >>>>> Looking for a very detailed document.- Hide quoted text -
> >> - Show quoted text -- Hide quoted text -
>
> - Show quoted text -