Tag: SQL Server

SQL Server Remote Blob Store (RBS) available as part of the Feature Pack RC0 for Microsoft SQL Server 2008

As I mentioned in a previous blog post at http://blogs.technet.com/josebda/archive/2008/03/17/sql-server-2008-and-unstructured-data.aspx, SQL Server 2008 introduces new options to store unstructured data, in addition to the current BLOB support we have in SQL Server 2005. One of those options is the new SQL Server Remote Blob Store, a method for storing blobs of unstructured data in a … Continue reading SQL Server Remote Blob Store (RBS) available as part of the Feature Pack RC0 for Microsoft SQL Server 2008 →

The Legend of the Single, Multi-Terabyte, Replicating SharePoint Database

Documents in Databases The first time I tell anyone that SharePoint Server 2007 stores documents as blobs (binary objects) in the database, people stare at me for a few seconds and usually ask: "Really?" It takes a few moments to explain that this is actually a good thing and that SQL has no problem handling … Continue reading The Legend of the Single, Multi-Terabyte, Replicating SharePoint Database →

Configuring SQL Server 2005 Database Mirroring (includes 8-minute demonstration)

SQL Server 2005 Database Mirroring is a high availability feature that maintains a duplicate copy of a database (close by or across the globe), keeps it up to date (synchronously or asynchronously) and can even provide automatic failover. There are other SQL Server technologies that can use be used in similar situations, like database clusters, … Continue reading Configuring SQL Server 2005 Database Mirroring (includes 8-minute demonstration) →

Misleading error 1418 message in SQL Server Database Mirroring

While setting up a four-server database mirroring environment (one domain controller, two partner SQL Servers, one witness SQL Server), I ran across a misleading error message.  The whole process for setting up a database mirror is fairly easy, if you have the right components in place. However, I was missing an important detail and the … Continue reading Misleading error 1418 message in SQL Server Database Mirroring →

Moving a content database from MOSS 2007 Beta 2 TR to RTM

If you're upgrading your MOSS 2007 (Microsof Office SharePoint Server 2007) from Beta 2 TR to the final RTM release, you probably know you should be following the steps described at http://technet2.microsoft.com/Office/en-us/library/3df597d0-bad0-4c73-9c26-a10bb80449881033.mspx?mfr=true However, if you just want to move just MOSS 2007 Beta 2 TR content, there is a simpler way. You can simply move … Continue reading Moving a content database from MOSS 2007 Beta 2 TR to RTM →

Moving your MOSS 2007 databases to a larger drive

I was doing a small Proof-of-Concept with SharePoint Server 2007, using one server for the database (running SQL Server 2005) and another server for SharePoint Server. The problem is that the SysAdmin that installed SQL Server not only installed it on the C: drive but also let SQL creating new database on the C: drive. … Continue reading Moving your MOSS 2007 databases to a larger drive →

Maintaining your MOSS 2007 SQL Databases

If you're running Microsoft Office SharePoint Server 2007 (MOSS 2007), your're also running a SQL Server, hopefully the 2005 version to get the best performance. MOSS will be creating all your databases for your, so you might thing you should not worry about maintaining those databases, right? Not really... Databases need proper care and, if … Continue reading Maintaining your MOSS 2007 SQL Databases →

Steps to configure a basic MOSS 2007 farm

I’m working on a step-by-step procedure to install Microsoft Office SharePoint Server 2007 Beta 2 (MOSS 2007), to allow my customer to create their environment by themselves. The main difficulty they have right now is the exact sequence to follow to get a basic infrastructure for team collaboration with self-service site creation, search and my … Continue reading Steps to configure a basic MOSS 2007 farm →