If you have not run any Transaction Log backups, you will not be able to shrink the Transaction Log. What I suggest:
1. Start doing frequent Transaction Log backups or if you are unable to do that then
2. Change the Recovery Model from Full to Simple and lose the ability to do point-in-time restores.

Only do a DBCC SHRINKFILE as a last resort as it is detrimental to the health of your Transaction Log and therefore your database.

You might have come across a situation when you have Exchange 2013 server in two different sites (Production and DR). After adding the Database copy in ECP console it displays Database copy status unknown for the DR exchange server. Issue is strange…

New Windows 7 Installations take days for Windows-Updates to show up and install. This can easily be fixed. I have finally decided to write an article because this seems to get asked several times a day lately.
This Article and the Links apply to…

This tutorial will show how to configure a new Backup Exec 2012 server and move an existing database to that server with the use of the BEUtility.
Install Backup Exec 2012 on the new server and apply all of the latest hotfixes and service packs. The…

Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables.
Make a table:
Update a specific column given a specific row using the UPDATE statement:
Remove a set of values using the DELETE s…