Restore 1 from backup. Windows System Restore. Testing the database with the utility

The computer crashes unexpectedly. Yesterday everything was still working perfectly, but today it stands like a silent iron box, and you urgently need to submit reports to the tax office.

Therefore, all 1C users are strongly recommended to back up their databases as often as possible, so that in the event of such unplanned and very unpleasant force majeure, they can easily restore the database and start working. It is better to store the backup copy on removable media or another network 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 it becomes necessary to format the hard drive when installing a crashed system, the 1C program databases will not be affected. This can be useful if you forgot to make another copy and have too much information to restore.

We copy a backup copy of the database to the desktop (assuming that you have one), which is called, for example, “Copy of 1C from 04/10/14”.

1. Let’s create, for example, on drive D an empty folder called “My Favorite LLC,” although the name, of course, can be anything. It is into 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 information base, 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 to develop a new configuration or load a previously unloaded infobase” - we will create a base for loading a previously unloaded database.

5. Specify the name of the database that we are restoring 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 the three dots and look in the directory tree).

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

8. Launch the still empty database in configurator mode.

9. In the configuration menu, select “Administration” - “Load infobase”.

10. Specify the backup copy of the database (folder “1C copy from 04/10/14”) from which the 1C database needs to be restored.

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

12. We agree to restart the Configurator. The program itself will perform the necessary actions.

13. Then close the Configurator and launch the program in normal mode.

Let us remind you how to make 1C backups, because unfortunately, when purchasing the program, no one will tell you how to do this.

This can be done in different ways. Of these, the easiest way is to copy the folder with the 1C database files and pack it with a familiar archiver to reduce disk space.

The task of restoring a database from a backup can arise during development (to restore a test database) or when the database is damaged (whether logical or physical). We'll look at how to restore 1C below.

The process of restoring a database from a backup copy is quite simple, but nevertheless it should be treated with increased attention, since this operation is irreversible.

1. The first thing to do before restoring a database from a backup is to make sure that you have a backup copy. If there is no database backup, you should create one.
2. After this, you need to make sure that this is the correct backup copy of the 1C database. If you are not completely sure of this, restoring a copy to an existing 1C database may result in data loss.
3. Before restoring a backup to an existing working 1C database, i.e. Before loading any data into it, it is also worth making a copy of the database.
4. Before restoring a backup, make sure once again that you are restoring exactly the database you need. Situations have repeatedly arisen when “experts” restore a backup of a test database to a working database.

