Bobcares

WeSupport

Call Us! 1-800-383-5193
Call Us! 1-800-383-5193
Call Us! 1-800-383-5193

Microsoft SQL


How to fix SQL Server Error 916 – Server principal unable to access the database

Wondering how to fix SQL Server Error 916. We can help you.

Often while connecting to SQL Server database using SQL Server Management Studio with limited permissions, we may face Microsoft SQL Server error 916.

Here at Bobcares, we often get requests from our customers to fix similar Microsoft SQL server issues as a part of our Server Management Services.

Today, let’s see how our Support Engineers fix this error for our customers.

(more…)

SQL Server Error 5009 – Different scenarios and Fix

Stuck with SQL Server Error 5009? We can help you.

Recently, one of our customers tried to add a log file to a database and then extend the size of it to a specific value.

He came across SQL Server error 5009 while creating the log file and got the same again while extending the size of this file.

As part of our Server Management Services, we assist our customers with several SQL queries.

In this article, let us see how to fix Microsoft SQL Server Error 5009.

(more…)

Checkpoint process in SQL server – Types in detail

Wondering what the Checkpoint process in SQL server is? We can help you.

Checkpoints are the useful repositories of information and serve best for the recovery of SQL server databases.

When the SQL database server faces an unexpected shutdown or crash, the checkpoint creates a known good point from which the SQL Server Database Engine can start applying changes contained in the log during recovery.

Here at Bobcares, we handle SQL database servers of our customers as a part of our Server Management Services.

Today, we will discuss in detail the types of Checkpoint process in SQL server.

(more…)

SQL Server Memory Allocation Best Practices

Looking for SQL Server Memory Allocation Best Practices? We can help you.

An SQL Server is one of the memory-intensive database systems. And the most resource-intensive operations in SQL Server are DISK IO operations.

The SQL servers use memory to minimize disk IO operations by creating a buffer pool to hold pages read from the database.

SQL Server dynamically acquires and frees memory as required. But if we want to allocate some memory to SQL Server, we can follow the best practices given in this article.

Here at Bobcares we often handle requests from our customers using SQL server as a part of our Server Management Services.

Today, we will see some of the best practices which our Support techs follow while allocating SQL server memory.

(more…)

Perfmon counters for Disk Usage – Top Perfmon counters

Wondering how to use Perfmon counters for Disk Usage? We can help you.

Problems regarding Disk I/O are usually difficult to diagnose and debug. Perfmon disk counters help us to diagnose disk issues.

Here a Bobcares, we use perfmon counters as a part of our Server Management System for our customers using SQL.

Today let’s see some top performance counters to identify SQL server disk bottleneck.

(more…)

Perfmon Counters for memory usage – Top perfmon counters

Wondering how to use Perfmon Counters for memory usage? We can help you.

Memory is one of the important system resources that SQL Server uses to process their transactions. Sometimes, the server will face memory issues which in turn reduces the performance of running transactions.

We can use Windows PerfMon utility to gather current values of all given performance counters. This will help us to get a better understanding of the memory usage in the server.

Here a Bobcares, we use perfmon counters as a part of our Server Management System for our customers using SQL.

Today let’s see some top performance counters to identify SQL Server Memory pressure.

(more…)

Microsoft SQL server error: 18470 – How we Fix

Stuck with Microsoft SQL server error: 18470? We can help you.

The SQL Server Error:18470 mainly occurs when the SA (System Administrator) user account is disabled in the SQL Server. Enabling SA user account helps to fix this error

Here at Bobcares we often get requests from our customers to fix similar issues as a part of our Server Management Services.

Today, let’s see how hour Support Engineers fix this SQL server error for our customers.

(more…)

How to Identify and fix Orphaned users in SQL Server?

Orphaned users in SQL Server occurs when a database user is based on login at the master database. But the login doesn’t exist at master. Normally, this happens while taking a database backup from one server and restoring it to another server (Mostly during DB migration).

Here at Bobcares, we have seen several such SQL related queries as part of our Server Management Services for web hosts and online service providers.

Today we’ll take a look at how to identify and fix Orphaned Windows users in SQL Server

(more…)

Types of SQL server backups

We run SQL Server backups to safeguard our databases from user errors, media failure, hardware failure, etc. There are multiple types of SQL server backups.

As part of our Server Management Services, we assist our customers with several SQL Server queries.

Today, let us look into the details of SQL Server backups and how to perform them.

(more…)