Windows System Restore. Windows System Restore Backup 1s 8.3 Restore

Power outages, network equipment malfunctions, ill-considered actions of employees - this is not a complete list of reasons why errors may appear in the 1C database. As a result, fantastic numbers appear in the reports, the program periodically crashes, or even stops running altogether. As a result, the many months of work of a huge team can be completely ruined and the question arises of how to restore the 1C base.

Fig. 1 One of the options for error.

Preparatory stage

First of all, you should decide in which mode (file or client-server) the program works. Of course there are several universal ways recovery, but for correct setting backing up this information is needed.

Fig. 2 An example of the address line of the file base.

If in the selection window information base that pops up when the program starts, there is an inscription similar to that shown in Fig. 2, the operating mode is file. If the address starts with the words "Svr" or contains "http", then the mode of operation is server mode and some of the actions below cannot be performed.

Methods that are universal for file and client-server modes of operation

These include those options for restoring the 1C information base that the platform itself offers. Two methods, how to restore a damaged database in 1C:

1. Checking the configuration;
2. Testing and fixing the base.

In order to restore the 1C database using one of these methods, you must have administrator rights.

IMPORTANT! Before any action, even with a damaged base, make a copy of it.

Checking the configuration

Helps to solve problems in the configuration itself, while the data is not affected.

Sequencing:

1. Go to the configurator;
2. Select the menu item Configuration-> Check configuration;
3. A window appears (Fig. 3);
4. The checkboxes are checked by default;
5. Press the OK button and wait for the verification program to detect and fix possible mistakes;
6. See if the bugs are fixed.

Fig. 3 The configuration check window.

Testing and fixing

If the problem persists, you can try to restore the database.

For this:

1. In the configurator, go to the Administration-> Testing and fixing menu item;
2. Before opening the main processing form, the program will offer to make a backup copy of the infobase. If we have it, we press the "Continue" button;
3. The window shown in Figure 4 will appear;
4. After checking the boxes, press the "Run" button and wait. The waiting time depends on the power of the computer on which the program is running and on the size of the database.

One tip: it's best not to check all the boxes at the same time. With large volumes of the database, this can lead to computer freezes and errors. Usually, all stages are performed in turn. In this case, the check execution time increases insignificantly.

As you can see from the picture, in addition to the checkboxes describing the actions that must be performed by the program, there are several radio buttons on the form. Some of them become active only when a specific task is selected.

So, to restore referential integrity database, processing will provide an opportunity to create a new object, or simply delete the link.

Restoring a backup copy of the database

This method is also universal for any infobase, however, the methods of its implementation differ greatly depending on the program operation mode.

If testing and fixing does not help, you can try to restore the last working version of the program. How to do this in the client-server version of the work is a topic for a separate large article. The file version has several possible ways restoration of the 1C base.

• The first solution to the problem:

1. First of all, you should decide where exactly the base is located. To do this, you should carefully look at the infobase selection window. (Fig. 2) After the word "File" there is an address line, by clicking on which you can find a file with the CD extension. This is where the tables and indexes of the database are stored in a packed form;
2. By replacing this file with its own version saved earlier, you will receive the database at the time of saving.

• Option # 2 assumes that the periodic saving of the database is performed from the configurator according to the following algorithm: the Administration-> Unload infobase menu item. Saved to a file of dt format, such a database stores all the information.

Reverse loading can be done both into an absolutely empty base, and over an existing one. The second option is preferable if the number of users is large enough and there is no strong desire to run around the departments and re-register everyone the path to the new database.

After such a restoration, it becomes necessary to enter the missing documents for the period from the moment of saving to the current moment. With insignificant workflow, this can be done manually, otherwise it is better to use.

The computer crashes unexpectedly. Yesterday everything still worked fine, but today it is a silent iron box, and you urgently need to submit your reports to the tax office.

Therefore, all 1C users are strongly recommended to back up their databases as often as possible, so that with such unplanned and very unpleasant force majeure, it is easy to restore the database and start working. It is better to store a backup on removable media or another networked computer.

It is important to note that it is better to install the 1C program on a disk that does not have a Windows folder. If the need arises formatting hard disk when installing a collapsed system, the databases of the 1C program will not be affected. This can be useful if you forgot to make another copy and you have to restore too much information.

