1

Topic: To recover a database without

Good afternoon, colleagues.
Situation:
There is a basis 1 + DBMS MS SQL 2014.
It is presented by two files main.mdf and main.ldf.
To ms sql I personally have no access.
The information from administrators - basis  is damaged, namely the file of basis  is damaged.
The input in a configurator 1 is impossible.
I.e. the basis is damaged on what level more deeply 1.
:
What operations procedure for recovery of this basis if to consider that any  did not form - generally;
Neither full, nor the difference, transaction logs.
. Number 2:
As the broad gull a file permanently expands, if it not to compress, I can assume that it can be used for recovery - and as to what it to add, it is necessary to make any initial .
Whether it is necessary to translate  the broken basis in  a mode, to make  - what???
To it  to fasten just made  a broad gull?
What generally sense have old for a long time  the data in a broad gull a file, if a file not .
Or a broad gull a file it is simple possibility to be recovered for the necessary moment of time in certain cases and no more that.
And basis to recover in case of its breakage and absence  it is necessary only with the help ?
_______________

2

Re: To recover a database without

Gokusa wrote:

if to consider that any  did not form - generally;
Neither full, nor the difference, transaction logs.
...
As the broad gull a file permanently expands, if it not to compress, I can assume that it can be used for recovery - and as to what it to add, it is necessary to make any initial .

You are confused in indications.
If the broad gull permanently grew, it would seem;
The basis model should be full.
But: the model cannot be full if full has not been made  bases.
Total: clarify, what model at you and where full .

3

Re: To recover a database without

Yasha123;
I do not understand.
The broad gull grew and grew.
is not present.
Upon now there is a broken basis  two files
and a broad gull.
No other files are present.
It is necessary to recover basis.
.
For what the broad gull in this case - it generally is necessary is necessary for something, or it is possible to throw out it safely?

4

Re: To recover a database without

Yasha123 wrote:

but: the model cannot be full if full has not been made  bases.

???? I do not understand.
is not present.
Any  is not present, there are only two files  and .
.
for something it is necessary or not to work with it on a recovery subject?

5

Re: To recover a database without

Yasha123 wrote:

but: the model cannot be full if full has not been made  bases.

It ,  checked up just.
The model can be full at absence , and presence of a broad gull 1.5  and the basis of 10 Mb.
The item with. Somehow it is possible to correct the previous message?

6

Re: To recover a database without

Gokusa, the log would be necessary, if was . In this case recover  and recover log for the necessary moment of time. But it for the full model of recovery of basis. If basis in simple model rescue only .
If to me storage does not change, 1 includes the full model. If you could compress log, any at you not the full model as wrote above. Or has not been initialized.
No experience of repair of the broken bases I have.

7

Re: To recover a database without

Meant here that.

Gokusa wrote:

as a broad gull the file permanently expands, if it not to compress, I can assume that it can be used for recovery - and as to what it to add, it is necessary to make any initial .

As the broad gull a file permanently expands, so it  and useful and if it not to compress - that probably that is possible to what "" for recovery, differently what for it generally in live basis without , another matter if it to compress - that already "" to what .
I here that meant, and at all that I or someone compressed a broad gull file on the broken basis after its breakage.
Well  as I understood - a broad gull the file is absolutely not necessary for recovery without .
It is true?, also there are no possibilities  basis and to compare then it  somehow under the transaction log?

8

Re: To recover a database without

Gokusa wrote:

it is passed...
It ,  checked up just.
The model can be full at absence , and presence of a broad gull 1.5  and the basis of 10 Mb.
The item with. Somehow it is possible to correct the previous message?

  that at basis the full model thus;
That there was no full .

---
Most likely, at your sizes of basis;
really someone did full;
Simply you do not know about it
---
Well and at last:
If find full , following actions:
Create on the server basis with the same name;
Translate it in  (i.e. alter database... set recovery full + full baackup);
Translate in an offline;
Substitute a broad gull file for yours in 1,5;
Translate basis in online (it does not pass, but it should be made);
Now do  a broad gull with no_truncate
And here after all it recover found full + just removed  a broad gull
---
There is no full  - ask from the one who made it.
Because if it did not do - the basis in  would not pass also a broad gull so did not grow

9

Re: To recover a database without

Gokusa wrote:

as a broad gull the file permanently expands, so it  and useful

About  to argue is to you to the main thing  from , it the expert in combination.
And if on business, once again:
The broad gull so grew because model full,
The full model receive only reguiding in  + FULL  .
And that's it in such conditions in the presence of full  your basis can be recovered

10

Re: To recover a database without

Yasha123;
And unless the DB cannot be created at once in full recovery model?

MSDN wrote:

again created user databases use the same model of recovery, as a database model.

11

Re: To recover a database without

12

Re: To recover a database without

Gokusa wrote:

And basis to recover in case of its breakage and absence  it is necessary only with the help ?

It if basis generally .
You though tried to make it?

13

Re: To recover a database without

Gokusa wrote:

as a broad gull the file permanently expands, so it  and useful and if it not to compress - that probably that is possible to what "" for recovery, differently what for he generally in live basis without

the Server does not know that full  deleted, here it and saves the data in a broad gull.

