Latest Posts
Resolution to strange SharePoint SQL Database Restore Problem
The Requirement A customer had quite the mess of a SharePoint farm. Efforts are being made to clean it up … but in the meantime, they required a backup of a SharePoint Content Database (from 5 days ago) to be restored into a new (temporary) Web Application to retrieve some old data. Typically, this would …
Read onSQL Keywords Reference (RESERVED)
I ran into a situation today where I had a beautiful plan, diagrams and naming convention all set to go, for a new 4 FARM SharePoint Implementation. I had planned on having two SQL Instances created, one called INTERNAL (Intranet, etc.) and one called EXTERNAL (Internet/Public, etc.). The problem is, after creating the …
Read onError 193: 0xc1 – Weird but solved!
This is an old post that I’m refreshing as I noticed it was appearing in search results (but on my old blog, I got TONNES of people saying this helped them, so I’m hoping to do that again by bumping this to the top…) Ok, this one took a while to sort out and …
Read onMassive SQL ERRORLOG – Regain Control
If you have a massive, giant, huge, big (throwing the words in there, for folks on Google to find this post 🙂 SQL ERRORLOG file, you will want to do TWO things (don’t just perform step #2, it will likely be back!) SQL ERRORLOG growth, when it starts, will grow quickly. I’ve seen it fill …
Read onConsiderations for storing files larger than 50MB in SharePoint
This question was raised in our little Canadian MVP circle today and I figured if I took the time to reply to the email, I could take the time to post the answer to the blog as well. So… the default maximum file size for uploading to SharePoint is 50MB. This is of course very …
Read onI’m now an SharePoint MVP – How cool is that?
Well, what do ya know? Apparently, Microsoft loves, my love for SharePoint (and all those other related things I do – SharePoint, Windows Server, Exchange, SQL, IIS, ASP.NET – you know, all those things that SharePoint works with – I think I was ‘built’ to be a SharePoint Guy). I was awarded with …
Read onResources for Moving SharePoint Databases
The following links have been assembled to assist anyone trying to move SharePoint Databases in either WSS 3.0 or MOSS 2007. Move all databases (Windows SharePoint Services 3.0) http://technet.microsoft.com/en-us/library/cc512723.aspx Move content databases (Windows SharePoint Services 3.0) http://technet.microsoft.com/en-us/library/cc287899.aspx Add, split, and merge content databases (Windows SharePoint Services 3.0) http://technet.microsoft.com/en-us/library/cc825325.aspx Move all databases (Office SharePoint Server …
Read onDefault (Basic) Databases used by SharePoint Versions
First off, I never install SharePoint (WSS or MOSS) with the default configuration. This would leave me without the ability to grow a farm (and if we implement SharePoint right for an organization, its popularity and use with grow and if it makes us profitable, we’ll need to grow it – as my old boss …
Read onHow to whack massive ERRORLOG (errorlog1, errorlog2) files
You can do it the hard way Stop/Start SQL Server to release current ERRORLOG files and then delete them from C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLLOG or wherever they might be Or, you can… Do it the easy way Recycle the Error Logs, by running the following SQL Query command… DBCC ERRORLOG Such as…
Read onBrainLitter – Now you can give Beers of Thanks
Beer Me! Ok, I’ve been told I’ve helped a number of people, over the years, with my postings (in newsgroups and such) and my blog (blog.brainlitter.com). And people always tell me oh, I owe you a beer”, or “if you were nearby, I’d drop you a six pack” or “if you are ever in …
Read on