Viewing 15 posts - 1 through 15 (of 60 total)
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...
February 19, 2020 at 2:56 pm
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...
February 19, 2020 at 2:07 pm
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".
February 18, 2020 at 9:54 pm
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...
May 1, 2018 at 2:37 pm
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...
May 11, 2017 at 6:48 am
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...
May 10, 2017 at 1:40 pm
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)
May 10, 2017 at 11:11 am
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:
May 10, 2017 at 7:45 am
January 18, 2017 at 2:48 pm
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...
December 22, 2016 at 11:10 am
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...
December 22, 2016 at 10:18 am
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...
January 27, 2016 at 7:20 am
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...
January 26, 2016 at 8:08 pm
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...
January 26, 2016 at 9:44 am
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...
September 23, 2015 at 1:39 pm