Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

installing sharepoint from existing sql db

  Asked By: Carolyn    Date: Dec 15    Category: Sharepoint    Views: 781

i had sharepoint installed on my server but i uninstalled it by
so i installed it again but what i get is sharepoint without any sites
on ot.
i saw that the whole db and the data in it are still exist on the sql
how can i restore this db to sharepoint?



10 Answers Found

Answer #1    Answered By: Tejaswani Barve     Answered On: Dec 15

i tried to cpnnect the database but i get 0 sites on it....
what can i do acout it?

Answer #2    Answered By: Harshita Padwal     Answered On: Dec 15

Have you tried choosing the restore  portal option instead of the ‘Create Portal’ option found in ‘List and Manage Portals’ in the SharePoint Administration pages. If you choose this and then type the names of the _SITE, _PROF and _SERV databases it should restore your portal. However if you also had further content databases you will need to manually ad these back after your portal has been restored. Hope this helps.

Answer #3    Answered By: Jennifer Jones     Answered On: Dec 15

no i didn't try restore  portal bacause this db that the portal is
working on now has no sites (except the default one).
and what are those: _SITE, _PROF and _SERV ?
what i found in the sql  manager is just the SPS_serverName_number DB.
i have two of those. one of them i need to restore...

well, how can i manually add these db to my portal?

Answer #4    Answered By: Annie Norris     Answered On: Dec 15

If you don't see _SITE, _PROF and _SERV SQL Enterprise Manager then you
most likely lost your data  (sites and content). The other database you
are talking about (SPS_serverName_number DB) sounds like the SharePoint
config database. Every portal has a config database and three other
database that store all the content. You will need them. Do you back
them up at all, if so I would get the _SITE, _PROF and _SERV databases
restored and then try a portal restore  from central admin.

Answer #5    Answered By: Chadd Hahn     Answered On: Dec 15

Oh, by the way, I don't think you even have to use the "Portal Restore"
option in central admin, if you still have the original config db and
the _SITE, _PROF and _SERV db's then you should just be able to just
re-create a site in IIS and choose the "Extend and connect to existing
virtual server", I think I have done it this way in the past.

Answer #6    Answered By: Laura Walker     Answered On: Dec 15

where can i find those db : _SITE, _PROF and _SERV ? in which path?

i didn't find it in the sql  manager with all the databases (even not
those db of the current portal).

what i did find is the sps_serv db, it weigh something like 400 MB and
i opened the tables and found the website details in webs table and
all the documents details in docs table, should it be helpfull?

Answer #7    Answered By: Titus Sweet     Answered On: Dec 15

Then you are not using SOS............

Answer #8    Answered By: Jagdish Joshi     Answered On: Dec 15

Not sure what happened there, I meant to say, then you are not using
Portal Server. Could it be WSS or SharePoint 2001? If you are using
SharePoint 2001, then I have no idea how to help you. I never used that
product. However, if it is WSS, then you should still have at least two
db's (config and content).

You would set the path to your sql  db files, so I am not sure where you
put them but you could check where the existing  one is by right clicking
on the database in sql enterprise manager and checking the properties.
You should have a data  and log file tab. You could also check the
defaul Microsoft location, which si c:\program files\microsof
sql\mssql\80\data (I think.........not in front of a server  right now).

Answer #9    Answered By: Christop Mcfadden     Answered On: Dec 15

i checked it today, and you were right - i have WSS.

i found the files, yet i think that i don't have the config DB of the
old installation - i have just the server  one... (and the config of
the new one)

how much really is it necessary the config db?

and what can i exactly do now?

Answer #10    Answered By: Victoria Bell     Answered On: Dec 15

I think you are going to be out of luck then, I don't know of anyway to
get back the site without the config db but I don't claim to know
everything...........someone else might. That database is pretty
important since it holds all of you site url's, so without that db it's
like your WSS install has no sites (even thought the content is there in
the content db).

Are you sure you don't backup those config db's? If you found your sql
db file then you might be able to find the backup folder or where it is
you store your sql  backups. Look for a file name something like
SPS_Config_db. If you can restore  that, then you can just connect back
to that config via central admin and extent and map to your IIS
site.........like magic everything will be back to normal. Without that
db though, I am not sure what can do to get back you site.

Didn't find what you were looking for? Find more on installing sharepoint from existing sql db Or get search suggestion and latest updates.