We copy to the desktop a backup copy of the database (it is assumed that you have it), which is called, for example, "Copy of 1C dated 04/10/14".

1. Let's create, for example, on disk D an empty folder with the name "My Favorite LLC", although the name, of course, can be anything. It is to this folder that we will restore the database archive.

2. Launch 1C and click the "Add" button. Our task is to add a new one (from a backup copy) to the list of existing databases.

(fig. 1).

3. We must create a new infobase, so we select the first item in the window that appears.

(fig. 2).

4. In the next window, select the second item "Creating an infobase without configuration for developing a new configuration or loading a previously unloaded infobase" - create a base for loading a previously unloaded database.

5. Specify the name of the database to be restored from the backup (usually the name of the database plus the date of the backup).

6. In the infobase parameters, specify the path to that (my favorite LLC) empty folder (click on three dots and look in the directory tree).

7. Select the automatic authentication option, set the startup mode to automatic, and leave the version field empty.

8. Launch, while still empty, the base in the configurator mode.

9. In the configuration menu, select "Administration" - "Download information base".

10. Specify a backup copy of the database (folder "Copy of 1C dated 04/10/14"), from which you need to restore the 1C database.

11. A warning will appear stating that all data in the current database will be overwritten with data from the backup. But since the copy is being restored to an empty base that was previously created, there is nothing to be afraid of.

12. We agree to restart the Configurator. The program will automatically generate necessary actions.

13. Then close the Configurator and start the program as usual.

Let us remind you how to do backups 1C, because unfortunately, when buying a program, no one will tell you how to do it.

You can do it different ways... Of these, the easiest way is to copy the folder with the 1C base files and pack it with a familiar archiver to reduce disk space.

A prerequisite for all 1C users. It is unlikely that anyone will be pleased with the prospect of working at night on the recovery of valuable information in order to submit the required report on time.

No one is immune from various software and technical failures in everyday life or at work. To avoid unnecessary waste of time and money, you should take care of the safety of information in advance. Moreover, practically nothing is required for this - it is enough just to make a corresponding copy.

1C also offers this opportunity to its users. In other articles on the site, we consider in detail how to save data on third-party media. Now we need to understand how to recover data from an already saved copy.

It should be emphasized right away - to install the 1C program, it is better to choose a disk without Windows folders... Format if necessary HDD on the computer, if necessary again, the data will not be deleted. A very important condition if you suddenly forgot to save a backup version of your database when you need to work on a huge amount of data.

It is important to understand that 1C products represent a common software, similar to other applications. Here, the saved data is written to files that can be easily copied and made a backup version, and, if necessary, restored or deleted. Usually, for such a step, the built-in 1C capabilities are quite enough, which we will talk about.

Clear 1C - how to restore from a backup

The first step is the main thing that we have to do before the restoration, to take care of the availability of a backup version of our database.

The second step is to go directly to recovery. Please note that all configuration and data changes are lost after the backup is created. After the database is restored, 1C will contain the information that was valid at the time the backup version was created.

When performing regular backups correctly, there are two relevant options:

a) when storing the backup as a file with the ".1CD" extension or as a configuration directory in its entirety, to restore the settings, it is enough to replace the Cv8.1CD configuration file with a similar one from your backup copy.

b) in the case of storing a backup copy in the form of a file with the extension ".dt", in order to restore the data, in the configurator mode, select "Administration - Load information base" in the main menu.

"Administration - Download information base"

At the third step, after the 1C base has been restored, you can immediately work with the loaded configuration.

This method almost always helps, and most importantly, do not forget about regular backups of your databases in order to avoid unnecessary waste of time and effort for subsequent recovery.

Last chance to find a backup if there are no other options left

So, the irreparable happened:

As they say in such cases - we have arrived ...

Do not rush to panic - all is not lost yet.

We go into my computer and open the properties of the disk on which the database is stored (this disk can be seen by selecting the database in the 1C launch window):

In the dialog that opens, go to the "Previous versions" tab:

If there is a version of the disc from the number we need, we are saved!

In this case, select this version and click the "Open" button:

We find here the folder with our base and drag it, for example, to the desktop.

