Infrastructure at your Service

Tag

SQL Server Archives - Blog dbi services

Steven Naudet

SQL Server AlwaysOn node “Add all eligible storage to the cluster”

By | Database Administration & Monitoring, SQL Server | No Comments

I made a mistake recently when adding a new node to an existing Windows Failover Cluster supporting AlwaysOn SQL Server instances. When adding a new node using the GUI there’s this option checked by default named “Add all eligible storage to the cluster”.   Before performing the operation the disks on the 2 nodes of my cluster were used by the SQL Server instances. Because I’m using the AlwaysOn features the disks are local on…

Read More
Franck Pachot

Data virtualization on SQL Server with Redgate SQL Clone

By | Cloud, DevOps, SQL Server | No Comments

By Franck Pachot . In the previous blog post I’ve installed SQL Server on the Oracle Cloud. My goal was actually to have a look at Redgate SQL Clone, a product that automates thin cloning. The SQL Server from the Oracle marketplace is ok for SQL Clone prerequisites. There’s a little difference in .NET Framework version (I have 4.6 where 4.7.2 or later is required but that’s fine – if it was not an update…

Read More
Franck Pachot

SQL Server on Oracle Cloud

By | Cloud, Oracle, SQL Server | No Comments

By Franck Pachot . You can create a VM with SQL Server running in the Oracle Cloud. This is easy with a few clicks on the marketplace: Here are the steps I did above: Oracle Cloud -> Marketplace -> Application -> Category -> Database management You have multiple flavors. I’ve chosen the lastest cheaper “Microsoft SQL 2016 Standard with Windows Server 2016 Standard” Select the compartment and “Launch Instance” Choose a name, and the network…

Read More
Steven Naudet

SQL Server Installation Wizard error : Failed to retrieve data for this request

By | Database Administration & Monitoring, SQL Server | No Comments

Today I faced a strange issue when I tried to install a new SQL Server instance : Failed to retrieve data for this request This error occurred just after clicking on “New SQL Server stand-alone installation…” The error message is not helpful at all. So, the first step to troubleshoot an issue is to look at the error logs. The location by default is : C:\Program Files\Microsoft SQL Server\140\Setup Bootstrap\Log There is a summary.txt file…

Read More
Steven Naudet

SQL Server: Change Availability Group Endpoint Ownership

By | Database Administration & Monitoring | No Comments

I’m doing some cleaning on my customer’s instances. I want to delete the login of a previous DBA for 2 reasons; this person does not work anymore in my customer’s company and all DBA are members of a group that is given permission on the instances. I don’t want to see any DBA’s personal login on SQL Server instances. When I try to delete the login I receive the following error; Msg 15173, Level 16,…

Read More
Ali Asghari

Create and configure an Oracle linked server in SQL Server Instance

By | Database Administration & Monitoring, Database management, Oracle, SQL Server | One Comment

What is Linked server ? Now a days in each company we have different applications and each one of them have different needs in term of databases support. When data exists on multiple databases the management become a little bit hard. For exemple moving some data from an Oracle database to a SQL Server database is not easy. A linked servers is configured to enable the Database Engine to execute a Transact-SQL statement that includes…

Read More
Christophe Cosme

AWS – RDS – SQL Server Native backups

By | AWS, Cloud, Database Administration & Monitoring, Database management, SQL Server | No Comments

Introduction RDS provide automatic backup feature. This feature will backup the entire RDS instance. As a DBA sometimes you need to backup individual database, they are many reason for that (legal, migration, replication,…). Unfortunately individual database backups are not available within the RDS instance. This post explains how you can enable the native database backup on RDS , as you are used to with an on-premises SQL Server instance. To summarize we will create a…

Read More
Steven Naudet

SQL Server: Synchronize logins on AlwaysOn replicas with dbatools

By | Database Administration & Monitoring, SQL Server | No Comments

The SQL Server environment  I worked with today has dozens of SQL Server instances using AlwaysOn Availability Groups for High Availability. When a login is created on the Primary replica of an Availability Group it is not synchronized automatically on secondary replicas. This might cause some issues after a failover (Failed logins). Since this is not done automatically by SQL Server out of the box the DBA has to perform this task. To avoid doing…

Read More
Ali Asghari

Install & configure a Nagios Server

By | Database Administration & Monitoring, Oracle, SQL Server | No Comments

What is Nagios ? “Nagios is a powerful monitoring system that enables organizations to identify and resolve IT infrastructure problems before they affect critical business processes.” https://www.nagios.org/ In simple words, you can monitor your servers (linux, MSSSQL, etc …) and databases (Oracle, SQL Server, Postgres, MySQL, MariaDB, etc …) with nagios.   We use the free version !!! 😀   VM configuration : OS : CentOS Linux 7 CPU : Intel(R) Xeon(R) CPU E5-2620 v4…

Read More
Stéphane Savorgnano

Use MABS to protect Hyper-V on-premises VMs workload

By | Cloud, Database Administration & Monitoring, Database management, SQL Server | No Comments

During my last blog post I explained how to installed a MABS. Now that your infrastructure is setup you will be able to protect the workload of your Hyper-V Virtual Machines. You have first to create a new protection group. This group will contain one or more VMs which will share the same backup configuration for retention, synchronization and recovery. Protection is managed as follow: DPM create a copy of the selected data on the…

Read More