Groups > comp.databases.ms-sqlserver > #581

Re: SQL Server Database encryption_state still says 2 for a 110GB Database for the past one week

Path	csiph.com!x330-a1.tempe.blueboxinc.net!usenet.pasdenom.info!weretis.net!feeder4.news.weretis.net!eternal-september.org!feeder.eternal-september.org!.POSTED!not-for-mail
From	Erland Sommarskog <esquel@sommarskog.se>
Newsgroups	comp.databases.ms-sqlserver
Subject	Re: SQL Server Database encryption_state still says 2 for a 110GB Database for the past one week
Date	Sat, 30 Jul 2011 00:09:10 +0200
Organization	Erland Sommarskog
Lines	28
Message-ID	<Xns9F3218E331B5Yazorman@127.0.0.1> (permalink)
References	<9c759c9d-2b86-4058-b91f-5f438e6d70fd@hd10g2000vbb.googlegroups.com> <Xns9F2E94E1C40C3Yazorman@127.0.0.1> <f9add072-4e2e-4954-b456-492328a7ecf8@v12g2000vby.googlegroups.com> <Xns9F30EBD9E522CYazorman@127.0.0.1> <725c3d02-5ff7-4c64-b3bd-2731632b6618@a4g2000yqg.googlegroups.com>
Mime-Version	1.0
Content-Type	text/plain; charset=windows-1252
Content-Transfer-Encoding	8bit
Injection-Info	mx04.eternal-september.org; posting-host="DD6dU+BfJNjsjSP4/K/V7w"; logging-data="13041"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX18mYHwJVqhpPWu04+sQ823u"
User-Agent	Xnews/2006.08.24 Mime-proxy/2.1.c.0 (Win32)
Cancel-Lock	sha1:Aw+ptcVr+G6qWzFLXdpx/Q/+T4c=
Xref	x330-a1.tempe.blueboxinc.net comp.databases.ms-sqlserver:581

Show key headers only | View raw

Query Builder (querybuilder@gmail.com) writes:
> I do not have any long running transactions. DBCC OpenTran did not
> return any transactions. I do have mirroring enabled and i see that
> the databases are synchronized and no pending logs to be applied on
> the DR.

And you are not using replication?

Paul's response indicated that the log has to wrap. Could it be that the
transaction log is very big in relation to the update activity in the 
database?

> I am worried in the event of a DR, will I be able to fail over and
> make sure the DB will not get corrupt?

I don't know, but what do I know, is that you need to test anyhow,
no matter the state is 2 or 3. That is, you need to know that you 
understand the procedure in case of a failover, and that the databases
are still accessible after a disaster. It seems like a good idea to
first test with one of the other databases.

-- 
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx

Back to comp.databases.ms-sqlserver | Previous | Next — Previous in thread | Next in thread | Find similar

Thread

SQL Server Database encryption_state still says 2 for a 110GB Database for the past one week Query Builder <querybuilder@gmail.com> - 2011-07-25 20:39 -0700
  Re: SQL Server Database encryption_state still says 2 for a 110GB Database for the past one week Erland Sommarskog <esquel@sommarskog.se> - 2011-07-26 14:38 +0200
    Re: SQL Server Database encryption_state still says 2 for a 110GB Database for the past one week Query Builder <querybuilder@gmail.com> - 2011-07-28 06:26 -0700
      Re: SQL Server Database encryption_state still says 2 for a 110GB Database for the past one week Erland Sommarskog <esquel@sommarskog.se> - 2011-07-28 23:11 +0200
        Re: SQL Server Database encryption_state still says 2 for a 110GB Database for the past one week Query Builder <querybuilder@gmail.com> - 2011-07-29 12:41 -0700
          Re: SQL Server Database encryption_state still says 2 for a 110GB Database for the past one week Erland Sommarskog <esquel@sommarskog.se> - 2011-07-30 00:09 +0200
  Re: SQL Server Database encryption_state still says 2 for a 110GB Database for the past one week ashishmindstick@gmail.com - 2015-09-14 04:32 -0700

csiph-web