SQL Server Backups are the dump of its databases that can be used to recover them in case of any corruption, outage or emergency. Backups are essential for data protection. We run SQL Server backups to safeguard our databases from...
I had an AOAG configuration between two replicas that i have deleted in order to perform some activities. I was configuring Always On Availability Group again on this database server. We followed all processes but Listener was failed to create...
A Recovery Model is a database property that designed to control transaction log maintenance. SQL Server Recovery Model does not define how transactions will be logged but they define how transaction logs will be managed in the transaction log file....
Instant file initialization is very useful feature to speedup the process of increasing or allocating data file space of a SQL Server database. Have you ever thought how SQL Server initialized its database files during space allocation? General way to...
Last week, I had a requirement to check the row counts of all the tables present in a database. I used attached article to get the row counts of all tables. We get row counts of all tables using system...
SQL Server Agent is very useful in automating any database activities. By default, it is not installed along with SQL Server on Linux server. You need to manually install it after installing SQL Server. Here I will explain step by...
I have shown you how to install SQL Server on Redhat Linux Server in my last article. Here I will explain step by step process to install SQL Tools on RedHat Linux 7.3 server. Installing SQL Tools will install sqlcmd...
Earlier SQL Server used to run only on Windows platform till SQL Server 2016 version. Now we can host our applications on Linux based SQL Server Instances. Here I will explain step by step process to install SQL Server on...
I got this error during one of the activity when i was not able to perform it because my user was not part of sudoers file. The error details were given as “User is not in the sudoers file. This...
Last week, I had a requirement to check the row count of all tables having a specific schema of databases. I did some search on this because my database has thousands of tables and it was not possible to run...
I explained how to installed RedHat Linux on a virtual machine in my last article. I was not able to connect to this Linux server from PuTTY terminal that was installed on my host machine. Â Everytime i tried to connect...
We had successfully installed SQL Server on this server but we have received error “MMC could not create the snap-in” during launching SQL Server Configuration Manager after a week. I did some google search to fix this issue but nothing...
We must Install .NET framework 3.5 as prerequisite to install SQL Server on Windows Operating System. We need to manually install it before starting SQL Server installation. You can also deploy it by using group policy. Earlier we used to...
SQL Server Agent runs scheduled SQL Server jobs and is very useful to automate database tasks. Here i will show you how to install SQL Server Agent on Ubuntu Linux server. We will use offline method to install SQL Server...
I have described step by step process to install Ubuntu 16.04 Server and Offline installation of SQL Server 2017 on Ubuntu server in my last articles. Here I will explain step by step process to install SQL Server tools (sqlcmd...