If you are unlucky with the presence of a shadow copy of the disk (or there is no copy for the required number), go to the second option.

We are looking for a temporary backup created when updating the database

One of the temporary backups created by 1C when updating the database can still be stored in the temporary folder of your computer. In this article, I'll show you how to find and extract such a copy.

First of all, we find the temporary folder of our computer.

To do this, press the key combination Win + R:

1. First press Win;
2. Then, without releasing Win, press the English letter R;
3. and release both keys.

This is what the Win button looks like:

In response to this, the "Run" dialog will open, on my Windows XP it looks like this:

We print the command% temp% into the text field and click OK:

In response, the computer will open a temporary folder for us:

We are primarily interested in folders that start with " 1Cv8Update". It is in one of these folders that a backup copy of our database may be located.

In order not to view all of them (we need the most recent of the backups), we sort the folders by date:

And we start browsing from top to bottom (from the most recent folders to the earliest).

We go into each of the folders starting with " 1Cv8Update":

The backup copy of the database in this folder will look like a file with a yellow icon, starting with the name "1Cv8" and the extension ".1CD" (but it is not always visible). This file usually has the most big size of all (in my case, 752 megabytes).

To the right of this file, we can see the date it was created. If such a file is found and the date of creation suits us, that's great news!

Now let's define a backup from which database did we find?

To do this, open the "log ... txt" file:

Here is the path to the base folder, the backup copy of which we found: X: \ Base 1C \ ArendaDemo.

If this backup does not suit us (the wrong database or the wrong date), we look further.

But now we have found the most suitable one - how to restore the base from it?

To do this, create a new empty folder in the folder with 1c databases, for example, like this:

Copy the file into this folder " 1Cv8 .... 1CD"from the backup folder:

Change the name of this file to " 1Cv8"(if you didn't see the .1CD extension, then you don't need to add it):

We connect this folder as a regular 1C base - that's it.

Nothing helped

If we could not find a backup copy, we also do not despair (you should never despair). As they say, there are no hopeless situations:

• If the base was accidentally deleted (including from the recycle bin) and no operations were performed with the computer after that, a specialist using special programs will be able to find and restore it from hard disk... This (if at all possible) should be inexpensive. You just need to call a specialist without delay, until the remote database on the hard disk is overwritten with other data.
• If the database is so damaged that they did not help, then a good specialist will also almost always be able to restore the database or extract data from it. For this, you may already be asked for a decent amount. And here you need to weigh the cost of recovery and the cost of lost data. Here you can take your time and even show the base to several specialists at once.

I ask you to - regularly backups of your databases and documents. You only understand how important this is in such desperate situations as described in the article.

This article is a continuation of the series of articles "First steps in 1C". It discusses the typical methods of restoring the 1C database on the 1C: Enterprise 8 platform after failures. It is assumed that the database operates in the file mode of operation. Database recovery in client-server mode is not considered, since this question clearly goes beyond the "first" steps of a beginner specialist.

The material of the article will reveal in detail the answers to the following questions:

• What should be done before starting all the restoration work? (copy, Karl!)
• What subtleties are there when using the verification utility?
• What recovery tools are there in the configurator?
• When and why do you need to upload / download in * .dt format?
• If all of the above does not work, what else can you try?

Applicability

The article was written for the 1C: Enterprise platform version 8.3.4.496, but don't worry if you are working with an older version! All material is absolutely up to date.

How to restore a damaged database "1C: Enterprise 8" in 1C

Sometimes for a beginner, this task seems simply unrealistic. Although, in fact, there are a number of simple standard tools for testing 1C databases and methods for correcting errors that arise.

The appearance of various kinds of systematic failures (errors, incorrectly displayed data, emergency closing of the program) can be considered as damage to the database.

Causes of occurrence critical errors are varied. Most often, problems arise due to power failures.

We can say with confidence that in the client-server mode of operation, the database is more resistant to errors.

As part of our articles, we will consider the file mode of the database. And the first thing you need to warn the client about is the presence of a source uninterruptible power supply on the computer where the infobase is installed is highly desirable.

So, the main thing is not to be intimidated before trying to restore the database. make a copy of it.

