36 articles
You can set up backup in SQL Server Management Studio just as usual. But some errors may occur during the process, like Operating system error 3 (The system cannot find the path specified) and Operating system error 5 (Access is denied).
When you try to browse the backup files from SQL Server Management Studio, you will find only the local drives are shown as shown below: In order to make a network share visible to SQL Server, it should be mapped…
Backing up beforehand can avoid accidental deletion or corruption of SQL database. But when it’s comes to system failure or computer breakdown, a backup on local drive is pointless. That’s why you need to backup SQL database to remote location…
To complete this tutorial, you need to: Have SQL Server 2016 or later. Enable the TCP/IP protocol, which is disabled by default during SQL Server Express installation, by following the instructions in the article How to Enable Remote Connections to…
SQL Server 2016 (13.x) supports upgrade from the following versions of SQL Server: SQL Server 2008 SP4 or later SQL Server 2008 R2 SP3 or later SQL Server 2012 (11.x) SP4 or later SQL Server 2014 (12.x) SP2 or later…
Like any other piece of software, Microsoft SQL Server needs to be kept up to date. Microsoft routinely releases service packs for SQL Server that must be installed. Below is the step by step guide on Installing the Service Pack…
Below is a consolidated list of SQL Server and related stuff links to save you time when you need to download a product. SQL Server 2019 On-Premises 180 Day Free Trial – Download Now (Requires Form Completion). SQL Server 2017…
As a person administering or supporting a SQL Server install base you will get asked this question very frequently: Which build of SQL Server are you using ? 1. Connect to the instance of SQL Server, and then run the…
This article describe the procedures to determine the version of SQL Server that is running on a given system. 1. Connect to the instance of SQL Server, and then run the following query. select @@version The output of this query…
SQL Server 2016 (13.x) supports upgrade from the following versions of SQL Server: SQL Server 2008 SP4 or later SQL Server 2008 R2 SP3 or later SQL Server 2012 (11.x) SP4 or later SQL Server 2014 (12.x) SP2 or later…