Re: Recover SPS to SQL Server from Desktop Engine data

If you had WSS running without SP1

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

Not *WSS* !

Engelbert


"Robin Meuré" <RobinMeur@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:C80BFB83-3DE7-4D85-B7E9-22F5899FF416@xxxxxxxxxxxxxxxx
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


.

Relevant Pages

  • RE: SBS2003 Sharepoint Limitations
    ... database limitations of sharepoint in SBS 2003. ... Based on my research, by default, the sharepoint uses WMSDE database to ... Microsoft SQL Server 2000 Desktop Engine -. ...
    (microsoft.public.windows.server.sbs)
  • RE: SSIS Transfer object failure
    ... The problem is the "CopySchema" option it has to be set to ... a SQL Server 2005 SP1 database table to another database; ... I would like to let you know that though SQL Server ... 2005 SP1 has fixed many known issues, there are still some new discovered ...
    (microsoft.public.sqlserver.dts)
  • Re: Maximum database size for WSS using SQL Server 2000
    ... When using SQL Server 2000, there are no limitations to database size. ... whole bunch of images into SharePoint, that will take up lots of storage ... times are caught by surprise as to the rapid growth of SharePoint databases. ...
    (microsoft.public.sharepoint.windowsservices)
  • RE: Event 27745 Error
    ... Additional error information from SQL Server is included below. ... We are worried that the SharePoint Services would crash one day, ... Unable to connect to database. ... information or message DLL files to display messages from a remote computer. ...
    (microsoft.public.windows.server.sbs)
  • SharePoint not working on SBS2008
    ... I am having a SharePoint problem. ... SharePoint and of SQL server 2005 so I think I may need a fairly complete ... to backup the SharePoint database files, run the setup wizard then restore ... "ShareWebDb" requested by the login. ...
    (microsoft.public.windows.server.sbs)