Found this PDF on how to backup and restore your SharePoint (SPWeb) website using SharePoint Designer: backup-restore-share-point-2007.pdf
Kudos to the Creator of the PDF.
here we go, just some simple upload code that uploads documents into a document library.
It also checks if the same file exist in the destination library before upload.
SPSite site = new SPSite("http://mysharepointsite");
SPWeb web = site.OpenWeb();
web.AllowUnsafeUpdates = true; // i always add this in to prevent security errors
Stream fStream = postedFile.InputStream;
byte[] contents = new byte[fStream.Length];
fStream.Read(contents, 0, (int)fStream.Length);
fStream.Close();
string newFilename = System.IO.Path.GetFileName(postedFile.FileName);
SPFile fileExist = web.GetFile(destFolder + "/" + newFilename);
if (fileExist.Exists)
{
Response.Write("<font color='red'>Error: A file exist with the same filename. Please Rename this File.</font><br />");
}
else
{
web.GetFolder(destFolder).Files.Add(newFilename, contents);
completed.Text = "<br /><font color='green'>Successfully uploaded '" + filename + "' to: " + destFolder + " </font><br /><br /><br />";
}
As simple as it sounds, it ain’t simple.
you would of thought the following would work:
SPFile file = web.GetFile(strUrl);
file.name = "mynameFilename.txt";
file.Update();
does not compute..
There are 2 ways I’ve found of accomplishing this:
1. using the SPFile.MoveTo method:
string strUrl = "http://mysharepointsite/myolddocumentlibrary/Filename.txt";
string newFileUrl = "http://mysharepointsite/mynewdocumentlibrary/mynewFilename.txt";
SPSite site = new SPSite("http://mysharepointsite");
SPWeb web = site.OpenWeb();
web.AllowUnsafeUpdates = true; // this will stop it from erroring out due to security errors
SPFile file = web.GetFile(strUrl);
file.MoveTo(newFileUrl);
2. using File.Item["Name"] method..
string strUrl = "http://mysharepointsite/myolddocumentlibrary/Filename.txt";
SPSite site = new SPSite("http://mysharepointsite");
SPWeb web = site.OpenWeb();
web.AllowUnsafeUpdates = true; // this will stop it from erroring out due to security errors
SPFile file = web.GetFile(strUrl);
file.Item["Name"] = "NewFileName.txt";
However i have found method 1 more reliable. hope this helps!
Well guys, i just had the pleasure of deleting the LDF database file for my WSS 3.0 dev site.
Why? The server had literally 0.99MB of hard disk space and out of desperation, i deleted the 7GB log file by stopping the sql service and deleting the LDF file - i know, i wasn’t thinking straight…
Anyway, SQL went into a heap.. I couldn’t detach the database so i could re-attach it and re-create the logs..
The error was: It couldn’t find the log file so it couldn’t detach <- i mean how stupid is that…
Anyway, after fanning around, i uninstalled WSS3.0 and restarted the server.
Logged into SQL management studio, started a new Query and ran the following;
USE [master]
GO
CREATE DATABASE [SharePointTEST] ON
(FILENAME = N'D:\Path\To\Sharepoint\ConfigDB.mdf')
FOR ATTACH_REBUILD_LOG
GO
Now, the other database has detached itself and the new database SharePointTest is up and working with a LDF file.
My main concern now was will WSS 3.0 install and connect to an existing database? is it smart enough?
I managed to install WSS as usuall (stand alone server), then i went to Central Administration and it said none had been configured so hit next and to my amazement it configured it and launched sharepoint and boom i was back to my old sharepoint site.
Fantastic huh!
After doing some development/webpart work on our sharepoint server, the log file to grew to 3.5GB - we have 0.99MB of free space of a 20GB disk (this is a dev/test Virtual server).
Anyway after searching, i came across this blog: http://blogs.vertigo.com/personal/steventap/Blog/archive/2007/01/19/managing-sharepoint-2007-moss-application-log-size.aspx - thanks Steven!
Apparently you can manage how SharePoint logs it’s events:
The Problem:
SharePoint 2007 by default stores 48 hours worth of logs in a directory buried in your program files folder (C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\12\LOGS\ !). Very few events get logged to the application event log.
Expect each log file to be at least 200 megs (a log file being generated every 30 minutes by default), or 19 GB of space at the minimum being used by SharePoint logs.
Solutions:
Go to your central administration server web site, and open up the Diagnostic logging:
In the Diagnostic logging page, focus on the following categories:
Event Throttling:
Trace Log:
I too have dreaded this error - it means nothing to me and just pisses me off especially when developing webparts.
You can remove this by opening the web.config,
Search for <customErrors mode=“On“ /> and change it to <customErrors mode=“Off“ />
To see the call stack and trace information. Find
<SafeMode MaxControls=“200” CallStack=“false” DirectFileDependencies=“10” TotalFileDependencies=“50” AllowPageLevelTrace=“false“>
and change the value of “CallStack” to true.
<SafeMode MaxControls=“200” CallStack=“true” DirectFileDependencies=“10” TotalFileDependencies=“50” AllowPageLevelTrace=“true“>
Finally, don’t forget the set debug=”true” in the web.config or it won’t matter whether you put the assembly in GAC or not without it the breakpoints will turn all nice and red, but it won’t stop anywhere. If you want to enable generation of debug symbols for just in time compilation Find
<compilation batch=“false“ debug=“false“>
and change it to
<compilation batch=“false“ debug=“true“>.
Although none of these are appropriate for a production environment, but they all make development much easier.
-Ibrahim Sukari
Hi All,
I want to publish the backup script i use to backup sharepoint every night. It is a very basic BATCH script (.bat) which uses STSADM sharepoint command line tool to backup sharepoint then uses winrar to zip and compress the file in date format then copy to the destination drive.
# setting a the variable stsadm as the location of the command line tool
set stsadm="C:\Program Files\Common Files\Microsoft Shared\web server extensions\12\BIN\stsadm.exe"
# set the variable %todaysdate% as todays date
set %todaysdate%=%date:~7,2%_%date:~4,2%_%date:~10,4%
# make a directory for today's sharepoint backup
mkdir E:\Backups\Sharepoint\File\%todaysdate%
# we are using the STSADM tool to make a full sharepoint backup
%stsadm% -o backup -directory E:\Backups\Sharepoint\File\%todaysdate% -backupmethod full
# this is zipping up the sharepoint backup as SharepointBackupXX_XX_XX.rar from contents of E:\backups\sharepoint\file\
"c:\program files\winrar\winrar.exe" a -u -r -m5 "E:\Backups\Sharepoint\Zip\SharepointBackup%date:~7,2%_%date:~4,2%_%date:~10,4%.rar" "E:\Backups\Sharepoint\File\%todaysdate%\*.*"
# this is copying the contents of "ZIP" to the destination backup drive which is mapped as S:\
xcopy "E:\Backups\Sharepoint\Zip" "S:\Sharepoint\" /Y /E
Any comments or suggestions are welcome.
-Ibrahim
You recieve the event (17137) in the eventlog when you migrate the databases to a different disk or partition (in this case i moved it to a different partition).
The description for Event ID ( 17137 ) in Source ( MSSQL$MICROSOFT##SSEE ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event: WSS_Content.
The problem here is that when we re-attached the database to the SQL server the ‘AutoClose’ option (this option when ON closes the database cleanly when the last user logs off) is set to true.
FIX:
Recent Comments