Tech Battle Field

I had one of my customer having more than 48GB on the content DB. After couple of search, I found the following method that worked for me: 1. Empty your sharepoint Recylce Bin (This actually gets you a lot of space) - Navigate to you Recycle Bin in two ways http://yoursite/_layouts/AdminRecycleBin.aspx http://yoursite//_layouts/storman.aspx 2. Defragment your content DB : Defragmentation of the database keeps the data organized.  If you have installed Service Pack 2, then this happens automatically.  If you have not installed Service Pack 2 then there are instructions for how to do this.  http://support.microsoft.com/kb/943345    3. Shrink the DB - A shrink reduces the size of the database.  If there is a very large amount listed reported as "space available" when you right click on a database in SQL Server Manager and look at properties then you may want to perform a shrink on the database.  Note: The content db grows as data increa...

Very nice article... http://blogs.msdn.com/sowmyancs/archive/2008/11/15/how-to-find-out-the-storage-space-allocation-details-a-site-through-code.aspx

http://support.microsoft.com/kb/827218

This error occurs when you upload a file to a document library through the SharePoint UI and when the document library has an event receiver which updates the list item on ItemAdded(). The error doesn’t happen all the time (for instance, it happened only on our Prod) which lead us to conclude that it is due to some race conditions, especially knowing that event receivers are run in separate thread. The error message is “ The file … has been modified by … on …. ” and the callstack leads to a COMException in the Microsoft.SharePoint.Library assembly, which is the managed wrapper of  OWSSVR.dll . The full stacktrace looks something like this: [COMException (0x81020037): The file abc.doc has been modified by on ] at Microsoft.SharePoint.Library.SPRequestInternalClass.AddOrUpdateItem( String bstrUrl, String bstrListName, Boolean bAdd, Boolean bSystemUpdate, Boolean bPreserveItemVersion, Boolean bUpdateNoVersion, Int32& plID, String& pbstrGuid, Guid pbstrNewDocId, Boole...

Save the following in a file and name it as "cmdhere.inf". Right click the file and say install. Navigate to any folder and right click and you will find an option to open the folder path in command center. Enjoy the tool ============================================== ; ; "CMD Prompt Here" PowerToy ; ; Copyright 1996 Microsoft Corporation ; [version] signature="$CHICAGO$" [CmdHereInstall] CopyFiles = CmdHere.Files.Inf AddReg    = CmdHere.Reg [DefaultInstall] CopyFiles = CmdHere.Files.Inf AddReg    = CmdHere.Reg [DefaultUnInstall] DelFiles  = CmdHere.Files.Inf DelReg    = CmdHere.Reg [SourceDisksNames] 55="CMD Prompt Here","",1 [SourceDisksFiles] CmdHere.INF=55 [DestinationDirs] CmdHere.Files.Inf = 17 [CmdHere.Files.Inf] CmdHere.INF [CmdHere.Reg] HKLM,%UDHERE%,DisplayName,,"%CmdHereName%" HKLM,%UDHERE%,UninstallString,,"rundll32.exe syssetup.dll,SetupInfObjectInstallAction DefaultUn...

I was doing a client implementation and in the process I have to do a SQL restore (48 GB, yes crazy). My customer uploaded the back-up to an ftp site and I tried downloading it from there. I was getting the following error while restore. I did it with three different copy and everytime I got the same issue. ======================================================================= The media family on device 'My_Content_DB.bak' is incorrectly formed. SQL Server cannot process this media family. RESTORE HEADERONLY is terminating abnormally. (Microsoft SQL Server, Error: 3241) ======================================================================= Cause . The backup was corrupted. The file was transferred using FTP in text mode rather than binary mode. Solution . 1.Downloaded Filezilla. 2. Asked my customer to upload it to ftp with the binary option. (Trasfer > changed the Format from Auto to 'Binary'.) 3. The backup file was transferred again using FTP in...

Ok... I had a terrible experience with the Nortel website and couldn;t find out the Contivity VPN download for Windows 7 64 bit. It's insane why they don't have their own product on their website. Anyway, after 10 days of search, I finally found out the latest Contivity Version for Win 7 64-bit machine at the sprint site. It's works like a charm. http://www.sprint.com/business/products/products/popup/popupVpnIndex.html