Re: Saving WSS site prior to upgrading SQL Server 2005 Express to Standard/Enterprise
- From: "Zaur Bahramov" <zbakhramov@xxxxxxx>
- Date: Sun, 15 Jun 2008 10:40:46 +0200
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@xxxxxxxxxxx> wrote in message
news:OFd59tWzIHA.2208@xxxxxxxxxxxxxxxxxxxxxxx
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@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!
.
- Follow-Ups:
- References:
- Saving WSS site prior to upgrading SQL Server 2005 Express to Standard/Enterprise
- From: Zaur Bahramov
- Re: Saving WSS site prior to upgrading SQL Server 2005 Express to Standard/Enterprise
- From: Mike Walsh
- Re: Saving WSS site prior to upgrading SQL Server 2005 Express to Standard/Enterprise
- From: Zaur Bahramov
- Re: Saving WSS site prior to upgrading SQL Server 2005 Express to Standard/Enterprise
- From: Mike Walsh
- Saving WSS site prior to upgrading SQL Server 2005 Express to Standard/Enterprise
- Prev by Date: Join more than 2 lists
- Next by Date: Re: Saving WSS site prior to upgrading SQL Server 2005 Express to Standard/Enterprise
- Previous by thread: Re: Saving WSS site prior to upgrading SQL Server 2005 Express to Standard/Enterprise
- Next by thread: Re: Saving WSS site prior to upgrading SQL Server 2005 Express to Standard/Enterprise
- Index(es):
Relevant Pages
|
