Articles by SATNAM SINGH

Transactional Replication – Unable to Replicate Data onto the Subscriber – A Practical Example

Scenario: A couple of days back, I got a call from one of my users saying that the Data is not being replicated properly onto the Production Reporting Server from the Production OLTP server. We have Transactional Replication scheduled for every 15 minutes between...

Recovering a SQL Server Database from Suspect Mode

By satnam singh

A couple of days back at I got a call from my support team informing me that one of our database located on the Production Server went into Suspect Mode. The version used was SQL Server 2005 Service Pack 3. Being a Production Database server, it was a Priority...

Understanding SQL Server 2008 R2 Fixed Server Roles – Part 1

By Satnam Singh

When considering the security and protection of the database engine, one of the first considerations that comes to mind is SQL Server Fixed Server Roles. The Server Roles are named Fixed Server Roles as the user cannot alter these under any conditions. Assigning...

Controlling Growth of a msdb Database

By Satnam Singh

I recently encountered a situation where the drive hosting Sharepoint Databases in a Staging environment ran out of space. I logged onto the server and found that the msdb database has itself occupied 38 GB of the total disk space. Msdb database generally contain...

Backing Up a SQL Server Database Directly Onto a Remote Server

By Satnam Singh

Recently I encountered a situation where the backup drive was short of space on the production server. The policy on the production server was that as soon as soon as the Full Backup is complete, a copy of the production backup is transferred to the staging...

Restoring a SQL Server Database – A Practical Example

By Satnam Singh

Performing a Database Restore is a part of a DBA’s daily life. A DBA may need to perform a Restore due to various reasons such as recovery, refreshing a database for testing purpose etc. Many times it can be difficult to perform a Restore due to corrupted...

Understanding SQL Server 2008 R2 Fixed Server Roles – Part 1

By Satnam Singh

Whenever we talk about securing and protecting our database engine, the first thought which strikes our mind is SQL Server Fixed Server Roles. The Server Roles are called as Fixed Server Roles because the user cannot alter those under any conditions. Assigning...

Moving SQL Server System Databases

By Satnam Singh

I was recently examining the configuration of one of our production database servers. This server was involved in Merge Replication. All the database files on this server were dumped on one small SAN drive. The replication cleanup job for some reason was unable...

Configuring Email in SQL Server 2000

By Satnam Singh

A couple of days back I was asked to configured database email for a DB Server which was hosted on a SQL Server 2000 environment. Configuring a database email in SQL Server 2000 is somewhat different than the SQL Server 2005 environment as there is no GUI available...