tag:blogger.com,1999:blog-3660389814846786186.post2667107478974101596..comments2023-06-15T08:40:59.202+02:00Comments on The voice of recyclable electrons: Exporting Files from SharePoint Content DatabaseVeynomhttp://www.blogger.com/profile/15956880658770004748noreply@blogger.comBlogger3125tag:blogger.com,1999:blog-3660389814846786186.post-50231917951078839672014-11-29T11:29:22.502+01:002014-11-29T11:29:22.502+01:00SharePoint Server Data Recovery software which is ...<br />SharePoint Server Data Recovery software which is associated with intranet, document management and with content management. Due to several reasons, it gets corrupted like virus attack, system shutdown automatically etc.<br /><br />Learn More:- <a href="http://www.recoverydeletedfiles.com/sharepoint-server-data-recovery.html" rel="nofollow">http://www.recoverydeletedfiles.com/sharepoint-server-data-recovery.html</a><br /><br /><br />Anonymoushttps://www.blogger.com/profile/02218898766733121413noreply@blogger.comtag:blogger.com,1999:blog-3660389814846786186.post-75586462196331198182013-03-04T14:43:40.250+01:002013-03-04T14:43:40.250+01:00Here is a little script to export File-Blobs as Fi...Here is a little script to export File-Blobs as Files from a sharepoint database directly (without Sharpoint Web running)<br /><br /><b><br />' VBS to read a BLOB (actually Image) column in SQL Server and save each row's image to a file.<br />' Example here reads PDFs stored in DocImage.Image column and saves each to a PDF file.<br />set oFS=CreateObject("Scripting.fileSystemObject")<br /><br />sub MakePath(p)<br /> if oFS.FolderExists(p) then exit sub<br /> i=instrrev(p,"\")<br /> if i=0 then return<br /> MakePath(left(p,i-1))<br /> WScript.Echo("Create '"+p+"'")<br /> oFS.CreateFolder(p)<br />end sub<br /><br />Const adTypeBinary = 1<br />Const adSaveCreateOverWrite = 2<br /><br />if WScript.Arguments.Count < 3 then<br /> WScript.Echo "Sorry, you have to enter some details for export:"<br /> WScript.Echo "BlobExport.vbs "<br /> WScript.Echo " is the SQL-Server name and instance e.g. 'SPSRV\SQLEXPRESS'"<br /> WScript.Echo " is the name ob the sharpoint database"<br /> WScript.Echo " is the source path - without starting URL"<br /> WScript.Echo " is the destination path for the export (for example 'D:\Willi')"<br /> WScript.Quit 0<br />end if<br /><br />sqlserver = WScript.Arguments.Item(0)<br />database = WScript.Arguments.Item(1)<br />sourcepath = WScript.Arguments.Item(2)<br />outPath = WScript.Arguments.Item(3)<br />WScript.Echo "SQL-Server: "+sqlserver<br />WScript.Echo "Database : "+database<br />WScript.Echo "Source : '"+source+"'"<br />WScript.Echo "Dest : "+outPath<br /><br /><br />Set rs = CreateObject("ADODB.Recordset")<br /><br />cn = "Provider=SQLOLEDB;Data Source="+sqlserver+";Initial Catalog="+database+";Integrated Security=SSPI;"<br />sql = "SELECT [DirName],[LeafName],DS.Content FROM AllDocStreams DS INNER JOIN AllDocs D ON (D.Id=DS.Id AND D.InternalVersion=DS.InternalVersion) WHERE D.DirName LIKE '"+sourcePath+"%'"<br /><br />rs.Open sql, cn<br /><br />do while Not rs.EOF<br /> Set stream = CreateObject("ADODB.Stream")<br /> dest=outPath + replace(cstr(rs.Fields("Dirname").Value),"/","\") <br /> filename=dest+"\"+ cstr(rs.Fields("LeafName").Value)<br /> MakePath(dest)<br /> WScript.Echo ("Download: "+filename)<br /> With stream<br /> .Type = adTypeBinary<br /> .Open<br /> .Write rs.Fields("Content").Value<br /> .SaveToFile filename, adSaveCreateOverWrite<br /> .Close<br /> End With<br /> rs.movenext<br />loop<br />rs.Close<br /></b>Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-3660389814846786186.post-79795451417919051242012-09-05T04:39:32.436+02:002012-09-05T04:39:32.436+02:00Restoring data from failed SharePoint server is no...Restoring data from failed SharePoint server is not an easy task. A third party SharePoint database recovery software may help the users to get upto 100 % data in such type situations. One of the best and globally used application can be downloaded from here:<br /><br />http://www.recoverydeletedfiles.com/sharepoint-server-data-recovery.htmlRecover Deleted Fileshttp://www.recoverydeletedfiles.com/noreply@blogger.com