Lincoln Burrows

I'm a SQL Server DBA. I love to explore my knowledge about SQL Server database and have experience with database administration (installing, configuring, maintenance, transaction log shipping, replication, database mirroring etc) also I like to write blogs about these technologies.

All authors

Steps to Restore Database from Backup File in SQL Server

by Lincoln Burrows

SQL Server Overview

Overview
In most of the cases, users create a backup file of their database on their machine. This help the users...

2018-09-11

1,745 reads

Steps to Restore Database from Backup File in SQL Server

by Lincoln Burrows

SQL Server Overview

Overview
In most of the cases, users create a backup file of their database on their machine. This help the users to perform recovery at the time of any disaster,...

2018-09-11

12 reads

Different Ways to Handle Deadlock in SQL Server

by Lincoln Burrows

SQL Server Overview

Introduction To Deadlock
Deadlock in SQL server is a condition in which two or more system server processes IDS (SPIDs) are...

2018-09-10

2,756 reads

Different Ways to Handle Deadlock in SQL Server

by Lincoln Burrows

SQL Server Overview

Introduction To Deadlock
Deadlock in SQL server is a condition in which two or more system server processes IDS (SPIDs) are waiting for a resource. No process can get the...

2018-09-10

10 reads

Best Way to Fix Corrupted SQLite Database

by Lincoln Burrows

SQL Server Overview

Corruption is one of the common scenarios nowadays. It can occur in any platform or file format, for that matter....

2018-09-07

1,565 reads

Best Way to Fix Corrupted SQLite Database

by Lincoln Burrows

SQL Server Overview

Corruption is one of the common scenarios nowadays. It can occur in any platform or file format, for that matter. Similarly, Android SQLite database can be corrupted due to...

2018-09-07

24 reads

SQL Server Error 5123 Attach Database - Resolution

by Lincoln Burrows

SQL Server Overview

SQL server error 5123 occurs when users want to attach the database, which has been placed on different locations. This...

2018-08-21

35,130 reads

SQL Server Error 5123 Attach Database - Resolution

by Lincoln Burrows

SQL Server Overview

SQL server error 5123 occurs when users want to attach the database, which has been placed on different locations. This error is a kind of permission error that occurs...

2018-08-21

62 reads