January 20, 2015 at 6:25 pm
Hi All,
It's been a while since I posted anything in here 🙂
I have a Customer running a database in an Availability Group and I am not familiar with the set up...
They have a transaction log that quadrupled in size during a data import and update which was generated by an external application. They have limited server space and would like to shrink the log again now as this import / update only happens once a year. The way this has always been dealt with in the past was by shrinking the DB and logs after the update.
Now however, when attempting to do a log or db shrink, an error message is generated which says that the log cannot be shrunk as the DB is in use as part of an Availability Group....
The more I search and try to read up on this subject, it looks like the DB has to be removed from the Availability Group before the log can be shrunk and then the Availability Group has to be re-created or restored in some way.
Is there a simple solution to this conundrum?
Thanks in advance.
Steve
Steve
We need men who can dream of things that never were.
January 22, 2015 at 9:59 am
Anybody?
Steve
We need men who can dream of things that never were.
January 29, 2015 at 10:29 am
Hi All,
This is very unusual that a question is posted in SSC and it gets absolutely zero constructive replies.... It's definitely a first for me.
Ste_P
Steve
We need men who can dream of things that never were.
February 1, 2015 at 7:31 am
would help if you posted it in the correct forum location 😉
What version\edition of SQL Server are you using?
How many databases are in the availability group?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 2, 2015 at 10:11 am
Hi Perry,
Which forum would you have expected this post to go in? :ermm:
This is a Customers system and the availability group is set up on one server running SQL2008R2 with four or five databases on the server...
Best regards
Steve
Steve
We need men who can dream of things that never were.
February 3, 2015 at 9:30 am
Ste_P (2/2/2015)
Which forum would you have expected this post to go in? :ermm:
Ste_P (1/20/2015)
I have a Customer running a database in an Availability Group and I am not familiar with the set up...
Since this is a SQL Server 2012 or 2014 feature i would expect it in one of those forums!!
Ste_P (2/2/2015)
This is a Customers system and the availability group is set up on one server running SQL2008R2 with four or five databases on the server...Best regards
Steve
See above
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 3, 2015 at 9:47 am
Sorry about that Perry, I was absolutely convinced that they were running SQL2008R2 - I will move the thread to the 2012 forum...
Best regards
Steve
Steve
We need men who can dream of things that never were.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply