Viewing 15 posts - 1 through 15 (of 57 total)
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
We use Avamar 7.1 for our SQL Server Backups. I have implemented Command Line Backups scheduled through our enterprise scheduler. At random times the backups seem to hang...
June 25, 2015 at 12:34 pm
Hello. We didnt end up using that software. We currently use EMC's Avamar for our SQL server backups. We might re-visit recover point in the furture for DR sites.
December 9, 2014 at 1:25 pm
Hello. I am experiencing a similar situation right now.
This is on a clustered SQL Server.
I had the SAN team physically expand a cluster disk/lun.
I had the Windows team expand it...
November 2, 2013 at 7:11 am