We are looking at the process of restoring a database from a *.dt file. And although this format is intended primarily for obtaining an image of an information base, regardless of the method of data storage (1C, 1C Enterprise 8 Administrator's Guide), very often this format is used by users for backup storage of databases, and as a result, in order to restore 1C database.

The database restoration process itself is extremely simple. The 1C:Enterprise infobase is launched in the “Configurator” mode, and in the “Administration” menu, select the “Load infobase...” item:

After clicking on the “Yes” button, the data recovery process will begin. The process is irreversible! When you start downloading data, existing data will be lost and replaced with data from the downloaded database file during recovery.

You can also restore infobase data from a *.dt file using the command mode of launching the configurator and a command line with approximately the following content:

1cv8.exe DESIGNER /IBConnectionString "File="R:\Temp\83";" /RestoreIB 1Cv8.dt

All 1C:Enterprise launch parameters are given in the system’s built-in help:

It should be noted that very often the task arises of obtaining not all data from a *.dt file, but only a configuration file (*.cf).

To solve this problem, there are several third-party programs, both paid and free. They allow you to get a configuration file, and also perform other functions, for example, they allow you to delete the list of users from a *.dt file.

We will not provide direct links to these decisions, because New offers are constantly appearing, existing ones quickly become outdated, and their full list can be found on the Infostart portal, using the key phrase “Unpacking dt file.” Ready! Now we know how to restore a 1C database.

I don’t think it’s worth explaining to anyone today how important it is to make copies of important files. The 1C system also applies to this. Despite the reliability of the system, no one is immune from any possible scenario. Restoring 1C is a fairly simple process if you have . We recommend making backups every day. Let's look at a short manual for beginners on how to restore a 1C database from a backup.

If a bad situation happened and you still had to restore the database, don’t be upset. If you have a copy, restoring the 1C database is very easy.

Restoring a database from a *.dt file

This method is valid for both file and client-server DBMS. If you are trying to load a backup from a file with the “dt” extension, you need to do the following manipulations.

Open 1C in “Configurator” mode:

Get 267 video lessons on 1C for free:

After entering the configurator, select “Administration”, then “Download infobase”:

Select the location of the copied file on disk. The system will begin to restore the database. Once completed, the following message will appear:

Restoring a database from a *.1cd file

The method is applicable only for file DBMS. This method of restoring a 1C database is quite simple. It is enough to replace the file in the folder where the file is located.

You can find out the location by viewing the path to the file in the information security selection form:

Following the indicated path, you will find the file “1Cv8.1CD”. This is the 1C database. Before replacing this file with your own, just in case, make a copy of the “broken” database; it may be useful later.

Neglected cases

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...

Don't 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 highlighting the database in the 1C launch window):

In the dialog that opens, go to the “Previous Versions” tab:

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

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

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

If you are unlucky with having a shadow copy of the disk (or there is no copy for the required number), move on 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 a temporary folder on your computer. In this article I will talk about 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:

Type the command %temp% into the text field and click OK:

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

We are primarily interested in folders that begin with " 1Cv8Update". In one of these folders there may be a backup copy of our database.

In order not to look through them all (we need the most recent backup), we sort the folders by date:

And we begin to look from top to bottom (from the most recent folders to the earliest).

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

The database backup 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 is usually the largest file 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 creation date suits us, this is great news!

Now let's determine the backup copy from which database did we find?

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

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

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

But now we have found the most suitable one - how to restore the database 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 database - here.

Nothing helped

If we couldn’t find a backup copy, don’t despair either (you should never despair). As they say, there are no hopeless situations:

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

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

Restoring the 1C database- the simplest answer to all the problems awaiting the system administrator. Is the server infected with a virus? Restoring 1C saves the situation. Broken disk? Restoring the 1C database - and the system is ready for use.

In any unclear circumstances, restore 1C! All you need is the Handy Backup utility, which can create or restore the backup copy of any 1C data you need in a matter of minutes. Try restoring 1C using Handy Backup!

Advantages of saving and restoring a 1C database using Handy Backup

Handy Backup allows you to perform automatic backups of 1C versions 7.7, 8.2 and 8.3, both for master data and for SQL databases. Using Handy Backup to store and restore 1C databases, you get the following advantages:

Full automation
The program automatically searches for 1C data on your computer to create backups, processes them and, if necessary, restores them to their original (or any specified) location.

Storing data in "native" format
Handy Backup does not change the format of the data in the backup copies; as a result, any data from the backup can be opened, moved, copied or edited as a regular file.

Partial restoration
Sometimes a complete restoration of the 1C database is not required; in this case, the user can select individual files from the backup and restore them manually or using Handy Backup.

Simplification of 1C maintenance
To safely perform operations such as testing or synchronizing 1C databases on different servers, it is enough to restore the 1C database from a copy in the selected location.

Working with the contents of the 1C database for a certain period
Regular 1C backups allow you to subsequently select a copy for a certain date to restore the 1C database and gain access to information during this time.

Recommended solution for restoring a 1C database from a backup copy

Download

Buy!

Version 8.0.4 dated July 10, 2019. 104 MB
Backup program Handy Backup. 9200 RUB for a license

Features of 1C database recovery for different versions

The above sequence of actions is used to restore 1C of any version. It is worth pointing out, however, some features of working with individual versions of 1C.