Re: Saving WSS site prior to upgrading SQL Server 2005 Express to Standard/Enterprise

Sorry. As you know I'm a newbie in wss. So I appologize if my question might
seem stupid.
I have a Microsoft SQL Server 2005 Express Edition installed. I also have a
database used by WSS visible under databases in the default instance of SQL
Server Express as:
SERVER\SQLEXPRESS.

Or WSS daes make a use of the embedded version for internal wss stuff?
Please, explain, how do I check this.

I've found this link, so, I thought this might be what I need to do. Of
course after using stsadm tool to create a backup as mentioned in the link
you've provided.

Thanks!




"Mike Walsh" <englantilainen@xxxxxxxxxxx> ha scritto nel messaggio
news:OwXyQjTzIHA.3504@xxxxxxxxxxxxxxxxxxxxxxx
I presume you don't really mean the standard SQL Server 2005 Express
edition but embedded version called the "Windows Internal Database".

If so this is a description of how to move it to SQL Server 2005

http://wss.asaris.de/sites/walsh/Lists/WSSv3%20FAQ/DispForm.aspx?ID=1144

Mike Walsh
WSS FAQ http://www.wssfaq.com / http://www.collutions.com
no private questions please

Zaur Bahramov wrote:
Hi!

I have set up a WSS site using SQL Server 2005 Express edition. Now I
need to make an upgrade to Standard edition of SQL server 2005. How can
this be implemented? Can I just detach my databases from Express and
re-attach them to Enterprise? How about the instances, like now I have
the following SERVERNAME\SQLEXPRESS?

Is there a documented procedure on this?

Thank you!


.

Relevant Pages

  • Re: SharePoint Services 3.0 unable to display content
    ... When connecting to the original configuration database, ... You are correct about the SQL Server. ... I am 100% about the WSS. ... Microsoft Windows SharePoint Services 2.0 ...
    (microsoft.public.sharepoint.windowsservices)
  • Re: MOSS2007 and SQL2005 on Single Server
    ... I concur with Mike's response referencing deployment of a low cost ... The version for WSS 3.0 isn't because a single server setup is quite ... database size will require you to upgrade to SQL Server ...
    (microsoft.public.sharepoint.portalserver)
  • RE: unable to create new content database in WSS 3.0
    ... \par Have you got any progress on this issue or did you find any useful clues at SQL Server side? ... \par Microsoft MSDN Online Support Lead ... \par Subject: RE: unable to create new content database in WSS 3.0 ...
    (microsoft.public.sharepoint.windowsservices)
  • RE: WSS install locked into MSDE DB - Can not install for SQL Serv
    ... Eventually our WSS spiraled down to the point where it could no longer ... SQL Server environment. ... > the WSS Web interface WSS still creates MSDE databases. ... >> Extend And Create A Content Database. ...
    (microsoft.public.sharepoint.windowsservices)
  • RE: Sharepoint Services problems
    ... attempting to connect to the SQL database under the credentials it was setup ... but these credentials are not valid in SQL. ... I would start by verifying the credentials under which WSS runs has ... > The SQL Server might not be started. ...
    (microsoft.public.sharepoint.windowsservices)
Loading