Popular Posts

  • Error: 18056, Severity: 20, State: 23
    SQLServerCentral » Latest topics Error: 18056, Severity: 20, State: 23 Hi.. Error: 18056, Severity: 20, State: 23. Message The clie...
  • sp_helpindex2
    SQLblog.com - The SQL Server blog spot on the web sp_helpindex2 --my extension of sp_helpindex: sp_helpindex2 USE master GO IF EXIS...
  • SSMS for Linux
    SQLServerCentral » Latest topics SSMS for Linux I can't find information on the Web about whether Microsoft plans to develop an...

SQLblog.com - The SQL Server blog spot on the web

Loading...

Thursday, November 30, 2017

SQL server 2008 R2 frequent transaction log full and my database is a mirrored one.

SQLServerCentral » Latest topics
SQL server 2008 R2 frequent transaction log full and my database is a mirrored one.
I have 1 pair of identical server with SQL server 2008 R2 is installed.I have 2 databases in it which are mirrored.
Frequently I am facing disk full issue as the transaction logs gets full frequently. (with in 5 days it becomes 260 GB for 1 database).
at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)