Re: Restoring MSDE database

Tech-Archive recommends: Fix windows errors by optimizing your registry

OK. Thanks a lot.

This is still confusing for me

"just remove the new content database and recreate one, it will generate a
new one with different name. "

Can you go into details.?

So far we have

- make a copy of your old content database

-------------

- install WSS (which creates a content database and a config database)

- remove the content database (how?)

- recreate one (how?) - will generate a new one with a new name

Note: what is the difference between this one and the one you had when you
newly installed WSS ? They are both empty content databases so why do you
need these 2 steps ?

- restore the old content database from backup
- add the (new) content database to the virtual server

Engelbert

"Need Help" <DONTSPAM@xxxxxxxxxxxx> wrote in message
news:eXflqCbwGHA.1304@xxxxxxxxxxxxxxxxxxxxxxx
New sharepoint site content database name MUST not be the same as the
original content database name. Overwriting the content database with the
backup will crash the sharepoint site. However, it simply solve the
problem just remove the new content database and recreate one, it will
generate a new one with different name. Then restoring the old content
database from backup and adding this content database to the virtual
server completes the recovery.




"Engelbert" <Engelbert@xxxxxxxxxxxxxxxxxxxxxx>
¼¶¼g©ó¶l¥ó·s»D:umrw56QwGHA.4140@xxxxxxxxxxxxxxxxxxxxxxx
Thanks for this addition.

Do you mean that you needed to make sure that the new content database
name
was *the same* as the old one ?

If not, can you please spell out what this

"Before step 5, I must make sure my new WSS site content database name
cause
no conflict with old content database"

exactly means ?

Engelbert

"Need Help" <DONTSPAM@xxxxxxxxxxxx> wrote in message
news:%23JalddQwGHA.3364@xxxxxxxxxxxxxxxxxxxxxxx
After numerous backup and restore trial and error, I found that since my
new WSS site content database is as the same as the old one.


What I must do that requires minor extra steps are:
http://wss.collutions.com/Lists/FAQ/DispForm.aspx?ID=460

Before step 5, I must make sure my new WSS site content database name
cause no conflict with old content database




"Need Help" <DONTSPAM@xxxxxxxxxxxx>
¼¶¼g©ó¶l¥ó·s»D:uMpjMKQwGHA.1956@xxxxxxxxxxxxxxxxxxxxxxx
According to WSS FAQ, it states that STS_config needs not restore, I try
it
but I still fails to add content database in Central Admin page. Is that
MSDE limitation?




.

Relevant Pages

  • recreate system tables
    ... I need to recreate the system tables (sysobjects, syscolumns, ... sysindexes, sysforeignkeys, sysconstraints, sysreferences, sysindexkeys ... Backup and restore the database!" ... Perhaps the simplest way is to do a bcp to backup and restore the data ...
    (comp.databases.ms-sqlserver)
  • Re: Non-portal content search - no results
    ... The search results are not stored in the database. ... So if you go to a WSS site and do a search at that site for something on ... indexing feature of your SQL server. ... >>> MS Gold Certified Partner ...
    (microsoft.public.sharepoint.portalserver)
  • Re: pulling data from an access database
    ... to connect an access database onto a wss site. ... >>> I haven't tried the office web parts yet but do you by any chance know ... >>> for something in the database from a wss site. ...
    (microsoft.public.sharepoint.windowsservices)
  • Re: ERROR: The Web site that is referenced here is not in the configuration database
    ... when I tried to detach the database and restore it on a different ... Check the old site name and the db name, and try to restore them to the same ... > After creating/extending a new virtual server for the original WSS ... for the WSS Site, I created a virtual server using the IP ...
    (microsoft.public.sharepoint.portalserver)
  • Re: Content DBs for different sites under a portal.
    ... Add a content database to the portal ... On the existing content DB for the portal set the site limit to the current ... > portal site or a top-level WSS site) to specify its own Content ...
    (microsoft.public.sharepoint.portalserver)