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 […]
Tag: Database
I posted about setting a Microsoft SQL Database into ‘read only’ mode as part of an upgrade. Today I need to go back and make some changes on the now legacy system. To handle this request I needed to change back to its normal state, this is when I encountered the error 5120. In the […]
Exchange 2013 has new and impressive administration center that allows you to handle tasks such as mailbox moves. I prefer using the Exchange Management Shell for such a task. Using the following command you can move all mailboxes within a database to your new mailbox database: Get-Mailbox -Database “Source-Database” | New-MoveRequest -TargetDatabase “Destination-Database” To get info […]
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 […]
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 […]