This has a particular case: If you have the file of a single occurrence issue. This file has 50MB volume, and the byte that your whole database is running to a few have about, if such word can reinstate the sentence of singular failure file what show is very significant. A scene that such thing happens is when the file or file group is on alone driver, and driver appeared problem. Normally, restore individual file merely or file group can make total stopping time shortens, because it decreased apparently,need resumptive total data bulk.
Why don't you choose so do? This has a few reasons:
You need to clerical log backs up. If you want to restore a file from inside backup or file group, the work that you also need to restore to be founded together with them at the same time records backup, make whole database can be in a consistent position thereby. Mix in SQL Server 2000 2005 in, you need to use Full Recovery or Bulk-Logged Recovery mode (not be Simple Recovery) will make it becomes a possibility that is to say. The person that I should point out the implementation of SQL Server people the effort that did not use up them will finish judgement from back up last time a file or the function that whether had been file group revised. If was not changed, so clerical record is without what necessary. But, as a whole, still need general affairs to record backup, if you return what neither one backs up general affairs is recorded to restore to perhaps back up now,plan, so found now.
The document that wanting to restore or abhorrent sex makes the data between the other form in the form in file group and database an issue that needs a consideration. If you have mutual between dependent form, and these form were in by memory same physical document or in file group (this is inevitable) sometimes, restore a file merely or file group may bring about it and database other part is different pace. For example, you have a form to be used by another form JOIN is associated, and this JOIN used a view and memory process, restore merely at this moment and do not restore another to may have a problem.
There is group of a file only in the database when you. If all your data store merely in a file or in file group, and it is not a particularly big database when, what thing can you produce? Restore a file in those days or the effort of file group does not have what meaning with respect to what change.
Alternative refreshment file or the main reason of file group is to should restore a database very big, so that restore when the cost of whole database is very big, make of the local attaint to the database restore to become a possibility. In the database of a very small lightweight, with Nonproduction system in, when there perhaps is group of a file only in the database, the refreshment with alternative implementation the function does not have too great sense with respect to what show, because restore at this moment,whole database is mixed restore individual file or the distinction with file without what too big group.
Previous12 Next
Hot Tags: