| Author |
Message |
Guest
|
 Posted:
Fri Jan 14, 2005 12:56 am Post subject:
Restore Sharepoint Site with SQL Databases Only |
|
|
Is it possible to restore a Sharepoint site with only the Configuration
and Content Database? If so can anyone tell me how.
If not is there a way to minimize the loss?
Thanks! |
|
| Back to top |
|
 |
Todd Klindt
Guest
|
| Posted:
Fri Jan 14, 2005 5:21 am Post subject:
Re: Restore Sharepoint Site with SQL Databases Only |
|
|
Yes, you can. How? How granular an explanation do you need? From 30,000
feet it's the same operation as the backup except it's restore. You can do
it in SQL Enterprise manager, or your favorite backup software.
tk
<outoftherealm@hotmail.com> wrote in message
news:1105642608.402056.78690@z14g2000cwz.googlegroups.com...
| Quote: | Is it possible to restore a Sharepoint site with only the Configuration
and Content Database? If so can anyone tell me how.
If not is there a way to minimize the loss?
Thanks!
|
|
|
| Back to top |
|
|
Mike Walsh
Guest
|
| Posted:
Fri Jan 14, 2005 11:39 am Post subject:
Re: Restore Sharepoint Site with SQL Databases Only |
|
|
| Quote: | Is it possible to restore a Sharepoint site with only the >Configuration
and Content Database? |
Strictly speaking and looking at your word "site" in the question (although
Todd's answer is I'm sure right for what you actually have as a problem)
you'll also need to re-install WSS as if your entire server has gone getting
the databases back doesn't help you much without the code to utilise it and
that's in C: installed by the installation routine.
Mike Walsh, Helsinki, Finland
WSS FAQ at http://wss.collutions.com
Please post questions to the newsgroup only.
<outoftherealm@hotmail.com> wrote in message
news:1105642608.402056.78690@z14g2000cwz.googlegroups.com...
| Quote: | Is it possible to restore a Sharepoint site with only the Configuration
and Content Database? If so can anyone tell me how.
If not is there a way to minimize the loss?
Thanks!
|
|
|
| Back to top |
|
|
Guest
|
| Posted:
Fri Jan 14, 2005 9:21 pm Post subject:
Re: Restore Sharepoint Site with SQL Databases Only |
|
|
So I would reinstall sharepoint, and then should I restore both the
content and configuration databases?
I dont mean to be dense it's just that I have tried this and am having
trouble getting this back online.
Thanks |
|
| Back to top |
|
|
Mike Walsh
Guest
|
| Posted:
Fri Jan 14, 2005 9:49 pm Post subject:
Re: Restore Sharepoint Site with SQL Databases Only |
|
|
It depends what has crashed.
Todd's answer assumed you had a working WSS site and needed to recover the
database and was saying that, yes, you needed to recover both the
configuration and the content database.
Mine (being I thought somewhat pedantic) was adding the fact that you needed
WSS itself as well if that too had gone.
i.e. you need to restore the drive on which WSS was installed (if that's
gone) and the databases and connect the two.
Someone else will have to give instructions about how to connect the two
because I've never been forced to do it (and we have full disk backups on
all drives including the ones where the databases are *and* database
backups). While you are waiting for that look in the Admin Guide, it ought
to be there.
Mike Walsh, Helsinki, Finland
"Mike Walsh" <englantilainen@hotmail.com> wrote in message
news:Oz7qwtf%23EHA.608@TK2MSFTNGP15.phx.gbl...
| Quote: | Is it possible to restore a Sharepoint site with only the >Configuration
and Content Database?
Strictly speaking and looking at your word "site" in the question
(although
Todd's answer is I'm sure right for what you actually have as a problem)
you'll also need to re-install WSS as if your entire server has gone
getting
the databases back doesn't help you much without the code to utilise it
and
that's in C: installed by the installation routine.
Mike Walsh, Helsinki, Finland
WSS FAQ at http://wss.collutions.com
Please post questions to the newsgroup only.
outoftherealm@hotmail.com> wrote in message
news:1105642608.402056.78690@z14g2000cwz.googlegroups.com...
Is it possible to restore a Sharepoint site with only the Configuration
and Content Database? If so can anyone tell me how.
If not is there a way to minimize the loss?
Thanks!
|
|
|
| Back to top |
|
|
Todd Klindt
Guest
|
| Posted:
Mon Jan 17, 2005 6:15 pm Post subject:
Re: Restore Sharepoint Site with SQL Databases Only |
|
|
It depends on your situation. The Config database carries a lot of
information about the servername and site settings, so unless everything is
exactly the same restoring the ConfigDB might cause you more troubles. In
my experience I restore the ContentDBs and then stitch them into the
ConfigDB so that it knows where to point for everything. It's kind of an
ugly process and not for the faint of heart. If it's something you are
interested in I can try to remember all the steps and post them.
*Of course, mucking around in SQL is a really bad idea and you shouldn't do
it.
tk
<outoftherealm@hotmail.com> wrote in message
news:1105716096.204436.326480@z14g2000cwz.googlegroups.com...
| Quote: | So I would reinstall sharepoint, and then should I restore both the
content and configuration databases?
I dont mean to be dense it's just that I have tried this and am having
trouble getting this back online.
Thanks
|
|
|
| Back to top |
|
|
|
|
|
|
FAQ
Memberlist
Register
Profile
Log in to check your private messages
Log in