Categories
How-To Software Technical

Install Microsoft SQL on Linux – Ubuntu Server

I recently had the pleasure of installing Microsoft SQL Server on Linux – Ubuntu Server. This was a very straight-forward installed and just works. The following steps are what were taken to install and configure this server. My Setup: Ubuntu 17.10 Server – VMware Template Network Connectivity SQL Server Management Studio 17 – Testing connectivity […]

Categories
How-To Technical

Query SQL for Version, Edition and Number of CPU’s

The following will give you information about an Microsoft SQL Server instance which you may find helpful in determining the version, edition and number of cpu’s assigned to a SQL server. In my case I am using Microsoft SQL Server 2014 Express but this will work on all  versions of Microsoft SQL Server   SELECT […]

Categories
How-To Software Technical

Set SharePoint Content Database in Read-Only Mode

This weekend I am working on a SharePoint 2010 to 2013 upgrade. One of the steps; the beginning steps I will do is set the databases I am upgrading into read only mode to prevent users or automated process from upgrading the database during the upgrade window. Now I could have taken the system offline […]

Categories
How-To Software Technical

restore sql server database from mdf file

First Open SQL Server Management Studio (SSMS). You may need to run as Administrator Right click the Databases folder and select attach from the menu. Click Add and select the mdf file. Click Ok, and then Click Ok again. You will get an error at this time because SSMS could not find the corresponding ldf […]

Categories
Software Technical

SQL Server Database Error: 661

One of my customers had an issue where they failed to open a connection to a particular database they had been testing. The error read: ‘the database e:somepathsomefolderjermsmit.mdf’ cannot be opened because it is version 611. The server supports version 655 and earlier. A downgrade path is not supported. This issue is caused because you […]

Categories
How-To Software Technical

SQL Server backup in multiple parts

“It’s so logical and so simple. Fat is the backup fuel system. The role it plays in the body is that when there’s no carbohydrate around, fat will become the primary energy fuel. That’s pretty well known.” – Robert Atkins Recently I have been working with my dB Administrator to get some DR backups to our […]