i can remove them from the avail group then change to simple then shrink then add back to avail group however i'd rather not have to do that unless i...

they are all in full recovery as it is a requirement for them being in avail groups

the cammands are below

BACKUP LOG dbname TO DISK='F:\LogBackup\dbname_logbeforeShrink20161228.trn'

dbcc loginfo

DBCC SHRINKFILE (dbname, EMPTYFILE);

ISSUE:

so let me get this straight. I'm running into this same issue. We have about 90 db's in sql server 2014 enterprise avail group. The drive our transaction logs are...

this was from sql server 2008. I'm having the same issue...sorry i copied the above from the 2008 admin forum.

sorry, moving this to sql server 2014 admin area..

so let me get this straight. I'm running into this same issue. We have about 90 db's in sql server 2014 enterprise avail group. The drive our transaction logs are...

I'm hvaving the same issue. Does anyone know how to resolve or point me in the right direction?

everything i'm reading states i need to rebuild the distro DB. i hope there is a better solution. i've got 15 publications on this server and several subscriptions coming from...

That was my though so I moved the data and log file on their own drives. I had several other dbs that were on the same data and log drive...

Attaching last 1000 calls good and bad. I highlighted a few that cause a timeout who’s last elapsed time was over 900000000. I don’t see anything that stands out.

I...

sorry. i created a script to basically do the same thing i'm doing minus the 115 million records in each table and it works properly. I cant script the version...

the first query only tries to read from one table because of the data constraint. This is correct behavior

The second querry tries to read from all of the tables even...

This is a one off and will probably need to be done every 2 to 3 years. It's 80 percent one table. I'm going to be breaking the table out...

Simple mode. Transaction log isn't the issue. It's the mdf

1 file, primary