How to repair a suspect DB in MSSQL

Issue You have a database in MS SQL that is tagged as (suspect) and you are unable to connect to the database. Possible Causes The database could have become corrupted. There is not enough space available for the SQL Server to recover the database during startup. The database cannot be opened due to inaccessible files… Continue reading How to repair a suspect DB in MSSQL

Full-Text Search with PDF documents in SQL Server 2014

Full-Text Search is a powerful engine when it comes to in-text searching. Some time ago, I made a quick tutorial of Full-Text Search basic functionalities. It was based on indexing a VARCHAR column which is the most popular case, but there are other. For example, PDF documents may be stored in a database and used for… Continue reading Full-Text Search with PDF documents in SQL Server 2014

Shrinking the transaction log of a mirrored SQL Server 2014 database

Well, technically it is possible to shrink a mirrored LOG. What is doing trouble is to backup log with truncate_only. Mirroring doesn’t accept it. So one way is to perform a backup log to disk: USE [DATABASE_NAME]; BACKUP DATABASE [DATABASE_NAME] TO DISK=’E:\Backup\DATABASE_NAME_FULL.bak’ WITH FORMAT; CHECKPOINT; WAITFOR DELAY ’00:00:02′; BACKUP LOG [DATABASE_NAME] TO DISK = ‘E:\Backup\DATABASE_NAME_TL.trn’;… Continue reading Shrinking the transaction log of a mirrored SQL Server 2014 database