从备份中恢复被用户误删的sharepoint 2003的Doc Library。
在sharepoint 2003中因为没有回收功能，恢复被用户误删得文件相当麻烦。一般的途径是恢复sql2000的备份，重新安装一个sharepoint 2003,用一个偷梁换柱的办法（修改GUID）把新的sharepoint2003连接回sql2000的备份。然后取回文件。
其实有一个更加简单办法。
因为所有的文件均存放在docs表中，使用以下的代码就可以把文件取回本地
string connectionString = @"Data Source=<SQL2000 Server Name>;Initial Catalog=<Database Name>;Integrated Security=True";
using (SqlConnection conn = new SqlConnection(connectionString))
{
conn.Open();
//This section is to obtain the total number of files
//SQL query string: dirname = folder from which you would like to retrieve from
//extension<>'' = must have extension = must be a file
//size >0 = size of file must not be NULL
SqlCommand cmd0 = new SqlCommand(@"select count(*) from docs where dirname like '%lrts/shared%' and extension <>'' and size >0 ", conn);
SqlDataReader reader0 = cmd0.ExecuteReader();
reader0.Read();
string totalItems = reader0.ToString();
reader0.Close();
int itemNums = Int32.Parse(totalItems);
//This section retrieves all the Id of the files and places them in a ArrayList
SqlCommand cmd1 = new SqlCommand(@"select Id, DirName, LeafName, Size from docs where dirname like '%<DocLib Path>%' and extension <>'' and size >0 ", conn);
SqlDataReader reader1 = cmd1.ExecuteReader();
ArrayList allID = new ArrayList();
for (int i = 0; i < itemNums; i++)
{
reader1.Read();
string IDNumber = reader1["Id"].ToString();
allID.Add(IDNumber);
}
reader1.Close();
//This section retrieves all files
for (int i = 0; i < itemNums; i++)
{
string IDNumber = (string)allID; //getting Id
SqlCommand cmd = new SqlCommand(@"select Id, DirName, LeafName, Size, Content from docs where dirname like '%lrts/shared%' and extension <>''and size >0 and Id='" + IDNumber + "'", conn);
SqlDataReader reader = cmd.ExecuteReader(CommandBehavior.SingleRow);
if (reader.HasRows)
{
reader.Read();
//set the content length to the stored content length in the DB
String ContentLength = reader["Size"].ToString();
String dirName = reader["DirName"].ToString();
//creating directory structure from dirName
Directory.CreateDirectory(@"C:\retrieve docs\" + dirName);
//place the file in this dir
string pathName = @"C:\retrieve docs\" + dirName + @"\";
//getting the filename
String fileName = reader["LeafName"].ToString();
//read out the binary data from the db
byte[] data = reader["Content"] as byte[];
MemoryStream memstream = new MemoryStream();
memstream.Write(data, 0, Int32.Parse(ContentLength));
byte[] byteArray = memstream.ToArray();
memstream.Flush();
memstream.Close();
FileStream fs = File.Create(pathName + fileName);
BinaryWriter bw = new BinaryWriter(fs);
bw.Write(byteArray);
bw.Close();
fs.Close();
reader.Close();
}
}
}
这个方法很快就拿到了文件，当然，用户的权限就没有办法取回了。
页:
[1]