sql server

Dennis Faas's picture

How to Fix: Move MS SQL Databases to Another Drive, Partition

Infopackets Reader Philip S. writes: " Dear Dennis, We are running Windows 10 on our office machine which has Microsoft SQL (MS SQL) installed. On that machine we use Microsoft SQL Server Manager to enter in data into our databases, though other ... machines can access the Microsoft SQL databases through the network using MS Access DSN files. A few years ago we hired someone to set up our databases; however, we are now running out of space on the C drive as the databases have grown significantly in size. We would like to move the MS SQL databases and then set up a RAID to make the data redundant ... (view more)

Dennis Faas's picture

How to Fix: The Version of SQL Server Does Not Match Update

Infopackets Reader John R. writes: " Dear Dennis, I'm running Windows 10. For the last week, Windows Update fails every time with this error: 'Critical Update for SQL Server 2016 MSVCRT Prerequisites KB3164398 - Error 0x80070643'. Any idea how to ... fix this? " My response: I have not had this problem before so I asked John if he would like me to connect to his machine using my remote desktop service , and he agreed. The reason for the SQL Server update (KB3164398) failing was an interesting problem, as it was not very obvious. I'll explain more about that further down - for now I'll go through ... (view more)

Dennis Faas's picture

Vista Incompatible with SQL Server

We knew they'd come. Problems for Vista were sure to stand in the way of a flawless launch, which seems just about impossible considering the massive task accorded Microsoft employees in implementing such a major new piece of software. The first ... notable issue is the OS' failure to run the most recent version of SQL Server, a major problem for business who were given the opportunity to use Vista after its launch at the end of November. Microsoft is scrambling to take care of the matter, although a solution probably couldn't come soon enough for business users. In the works is an upgrade to the ... (view more)

Subscribe to RSS - sql server