X-Received: by 10.129.99.131 with SMTP id x125mr12986486ywb.42.1442230335117; Mon, 14 Sep 2015 04:32:15 -0700 (PDT)
X-Received: by 10.182.128.196 with SMTP id nq4mr43379obb.0.1442230335043; Mon, 14 Sep 2015 04:32:15 -0700 (PDT)
Path: csiph.com!au2pb.net!usenet.blueworldhosting.com!feeder01.blueworldhosting.com!border2.nntp.dca1.giganews.com!border1.nntp.dca1.giganews.com!nntp.giganews.com!z77no1024443qge.1!news-out.google.com!n2ni793igy.0!nntp.google.com!kq10no4288410igb.0!postnews.google.com!glegroupsg2000goo.googlegroups.com!not-for-mail
Newsgroups: comp.databases.ms-sqlserver
Date: Mon, 14 Sep 2015 04:32:14 -0700 (PDT)
In-Reply-To: <9c759c9d-2b86-4058-b91f-5f438e6d70fd@hd10g2000vbb.googlegroups.com>
Complaints-To: groups-abuse@google.com
Injection-Info: glegroupsg2000goo.googlegroups.com; posting-host=59.97.90.136; posting-account=OGl9lwoAAAB9SynCE0lMSfQAzYf3_Q3y
NNTP-Posting-Host: 59.97.90.136
References: <9c759c9d-2b86-4058-b91f-5f438e6d70fd@hd10g2000vbb.googlegroups.com>
User-Agent: G2/1.0
MIME-Version: 1.0
Message-ID: <861cce2e-92a1-4854-b908-9ef402173cef@googlegroups.com>
Subject: Re: SQL Server Database encryption_state still says 2 for a 110GB Database for the past one week
From: ashishmindstick@gmail.com
Injection-Date: Mon, 14 Sep 2015 11:32:15 +0000
Content-Type: text/plain; charset=ISO-8859-1
Lines: 4
Xref: csiph.com comp.databases.ms-sqlserver:1941

Thanks it is nice post.
I also refer very helpful and useful article about SQL Server TDE stuck encryption state 4.
Please visit this helpful article.
http://www.mindstick.com/forum/33457/SQL%20Server%20TDE%20stuck%20encryption%20state%204#.VfatFxFViko
http://dba.stackexchange.com/questions/56356/sql-server-tde-stuck-encryption-state-4