Thanks Anthony.

We do our Full and Transaction log backups already on the Primary. So we do not have to worry about the truncating the logs.

We wanted to take additional backups...

Thank you all for the responses.

We do regular TRN backups on the Primary, so no need to worry about log growth.

I am able to SUCCESSFULLY  take a log backup on...

Hi Michael.  I agree.

I verified one more time.

select sys.fn_hadr_is_primary_replica ( 'xxxxxx' )    -----> this returned   0

(1 row(s) affected)

Also the AG group under "Availability Groups" in the Object Explorer shows "Secondary".

BACKUP...

Thanks Mike.
I did get that far with the Microsoft documentation however  What I was looking for was a better explanation of what each value meant in relation to the...

Jacob, thank you for your example.
In our case the application does add columns to this table. 
We receive the "Cannot create row of size" error when attempting to update...

Thanks Lynn.
I suspect the number of pointers must be  substantial since the non-nvarchar data was only giving me a possible total of 2300 bytes.
I have already given the development...

Brandie, Gail,  Thank you for your responses.

My initial calculations of non nvarchar fields totaled approx 2321 Bytes.
(not including any Bytes for Pointers, not sure how to get that number)

I...

Thank you Gail for the response!
We use snapshot databases for reporting. I proceeded to drop them and tried an alter/rebuild on the table and received the
same error:

Msg...

One thing I didn't mention is that users use Link Server heavily on this machine.

The Link is using Sybase OLEDB.

This could very well be the culprit.

I have lowered my max...

Thanks for your response!

Of all my sql agent jobs that run only one takes a while. My DBCC CHECKDB runs about 3-4 hours, however it was not running during this...

There are dedup processes that happens on the client that doesn't require the entire database to be sent to the Avamar Storage. So when you see 7.5% new, only...

I think depending on the version and level of access you can see on one of the admin screen percent free of the entire allocated storage whether Grid storage or...

Hello.

As I understand it the dedup in Avamar is based on your entire backup pool.

So it will use deduplication not only based on the database being backed up but also...

I have been using avamar for SQL about 2 years. Initially we used the Avamar with the built in grid storage.

We didn't use the avamar scheduler to run SQL...