Re: how to restore a single document from sharepoint?

BB,

Well, if you take db backups, then it is possible to extract a single
document with a third party tool. I will release a tool today or tomorrow
that will accomplish this task. Visit my blog by the end of the day:
http://sharepointblogs.com/ssa

--SSA
http://sharepointblogs.com/ssa (All About SharePoint)

-----

"FriscoSoxFan" <junk@xxxxxxxxxxx> wrote in message
news:1148135091.475243.86650@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
No experience with that software, but here's how I manage this in our
fairly small deployment (2000 users). I ensure that we are using
multiple content databases and that thier size never exceeds 100GB. I
do this with a combination of site quotas, site per content database
limiting, and use static-sized SQL databases as a fail-safe.

To do a document restore, you determine which content database the site
was in, then restore your SQL backup (assuming you do scheduled
backups) to a development server. I have a separate IIS virtual server
set up on a different port, and restore a new portal site to this
virtual server. Find the document and put it back in production.

Note that I also use NinTex smartLibrary to provide my users with a 14
day recycle bin and repeatedly emphasize that a restore operation will
take up to a day and will not be considered until after 48 hours have
gone by. I find that most users really don't need to restore files most
of the time and only ask because they are unsure and are erring on the
side of caution because they think it is simple.

I've heard the DocAve is the gold standard for single-item restore if
ou are looking to buy a solution.
http://www.avepoint.com/products/DocAve.htm.



.

Relevant Pages

  • Re: SQL Maintenance Plans and Atomic Backups of a Set of Databases
    ... Actually, the maintenance plans are still a valuable method of running backups, though you can also create scripts for them. ... Yes, the documentation indicates that STOPATMARK should work for you, provided that you update all 12 databases inside the same marked transaction. ... However, no matter when you decide to set the transaction marks, it is the restore databases that will make use of them. ...
    (microsoft.public.sqlserver.tools)
  • Re: SQL 2000 restore to new server
    ... failed totally then your overnight backups may be the most recent files ... available to restore from. ... > All databases, user and system are backed up ... > I agree in the script solution....hence my included version in the ...
    (microsoft.public.sqlserver.server)
  • Re: eseutil /?
    ... do mount the store...do your restore, and let the server run recovery, then ... validity of my backups without mounting my databases, ... eseutil /g -- this checks file integrety ...
    (microsoft.public.exchange.admin)
  • Re: Mail not mounting
    ... A hard repair (eseutil /p) is done, in the event when there are no backups ... Check the consistency of the databases by running the following command ... If you do have a good back, it is better that you restore from tape backup ...
    (microsoft.public.exchange2000.admin)
  • Re: Mailbox Backup
    ... The key point is number 12, the Recovery storage group. ... this allows you to restore your entire Exchange store to this special ... > Individual mailbox backups are not supported in ...
    (microsoft.public.windows.server.sbs)
Loading