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!

Re: Saving WSS site prior to upgrading SQL Server 2005 Express to by Mike

Mike
Fri Jun 13 04:35:18 CDT 2008

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!
>
>

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

Zaur
Fri Jun 13 09:42:22 CDT 2008

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@hotmail.com> ha scritto nel messaggio
news:OwXyQjTzIHA.3504@TK2MSFTNGP06.phx.gbl...
>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!



Re: Saving WSS site prior to upgrading SQL Server 2005 Express to by Mike

Mike
Fri Jun 13 10:37:54 CDT 2008

You decide when you install WSS 3.0 whether you use the embedded version
of SQl Server 2005 Express or whether you want to use a different
database system.

If you choose Basic Installation or 'Advanced Installation +
Single-Server' it will use the embedded version even if another version
of SQL Server 2005 is available.

The advantages of the embedded version ("Windows Internal Database")
over the standard SQL Server 2005 Express is that there is no limit to
the database size (4GB with SQL Server 2005 Express). The disadvantage
is that you can only use the embedded version for SharePoint databases
(and other "windows components").

From the above you should know whether you have only one database
system or two. If you have two, your SP databases will be in the Windows
Internal Database and you can migrate them by following that article.

Mike Walsh

Zaur Bahramov wrote:
> 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@hotmail.com> ha scritto nel messaggio
> news:OwXyQjTzIHA.3504@TK2MSFTNGP06.phx.gbl...
>> 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!
>
>

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

Zaur
Sun Jun 15 03:40:46 CDT 2008

I've followed the procedure. When I reach to the last item, I receive the
following error:
Your backup is from a different version of Windows SharePoint Services and
cannot be restored to a server runn
ing the current version. The backup file should be restored to a server with
version '12.0.0.6219' or later.

?


"Mike Walsh" <englantilainen@hotmail.com> wrote in message
news:OFd59tWzIHA.2208@TK2MSFTNGP04.phx.gbl...
> You decide when you install WSS 3.0 whether you use the embedded version
> of SQl Server 2005 Express or whether you want to use a different database
> system.
>
> If you choose Basic Installation or 'Advanced Installation +
> Single-Server' it will use the embedded version even if another version of
> SQL Server 2005 is available.
>
> The advantages of the embedded version ("Windows Internal Database") over
> the standard SQL Server 2005 Express is that there is no limit to the
> database size (4GB with SQL Server 2005 Express). The disadvantage is that
> you can only use the embedded version for SharePoint databases (and other
> "windows components").
>
> From the above you should know whether you have only one database system
> or two. If you have two, your SP databases will be in the Windows Internal
> Database and you can migrate them by following that article.
>
> Mike Walsh
>
> Zaur Bahramov wrote:
>> 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@hotmail.com> ha scritto nel messaggio
>> news:OwXyQjTzIHA.3504@TK2MSFTNGP06.phx.gbl...
>>> 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!
>>


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

Zaur
Sun Jun 15 04:16:41 CDT 2008

Resolved!!!

The problem was that I've made a backup mentioned in your procedure while
having wss3 sp1 installed. It wasn't restoring the database because I've
installed wss 3.0 without the service pack first. After installing a SP1 it
worked as a charm!

Thank you!



"Zaur Bahramov" <zbakhramov@msn.com> wrote in message
news:eiMvIOszIHA.3920@TK2MSFTNGP02.phx.gbl...
> I've followed the procedure. When I reach to the last item, I receive the
> following error:
> Your backup is from a different version of Windows SharePoint Services and
> cannot be restored to a server runn
> ing the current version. The backup file should be restored to a server
> with version '12.0.0.6219' or later.
>
> ?
>
>
> "Mike Walsh" <englantilainen@hotmail.com> wrote in message
> news:OFd59tWzIHA.2208@TK2MSFTNGP04.phx.gbl...
>> You decide when you install WSS 3.0 whether you use the embedded version
>> of SQl Server 2005 Express or whether you want to use a different
>> database system.
>>
>> If you choose Basic Installation or 'Advanced Installation +
>> Single-Server' it will use the embedded version even if another version
>> of SQL Server 2005 is available.
>>
>> The advantages of the embedded version ("Windows Internal Database") over
>> the standard SQL Server 2005 Express is that there is no limit to the
>> database size (4GB with SQL Server 2005 Express). The disadvantage is
>> that you can only use the embedded version for SharePoint databases (and
>> other "windows components").
>>
>> From the above you should know whether you have only one database system
>> or two. If you have two, your SP databases will be in the Windows
>> Internal Database and you can migrate them by following that article.
>>
>> Mike Walsh
>>
>> Zaur Bahramov wrote:
>>> 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@hotmail.com> ha scritto nel messaggio
>>> news:OwXyQjTzIHA.3504@TK2MSFTNGP06.phx.gbl...
>>>> 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!
>>>
>