Hi Perry,

Just simply in Management Studio, highlight the primary database, right click - Tasks->Shrink->Files...

I also tried a script...

Just the primary.....

Surely there is enough information in this for a reasonably simple answer?

Ste_P (2/3/2015)

---

Hi All,

I have a Customer running a database in a High Availability Group and I am not familiar...

Anything - anybody?

Hi Perry,

4 Databases

2 Members, 1 Primary 1 Secondary in Synchronous Mode

Secondary not readable

Both are running SQL 2012 (v 11.0.5522.0)

Thanks in advance

Steve

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

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...

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

Anybody?

Spot On! Simple, straight to the point - and makes perfect sense!

Thank you Drew

Cheers dogramone, Stewart and Celko for your responses.

dogramone: I understand that it's a derived column and that is where the problem lies but SS lets me use this derived column...

You should be able to work with something like this. Straight from SS Help 🙂

The following example groups SalesQuota and aggregates SaleYTD amounts. The GROUPING function is applied to the...

You are 100% right Jeff, it is quite a weak routine. Probably why it's undocumented and unsupported...

I liked it, thats why I kept it....

Carlos,

There are some fairly undocumented and more importantly - unsupported - routines. pwdencrypt and pwdcompare.

So use at your own risk.

DECLARE @PINtoEncrypt varchar(255)

DECLARE @EncryptedPIN varbinary(255)

DECLARE @PasswordTest varchar(255)

SET @PINtoEncrypt =...

Hi,

It's always worth seaching the articles and script library before posting a problem...

http://www.sqlservercentral.com/scripts/contributions/900.asp

You normally find eveything you need in there