Gokusa wrote:

well  as I understood - a broad gull the file is absolutely not necessary for recovery without .
It is true?, also there are no possibilities  basis and to compare then it  somehow under the transaction log?

If the basis is connected, it is possible to try to make full , then  a broad gull, and then already to be recovered for the necessary moment of time.
But it works, if basis whole, and it is necessary to roll away changes simply. If basis beaten hardly it turns out.

Gokusa wrote:

.
For what the broad gull in this case - it generally is necessary is necessary for something, or it is possible to throw out it safely?

in general, yes, it is possible to throw out, if basis beaten, and  is not present.

Gokusa wrote:

Or a broad gull a file it is simple possibility to be recovered for the necessary moment of time in certain cases and no more that.
And basis to recover in case of its breakage and absence  it is necessary only with the help ?

the Broad gull the file is possibility to recover basis for any moment of time, using it together with full .
as the main tool of recovery is not used, this auxiliary means. But sometimes it helps, yes though and it is rare enough.
At absence  the unique tool is tamping of the data anew from primary documents.

14

Re: To recover a database without

All thanks, it was very interesting to learn and check up all.

15

Re: To recover a database without

Gokusa;
And  such foolish why the transaction log at performance  log that is compressed it is not compressed.
I put full, I do full , I write , the log grows, I do  log - it becomes, but the log is not truncated:)))
I transport in simple, I truncate log to 1 Mb.
I do not understand logic ms sql why the log is not truncated at its reserve copying at the full model?

16

Re: To recover a database without

Gokusa wrote:

why the transaction log at performance  log that is compressed, is not compressed.

The log generally is never compressed;
If only it specially not to compress.
Whence all this  imaginations?
Goats and Co?

17

Re: To recover a database without

Yasha123 wrote:

it is passed...
The log generally is never compressed;
If only it specially not to compress.
Whence all this  imaginations?
Goats and Co?

Simply yesterday, there was a basis in it there was a minimum value of log of 1 Mb, he grew to 250 Mb, made it , it became 1 Mb.
Today other basis - also is not possible, in = . To install its minimum size less leaking, and to reduce its yesterday's method.
Well and, the most important thing;
It is reasonable to assume that if the log will grow permanently for years it reaches the tremendous sizes.
Means it is necessary to compress it somehow. (To compress to truncate - me  that a place there was 1 Mb that there at it is inside used not used - me as a customer ms sql feeblly should excite), but now upon is had basis both  log - and  it permanently to translate in  and there to compress -  any.
+
On courses 1 speak - "it is necessary to make  log then it decreases" - at me here hands did not reach to take whom-thread for language and to tell show, always took a word 1 smile))

18

Re: To recover a database without

Gokusa;
Under constant transfer I mean to create the plan in it to write
  to basis 
  .
There is what-thread more pleasant method not  log that it was no more for example 500 Mb, and within the limits of it danced without changing models of recovery of basis?
As there was all not so unambiguously as seemed:)

19

Re: To recover a database without

Gokusa wrote:

it is simple yesterday, there was a basis in it there was a minimum value of log of 1 Mb, he grew to 250 Mb, made it , it became 1 Mb .

But after all this at its finest .
are you,
At the self-criticism moments?

20

Re: To recover a database without

Gokusa;
It is not necessary to truncate, at reserve copying of transaction of log are transferred to a backup copy, and the fixed transactions release a place in log and the server writes to the same file without increasing the sizes needlessly.
Read help not to argue on taste of oysters.

21

Re: To recover a database without

Vladislav Kolosov;
Yes, it there releases, transfers thus a place can not be given, as he disposes of it is ..
Then :
For what the minimum file size of log is necessary.
Apropos vraki - yesterday 100 % after creation  log, the log decreased.
I.e. I managed to deliver 1 Mb in the minimum file size of dens and it there rose and worked.
And such : to be if the log grew till unacceptably big size, and it needs to be reduced.
Without translating in simple model it it is possible to make?

22

Re: To recover a database without

Gokusa wrote:

it is passed...
Simply yesterday, there was a basis in it there was a minimum value of log of 1 Mb, he grew to 250 Mb, made it , it became 1 Mb.
Today other basis - also is not possible, in = . To install its minimum size less leaking, and to reduce its yesterday's method.
Well and, the most important thing;
It is reasonable to assume that if the log will grow permanently for years it reaches the tremendous sizes.
Means it is necessary to compress it somehow. (To compress to truncate - me  that a place there was 1 Mb that there at it is inside used not used - me as a customer ms sql feeblly should excite), but now upon is had basis both  log - and  it permanently to translate in  and there to compress -  any.
+
On courses 1 speak - "it is necessary to make  log then it decreases" - at me here hands did not reach to take whom-thread for language and to tell show, always took a word 1 smile))

Say lies, does not decrease. But  log allows  inactive virtual transaction log files which got in . Or it is possible to delete and reduce them the size of a physical file by truncation operation, but for this purpose it is necessary separately . More skilled companions let correct, if I in turn told lies.

23

Re: To recover a database without

Very bald;
To it all also goes, without separate vanity, I did not find a method it to implement.
All thanks.