Brainlitter - Inside the mind of Sean Wallbridge

Dad. Husband. Drummer. Learner of Things.

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 on

SQL 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 on

Error 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 on

Massive 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 on

Considerations 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 on

I’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 on

Resources 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 on

Default (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 on

How 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 on

BrainLitter – 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