Recover SPS to SQL Server from Desktop Engine data

Greetings, I have a bit of a mess and before starting anew I thought I'd
give the experts a go. I had a nicely functioning SPS site until I tried to
upgrade my SBS server to SP1. The upgrade failed, as did the backout.
Apparently my backup did not include system state so I could not recover.

Since then I've rebuilt the SBS and installed SP1 as well as SQL Server. I
have the
following data files available:
----.STS_config.mdf
----.STS_config.log.ldf
----.sts_server2_1.mdf
----.sts_server2_1.log.ldf

I've created a new SharePoint site on SQL Server with a name of
httP://companyweb/default.asp which is different from the old one.

My question is .. can i import these files into the new site and get back
to where I was?

FYI, I'm running SBS2003, SQL Server

Thanks, in advance for the help.

Mike

Engelbert
Mon Apr 10 23:42:50 CDT 2006

> I had a nicely functioning SPS site until I tried to
> upgrade my SBS server to SP1.

SBS support is at microsoft.public.windows.server.sbs

SPS support is at microsoft.public.sharepoint.portalserver

From the text of your message those are the two products you seem to be
running.

Given the choice I'd post to the SBS one of the two because your problems
arose in connection with upgrading to its SP1.

Engelbert

"mm1861" <mm1861@discussions.microsoft.com> wrote in message
news:81AC6B7C-93FE-4E38-910E-4637B3701F30@microsoft.com...
> Greetings, I have a bit of a mess and before starting anew I thought I'd
> give the experts a go. I had a nicely functioning SPS site until I tried
> to
> upgrade my SBS server to SP1. The upgrade failed, as did the backout.
> Apparently my backup did not include system state so I could not recover.
>
> Since then I've rebuilt the SBS and installed SP1 as well as SQL Server.
> I
> have the
> following data files available:
> ----.STS_config.mdf
> ----.STS_config.log.ldf
> ----.sts_server2_1.mdf
> ----.sts_server2_1.log.ldf
>
> I've created a new SharePoint site on SQL Server with a name of
> httP://companyweb/default.asp which is different from the old one.
>
> My question is .. can i import these files into the new site and get back
> to where I was?
>
> FYI, I'm running SBS2003, SQL Server
>
> Thanks, in advance for the help.
>
> Mike

RobinMeur
Tue Apr 11 02:27:01 CDT 2006

If you had WSS running without SP1 and now want to use the database with WSS
SP1 it can't happen since the database structure is different.
But you can try and go to the central administration page of Sharepoint and
defyning a different content database for your new site.
Central Administration page > Configure virtual server settings > Manage
content databases > Add database > "sts_server2_1" > Ok > Click on the
database that was already there and at the bottom of the page check 'remove
content database' > ok

That's it :)

"mm1861" wrote:

> Greetings, I have a bit of a mess and before starting anew I thought I'd
> give the experts a go. I had a nicely functioning SPS site until I tried to
> upgrade my SBS server to SP1. The upgrade failed, as did the backout.
> Apparently my backup did not include system state so I could not recover.
>
> Since then I've rebuilt the SBS and installed SP1 as well as SQL Server. I
> have the
> following data files available:
> ----.STS_config.mdf
> ----.STS_config.log.ldf
> ----.sts_server2_1.mdf
> ----.sts_server2_1.log.ldf
>
> I've created a new SharePoint site on SQL Server with a name of
> httP://companyweb/default.asp which is different from the old one.
>
> My question is .. can i import these files into the new site and get back
> to where I was?
>
> FYI, I'm running SBS2003, SQL Server
>
> Thanks, in advance for the help.
>
> Mike

Engelbert
Tue Apr 11 10:42:05 CDT 2006

> If you had WSS running without SP1

He wrote "I had a nicely functioning *SPS* site" (My stress).

Not *WSS* !

Engelbert


"Robin Meuré" <RobinMeur@discussions.microsoft.com> wrote in message
news:C80BFB83-3DE7-4D85-B7E9-22F5899FF416@microsoft.com...
> If you had WSS running without SP1 and now want to use the database with
> WSS
> SP1 it can't happen since the database structure is different.
> But you can try and go to the central administration page of Sharepoint
> and
> defyning a different content database for your new site.
> Central Administration page > Configure virtual server settings > Manage
> content databases > Add database > "sts_server2_1" > Ok > Click on the
> database that was already there and at the bottom of the page check
> 'remove
> content database' > ok
>
> That's it :)
>
> "mm1861" wrote:
>
>> Greetings, I have a bit of a mess and before starting anew I thought I'd
>> give the experts a go. I had a nicely functioning SPS site until I tried
>> to
>> upgrade my SBS server to SP1. The upgrade failed, as did the backout.
>> Apparently my backup did not include system state so I could not recover.
>>
>> Since then I've rebuilt the SBS and installed SP1 as well as SQL Server.
>> I
>> have the
>> following data files available:
>> ----.STS_config.mdf
>> ----.STS_config.log.ldf
>> ----.sts_server2_1.mdf
>> ----.sts_server2_1.log.ldf
>>
>> I've created a new SharePoint site on SQL Server with a name of
>> httP://companyweb/default.asp which is different from the old one.
>>
>> My question is .. can i import these files into the new site and get
>> back
>> to where I was?
>>
>> FYI, I'm running SBS2003, SQL Server
>>
>> Thanks, in advance for the help.
>>
>> Mike

mm1861
Tue Apr 11 11:11:02 CDT 2006

Thanks to all, I'm back on track.
Consider this closed.
mm

"mm1861" wrote:

> Greetings, I have a bit of a mess and before starting anew I thought I'd
> give the experts a go. I had a nicely functioning SPS site until I tried to
> upgrade my SBS server to SP1. The upgrade failed, as did the backout.
> Apparently my backup did not include system state so I could not recover.
>
> Since then I've rebuilt the SBS and installed SP1 as well as SQL Server. I
> have the
> following data files available:
> ----.STS_config.mdf
> ----.STS_config.log.ldf
> ----.sts_server2_1.mdf
> ----.sts_server2_1.log.ldf
>
> I've created a new SharePoint site on SQL Server with a name of
> httP://companyweb/default.asp which is different from the old one.
>
> My question is .. can i import these files into the new site and get back
> to where I was?
>
> FYI, I'm running SBS2003, SQL Server
>
> Thanks, in advance for the help.
>
> Mike