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