1

Topic: Question about differential

Kind time of days!
Every week becomes Full , and every day becomes Dif , all works well! But began to note that for the sixth day differential , on volume increases in 4 times from the last. Who can faced, in what there can be a problem?

2

Re: Question about differential

Kamenyka;
Well that you do a question for 6 day. Indexes there rebuild

3

Re: Question about differential

Kamenyka;
In that it kol-in changes of the past from the moment of full full backup, the more  the is more than changes weight, all is logical.  in any way, only to watch when easier to make full. In 2017  in sys.dm_db_file_space_usage a new field modified_extent_page_count, on its basis it is possible to create the decision what type to do, but  it at many costs.

4

Re: Question about differential

TaPaK wrote:

aleksrov
In that it kol-in changes of the past from the moment of full full backup, the more  the is more than changes weight, all is logical.  in any way, only to watch when easier to make full. In 2017  in sys.dm_db_file_space_usage a new field modified_extent_page_count, on its basis it is possible to create the decision what type to do, but  it at many costs.

Microsoft SQL Server 2008 R2 (SP1) - 10.50.2500.0 (X64)

TaPaK wrote:

Kamenyka;
Well that you do a question for 6 day. Indexes there rebuild

Gain of the data in a DB it was not watched (checked up as a smog) + a problem always in a certain 6 bottom! Concerning indexes and . it is idea! The server accepted 3 months ago now occasionally , etc.

5

Re: Question about differential

Kamenyka;
And where .  for 17th?

6

Re: Question about differential

iiyama;
Occurs every week on Monday, Tuesday, Wednesday, Thursday, Friday, Saturday at 1:00:00 AM.
Under the schedule does not become, unless in it there can be a problem? I can do Dif () for example 1 time in two and even in three days!?

7

Re: Question about differential

Kamenyka;
I assumed that 17th at you and happens "something" that increases the expected size in 2 times

8

Re: Question about differential

Kamenyka;
Any action on the server implies itself validity and purpose achievement and if at you are intentionally disconnected  in one of days and it does not disturb you, this action  means and carries certain advantages comparable or exceeding risks of loss of the data that indirectly proves to be true in 18th size . Yours TO

9

Re: Question about differential

iiyama wrote:

Kamenyka;
Any action on the server implies itself validity and purpose achievement and if at you are intentionally disconnected  in one of days and it does not disturb you, this action  means and carries certain advantages comparable or exceeding risks of loss of the data that indirectly proves to be true in 18th size . Yours TO

Well do not do  on Sunday, dissolved here snivels

10

Re: Question about differential

iiyama;
At present dug out that 17 it becomes Full , but too !
"A nonrecoverable I/O error occurred on file" \\dbco-p1-r\Backup\dbco-p1\MarketCOCrimea\MarketCOCrimea_db_201709170200.BAK: "112 (failed to retrieve text for this error. Reason: 15105). [SQLSTATE 42000] (Error 3271) BACKUP DATABASE is terminating abnormally. [SQLSTATE 42000] (Error 3013). The step failed."
It becomes on the main server and exe () is copied in the finite directory "" \\dbco-p1-r\Backup\dbco-p1\MarketCOCrimea \"on a reserve.
The campaign does not have no place! And if it was re-recorded that of problems with Dif would not be.
But why grows so Dif all the same while a riddle.

11

Re: Question about differential

TaPaK wrote:

well do not do  on Sunday, dissolved here snivels

Just also do full on Sundays.
Look, previous full was 10/09.
And 17/09, seemingly, broke off.
Here also it is necessary to search, why.
And do full on Sunday explicitly after remaining maintenance that is logical.
Only this Sunday the full did not make;
Here all consequences maintenance and  the differential

12

Re: Question about differential

o-o;
To the fortuneteller not to walk, look that becomes 16-18 smile
And generally sounds as everyone 6 day at it so

wrote:

But began to note that for the sixth day differential , on volume increases in 4 times from last

13

Re: Question about differential

TaPaK wrote:

and generally sounds as everyone 6 day at it so
it is passed...

That's it that only "sounds"
At first let shows statistics more, than for a week.
For its indications do not converge.
At first writes, the full once a week.
And on a picture that?
Was not that week absolutely.
Ask it, well and where for 17th?
"Instead of we do also all here".
And actually we do, it is drawn full 10/09.
So I trust pictures more

14

Re: Question about differential

o-o;
That already told that 17 fell off, as you wrote all, all dances of the day off left in diff

15

Re: Question about differential

TaPaK;
Sorry. He wrote simultaneously with me, means.
While all foolish pictures  (gray  do not believe that they too people);
Here events are torn

16

Re: Question about differential

Well all rose on the places, because of   , grows , the question why on is so much ! Remains opened (but I think hardly who can precisely answer it).
Problem all the same it appeared with shortage of a place on a disk.
Many thanks to all responded! "I congratulate a crime it is uncovered!" ()
P.S Though and not completely smile

17

Re: Question about differential

Kamenyka;
You precisely do not want to look that becomes on Saturday-Sunday in ? Well and it is fine.

18

Re: Question about differential

TaPaK;
Forgot to write litter, neither that "criminal" not re-structurings of indexes, nor evolutions of tables, import of great volume of the data and .
Maximum cleaning of auxiliary tables and dens.

19

Re: Question about differential

Kamenyka wrote:

the Maximum cleaning of auxiliary tables and dens.

And what total volume of the cleared?

20

Re: Question about differential

o-o;
No more 150 records because of all tables (nearby 10).

21

Re: Question about differential

Kamenyka wrote:

Forgot to write litter, neither that "criminal" not re-structurings of indexes, nor evolutions of tables, import of great volume of the data and .

And it very much in vain. If the system is actively used, certain  it would be quite good to lead. Well this your business, certainly.
Yes, also check up service plans, on them  not always it is possible to define that there becomes actually - it is necessary to glance in the plan - there and evolution of indexes can be.