For example, you can first copy the entire folder where the base is located, and then leave only the 1Cv8.1CD file (base file) and the 1Cv8Log folder (event log) in this folder.

In fact, in most cases, databases can be restored. Some 1C-nicknames understood this and happily intercept such clients. In most cases, you don't need to do anything special yourself, the client is scared, and the work test programs takes a lot of time.

Let's move on to practice. First, ask the client how long ago and under what circumstances the failures began to occur. Learn how users update the configuration and how the two events are related over time. Check the volume of the base.

Even if in this particular case the clarified circumstances will not decisively affect your subsequent actions, you will be able to collect some statistics that may be useful in the future.

Be sure to find out if the platform was updated, and under which platform release the database worked before.

First of all, delete all files and folders that surround the base file (1Cv8.1CD) in the specified directory. Yes, these are some kind of service files that provide full-fledged work, but it has been noted for sure that sometimes some mismatch occurs in the work of these files.

Nothing bad will happen, because at the next launch of the base, all required files will be recreated. We will postpone the launch for now.

Now we will use the most effective, but far from the last, means. In the directory C: \ Program Files \ 1cv82 (for platform 8.3 - 1cv8) \ (further platform release number) \ bin run the chdbfl.exe utility.

Attention! Each platform release has its own chdbfl.exe utility. It is advisable to use the utility from the platform release with which you used this base... In most cases, this is the last installed release of the platform.

Here it is worth mentioning one peculiarity, if the moment of database corruption approximately coincides with the moment of platform update, then the chdbfl.exe utility of the previous platform often gives better results in finding and fixing errors.

The peculiarity of this utility is that if there were no corrected errors during the first pass (the utility was unable to correct any errors), then re-launching it, one might say, is useless.

However, if not all errors have been fixed, but a decrease in the number of errors is noted, then it makes sense to run the utility again.

There were cases when the number of errors found changed to zero during the second pass. In short, repeat the operation until there is a result of reducing the number of errors. It seems that some of the errors fixed on the next pass allow you to fix others as well.

The testing parameters and corrections themselves, if you absolutely do not understand exactly what you are doing, it is better not to touch them.

No improvement in test results was noted with repeated use of this tool.

There is more to say about the configuration checker. Experience has shown that errors reported by this tool are not particularly critical. Rather, they simply slow down the base itself. That, in fact, for databases over 4 GB in size by the user can also be regarded as damage to the database.

4 GB is the maximum allowable size not for the database itself, but for the tables in the database. But some register can be much larger than the others and take up most of the base size.

In this form, it is also not worth changing any settings without absolutely clear understanding.

One more not entirely obvious method should be said. The fact is that when unloading the database into a file with the dt extension, there is an extremely low probability that it will not be possible to load it back.

However, during loading, a certain restructuring of memory occurs, which in some cases allows restoring the operation of the database by sequential unloading and loading.

If, after all the measures and tests carried out, you find that your base remains damaged, then it is advisable to use this tool as well.

Unloading is performed in the configurator via the Administration menu, item Unload infobase.

A dialog box will appear in which you will need to specify the direction of unloading. Name generated file can be used by default - 1Cv8.dt.

It should be noted that unloading is also one of the possible methods copying.

It is best to load into a new base without configuration. To create such a database in the infobase window, click the button Add... Save the setting at the next step. Creation of a new infobase and click on the button Further.

In the form that appears, change the setting to Creating an infobase without configuration and also click on the button Further... In the next two steps, define the name of the base and the directory (empty) in which it will be located.

Additional parameters can be left blank and click on the button Ready... An infobase without configuration will be created.

A couple more points. If malfunctions in the base operation are noted only on one computer, you should try to change the computer. If only one user has problems, then you should try to recreate the user.

Sometimes it helps to remove a base from the list in the infobase window and then add the same existing infobase to the list (restore the path to it).

In conclusion, I would like to say that, of course, not all databases can be restored, some of them are restored using more complex methods. But do not be upset, such cases are rare enough.

As a preventive measure, you can advise to update the databases through the configurator and use staff funds testing and bug fixing before each update. Users who own basic versions and are entitled to free upgrade can also pre-download update files from the site.

In the next article, we will consider the possibilities for configuring the list of infobases.