By backup and update. Backup copy

Copy of databases

Basi danikh, how to use it, can be divided into two categories: 3 system databases (oktell, oktell_cc_temp and oktell_settings) and databases for Okapp web client modules. To launch Oktell, the update requires no system base. Інші DB is required only, if you want to save your adjustment of the web module.

For example, the base WO_Module_journal is vikoristvuyutsya module Magazine sberіgaє at sobі tags of recordings of roses. The WO_Module_dashboards base is required for the Okboard Dashboard robot module and to change the settings of the indicators, which can be used.

Croc 1. Copies of the system tables are set up automatically when starting at 02:00 after the server hour, unless the DBAutoDailyBackup parameter is enabled. The creation of copies is given a special rank, overflowing copies

• the remaining two tizhni - a day
• given three months - once a day
• dali two rocky - shomisyatsya
• far times on rik

All copies are found in the folder \ oktell \ server \ Backup, unless the DBBackupDir parameter has been overridden.

Have your own chergu, you can zrobiti backup copies at any moment. To go to Administrative / Regional nalashtuvannya / Keruvannya databases... Push the button Create a backup copy of the database.

Pislya end backup copy Backups will be available in the root of the folder oktell \ server \ backup.

Croc 2 To root copies of your databases, open SQL Server Management Studio... Click with the right button on the required database and in the context menu, select Zavdannya, then Create a backup... At the moment, when you see it, you can remember the way to start the backup, to copy the copy OK. Copies for the candidates are listed in the papacy C: \ Program Files \ Microsoft SQL Server \ MSSQL11.OKTELL \ MSSQL \ Backup \.

Updating databases

It is possible to update the database on this very version of the SQL server anyway. It is based on SQL Server 2008 R2, but cannot be updated on SQL Server 2008.

Croc 1. Subscribe the okteleserver service. Run the command row with the administrator's rights and enter the next row:

Net stop oktellserver

Croc 2 Launch SQL Server Management Studio with a simple sa record:

• Login: sa
• Password: 123Oktell321

Croc 3 As long as you have established the base of Oktell earlier, it is necessary to see it. There are system databases and databases that use web modules.

Croc 4. Start before the update procedure. Press the right button on the System Database and press Restore database(Update backup copy).

Viber a file from a copy of databases. To select a Device, select Add and select a file from a backup copy, for example db_ok_130628.bak(In this vipadku, tse DB oktell).

I will pick the name of the base of the data at the upper part of the window, as you will see it. Name the base danih vi you can bachiti at the lower part of the window. Don't forget to tick the box Restore(Update).

Repeat the same data bases.

Croc 5. When updating databases for a mobile robot, it is necessary to install data bases. For tsoy vikonayte zavantazhte and vikonayte navodniy zapit.

Croc 6 Yaksho vi transferred the database to a third-party server, rewrite the setting in the server config file \ oktell \ server \ oktell.ServerService.exe.config... Perekonayte, scho in a row with the key DBConnectionString sent to the database, the login and password is entered correctly. For substitutions, the row for connecting the viglyad is as follows:

Server = (local) \ OKTELL; database = oktell; uid = AutelService; pwd =; pooling = true

I will change the name of the server. (local) \ OKTELL... For example, the SQL server was moved to the WORK server with the IP address 192.168.0.3. Also, you will need to use the parameters WORK \ OKTELL... If the server doesn’t start because of the settings, try to use the server name without instantiation. WORK... You can change the name of the server to the IP address - 192.168.0.3/OKTELL chi tilki 192.168.0.3 .

Yaksho vi changed the main regional recording AutelService, you need to provide a new login and password in the fields uidі pwd for sure.

Know the name of the server (instance) and you can use the command

Sqlcmd.exe -L

at the Windows command line.

Croc 7. Start the service oktellserver... For the command row, visonite

Dear friends, for the present, an even more important topic is discernible for you: backup copying and renewal of tributes. Why should two witnesses go at once and not ok? Who needs the stench most of all? At all times, meals are given at a time, and then we can go without a second to active ones.

Also, just a backup copy: it allows us to save all files, document and information information and add software to the new information. Beastly respect, that how the rest of the world can be seen in the Internet. But not all of the data can be taken in this way. We will talk about it three years later.

And yes, the opportunity to update all those who have saved earlier, with a later exploitation of the files. For example, if you have saved the photos from your summer waste in the gloomy skhovisch, then you can not only wonder, but you can just turn back on whatever you want to see. Now, if some of the three have updated their luggage with two different understandings, we can proceed to an active negotiation: how to make a backup copy of the data, how to use it for a whole lot of programs, on some outbuildings the price can be done and so far. Yak bachite, our small discussion is slowly growing. So it’s easier for you to predict, at once we will show you the blocks, which will be illuminated. You can immediately vibrate what you need and start to the robot:

• Computer information
• Information from tablets and smartphones
• Recommendations of koristuvachev

Of course, it means that for the completion of a copy of the files, or for the system, you will know the latest information, in order to obtain your data. Insert it at the USB-in on the computer or laptop. Podbayte about those that are available to the space on the disk, or the flash cards will be larger, but not borrow your files. Just quilt for him, for the next hour I’ll write it down without putting it down: if it’s necessary to hook up the cable and you’ll see it, then you can spend the tribute.

If you want to make a copy of your smartphone or a tablet, you will need an original cable for connecting to a PC. For koristuvachіv gloomy skhovyshcha recommended avnіst vidnіtless unimpeded Internet connection. For example, if you will have some traffic, and if you change it, then you will happen to Viklasta deyaku sumu, schob the Borg, just pretending.

Computer information

So, as computers danny occupy the first row in the rating of the importance of middle annexes, from which our robot is ours. First of all, it’s obvious that there’s a small amount of backup for the type of information that can be saved: there can be a copy of the operating system at once, copying together with the files or the backup of files. For the sake of visibility, the stock for Windows 7, 8.1 and 10 is visible.

Windows 7

• We pass to the panel of the computer for the computer with the help of the Start button, for any other way of navigating.
• An onslaught on the menu "System that bezpeka".
• Far in front of you, you will see a window with tabs, if you need to read it on "Backup copy and update of the tribute".
• Otzhe, at the new window you can add a menu with adjusted archives. Natisnit "Archivation and renewal".
• Let us know how to set up a backup copy of the additional blue button.

Onslaught on "Nalashtuvati backup copy"

• Let us show up in front of you in a dialogue window with the established archives. Vibrate your hard drive and press the "Distant" button.

Vibiraєmo roztashuvannya archiv

• At the offensive prompt, the system will ask you to clarify what is required archivuvati. It is recommended to win the first option ("Nadati Vibir Windows"), oskilki vіn zberіgaє all that regularly new dan. Beastly respect, that there is another option, yes, koristuvachev, vibrate yourself, that needs to be saved. So you can put your folders or just around the directories, if you don't need a backup copy at once from the files of the operating system.

Vibir ob'ktiv for archivation independent

• The given parameters are changed. Here you can set the distribution for the automatic shutdown of the copy using the "Change distribution" button.

• If everything will be installed and inverted, press "Save the parameters and start the archive".

Process visonuu

• Check out the end of the process, and then change your name on the hard disk: what has been recorded on your new tribute.

Windows 8.1

• Launch the toolbar on the right side of the screen. In order to introduce Misha at the right upper kut, then press on "Poshuk".
• Select from the keyboard the word "History of files" without paws and press Enter. In the results, print one folder.
• You will have a meal at the window, if you need it, you will need to try to make a backup copy of the image of the system.

• Vibiraєmo mіsce zberіgannya archіvu (as a housewife, it’s a great hard drive). Natisnit "Dali".
• Step by step will show you an obsyag memory, which will be required. Reverse all the data and press the button "Archivuvati".
• Check in, leave the system, open the reserve copy of Windows on the latest news. The whole process can take a ten hour, so don’t go to panicuvati.

Windows 10

• Run the parameters behind the Start button on the plant panel.
• Open the "Updates and Bezpeka" tab.
• In the lіvuyu stovpchik with parameters to natisnіt "Service of archіvatsії".
• With the help of one button, set up an automatic backup system.
• Beast to respect, you can easily adjust folders there without any problems, copies of which will be folded. Tse nabagato lay down your robot.
• If you want to set up a backup copy at once with the operating system, and not around the library and director, speed up the instructions for Windows.

To update the data, repeat the points, the first step is to know the parameters of the archive. And now, just vibrate the tab or the item "Renovation" and just look at the instructions from the dialogue window on the monitor screen. Nichogo folding in tsyomu dumb. Squeaky, we looked at you staff Windows from Microsoft. Іsnyuti i special programs similar operations. The stench can be healthy, but in terms of safety and reliability, the cym can be slowed down. It is recommended to use the standard OS utilities.

Information from tablets and smartphones

Here all three are simpler, for that it is also possible to use standard programs (for example, for iPhone and iPad we will work with iTunes). For all gadgets, be it an operating system, the procedure for entering a backup copy will be the same:

• Connect to the computer or laptop. Check in for the installed drivers.
• Launch the program, as it is intended for synchronization with your device. Tobto, if you have an iPhone, then open it iTunes supplement to your PC.
• Know the tab or the item "Synchronization" or "Backup copy". Klatsnіt on nіy і, looking for prompts on the screen, set a copy.

• For renewal of the tribute at all times, know the same button and press on it.
• For the next hour, do not enter the USB port at any time. You can end up with a software breakdown of the device.
• Beastly respect, you can just transfer files from a smartphone or a tablet to a PC. It is especially important for the owners of gadgets for the management of operations Android system: here є additional access to all files and folders.
• Vlasniki of iOS devices can take only photographs and videos by an analogous rank: go to the "Computer" and click the right button of the Misha on your attachment. Natisnit "Іportuvati photography and video". If you are looking for suggestions on the screen, you can not only import the import, but just set it up.

Hmarni groves

This is a seasonal type of donation that is popular on the market: no flash drives, cables and peripherals are needed. It is necessary that you do not have an active connection to the Internet, and all your files are in your hands. We will not look at me (for a whole є theme), but just to say about the skin for a singing OS:

• OneDrive for Windows
• iCloud ta iCloud Drive for iOS and MacOS
• Google Drive for Android

Є Still universes, which are put on any attachment, right from the installed OS:

• Khmara Mail
• OneDrive
• Google drive

Yak vi have been remembered, from the withers, tilki Apple company I made my product available from my system. It's disgusting tse chi good - virishuvati to you.

• When victorian zovnishny hard disk For a flash drive, podbayte about those who won’t have enough big space.
• Beastly respect, so a lot of wicked trash cans may be surrounded by memory for non-kostevoy access. For example, in iCloud Drive five gigabytes will be available to you. Expand your account, you will need to buy up the payment. If you don't have so many files, you don't need to add anything. You can also register with a kilkoma wicked trash.
• Reverse the origin of the copies: if the memory on the disk is over, or the copy has ended, the copy will not be lost. Visually take in deyakі danі, as soon as we will sum up the inheritance.
• If you just copy the files, then you can see them from the copied device for sound memory on a new one.
• If you want to save even more important documents, more beautifully to make two copies. For example, you can run one on the most recent hard drive, and for help with the programs of the dark hard drive.

Pidvedemo pidbags

Dear friends, this year we have discussed an even great topic with you: backup copying and renewal of tributes. Bulo zrobleno's special emphasis on computer information Then we took a look at the out-of-the-box principle of copying smartphones and tablets, and also got to know the smartest treasures. We have given you a number of recommendations, so that your robot will be as productive as possible. Remember: save the tribute є the tightrope of the safety of your nerves. As soon as you use the files of your diploma robots, as you violated the tidings of the miscellaneous, it won't be much fun, why is it wrong? Check out the comments for any archival services in the best interest of you.

The analytic company Gartner has carried out a further development of a backup solution for enterprises. Fakhivtsi analyzed and developed a direct backup copy, actual products, technologies and solutions for saving and updating existing physical and virtual servers, to date. The main representatives of the market have been assessed for the bagatma criteria. Leadership in the analytics industry Gartner was given to such companies: Commvault, Symantec, EMC and IBM. Yak nishevi gravtsi on the market of bully vidіlenі Dell, Acronis, Asigra, FalconStor and іnshі.

The analysts of the company have also taken care of the main features of the robot and the important leaders in the backup solution, their strengths and weaknesses. The axis of action is from them.

RESERVE BACKUP VID COMPANY SYMANTEC

Symantec will stay for an hour to continue expanding the backup integration; There are more versatile features (for example, NetBackup Accelerator for quick backup and Instant Recovery for VMware virtual machines).

Strengths of Symantec:

• you can be the most popular enterprises, which can be used to provide information for a wide range of operating systems and supplements;
• NetBackup functions є the main characteristics of the product (Accelerator for online backup and OpenStorage technology for shutting down backup copies of disk drives, so that you can manage the backup attachments very well);
• Integrated for NetBackup, you can see good performance indicators for high-quality performance, manual performance and lowered productivity indicators.

Fakhivtsi store: for the deyakim vidguks, the service of the assistant of the company is not on the high rivn I want to take part in the behavior of the polish in the rest of the rock.

RISHENNYA BACKUP COPYYUVANNYA VID COMPANY ACRONIS

Nadaє solution for small and medium-sized businesses. There are a number of options for back-up and backup services based on cold technologies. Copies can be recorded in 5 different locations, including Acronis Cloud or via FTP / SFTP in private. Special technologies give the ability to perform a general, vibrational update of data from Exchange, Microsoft SQL Server and SharePoint, as well as from Microsoft services, VSS-summery database programs. To speed up the backup processes, deduplication, and squeeze on the sides of the dashboard can be combined with post-processing (indexing, cataloging) on ​​the sides of the endowment object.

Strengths of Acronis: nnocky model licensed, handy interface, support for any types of migration (V2V, V2P, P2V and P2P), support for 6 different types of hypervisors just from the side of the small version.

Fakhivtsi store: Acronis may be no less suitable for great companies, and the stock of fenestra tans (NAS) is flanked by CIFS / NFS protocols.

RISHENNYA BACKUP COPYYUVANNYA VID COMPANY VEEAM

Veeam has long recognized the leaders in the field of backup of virtual machines. At the same time, the game has been played against other competitors by providing special functions (for example, Veeam Explorer and Snapshot Hunter), simplicity and reliability. In the last release, the bullets have been given such important functions for enterprises: complex encryption, advanced backup control, EMC Data Domain Boost, NetApp Snapshot, SnapMirror, SnapVault and others.

Strengths:

• Veeam Backup & Replication is a superior solution for capturing these virtual media;
• Veeam will promote one of the easiest and most inexpensive products for backup in industrial enterprises;
• There are a lot of positive feedbacks from people who come to see them as soon as possible.

Fakhivtsi store:

• we will remove VMware and Hyper-V, and also, backup copies for other servers, because physical servers will not be available;
• Vlasna deduplication Veeam can achieve low efficiency, in order to achieve a greater loss of backup copies;
• Oskіlki Veeam proponyuyu U-AIR function, then there is no need for an upgrade for such solutions as Domino, MySQL and Oracle.

RESERVE BACKUP VID COMPANY COMMVAULT

Commvault building satisfies a wide range of needs for robots from one single platform for robots with data, including the power of complex backup, archiving, visibility, analytics and data. For the end of the day, the vendor has launched 4 packages of solutions, including products that are directly on the backup and updated for virtual machines.

Strengths of Commvault:

• One administrative console and the mechanism of sound / analytics for all backups (data center, remote offices, SaaS programs or PCs), archiving, synchronization and transfer of files, jokes and functions of data transfer;
• whole packages of solutions, bagatoplanovaya system of licenses Simpana and іnshі.

Everything should be appreciated for the backup of the given enterprises of the early years: from all the companies to the great corporations.

Fakhivtsi store: The part of the podbannya that fake pidtrimka can be finished with a high one.

Whenever you need to keep track of your back-up services, Gartner's financial companies have identified some of the main trends that can be promoted in the industry:

1. Bagato company prodovzhuyut actively rebuild its backup system, to know yourself successful solution for processing new types of data, models for saving and increasing workloads, and also for improving the task of accelerating backup and update processes.
2. The main straightforward methods of reducing є storage of disk solutions, including: backup copying to disk and additional storage, snapshots of bulk and replication, virtualization of servers, for maximum backup technology.
3. The vendor shouldn't be able to break up the powerless backup solutions, get satisfied with the business about how to get the power down: personal computers, servers, viddaleny offices, virtual machines, ізні additions and data base, etc.).
4. It’s a lot of companies to stop changing the part of their products and offer new solutions, as the boules would be as simple as possible at the victorian.

Lecture text

Keys to food

Lecture №15. Backup copy

Triviality: 2 years (90 min.)

· Visiting backup copy.

· Stezhennya for backups.

· Planning a backup copy.

You can view the backup for the Enterprise Manager, T-SQL commands or the Create Database Backup Wizard. The bugs have a problem with the Create Database Backup Wizard, but the Enterprise Manager is also awkward. On the other hand, the T-SQL commands can be expanded from the SQL script, as can be repeated in multiple ways. You should be able to use a method that will be the best for you.

The very operation of the backup copy can be directly connected to the physical setting and the logical setting. Physical pristіy - tse component of possession, such as a striking chi disc pristіy. Operating system nada physical annexes of the name, and for access to the cich annexes of the guilty vicoristovuvati the name. Oscillations and early signs of the name are important to remember, you may know the root of the physical extension alias (designated by the name of the alternative name). This alias is called a logical attachment. There is a logical setup only for SQL Server, and it can only be used for a backup in SQL Server, so you can use a new logical setup for a backup. If you want to make a backup copy of the tribute to the logical setting, you need to set it back in advance. First go to the methods of backup copying, it is easy to see how the logical setup of the backup copy will start. For the application of the distribution we will vikoristovuvat the logical setup of the backup copy. (To deny information about the product to the system and physical attachments, go to the system administrator.)

To shutdown the T-SQL backup attachment, use sp_addumpdevice to get started. Won maє offensive syntax:

sp_addumpdevice add_type, logical_im'ya, physical_im'ya

The value of the attach_type parameter can be disk for a disk attachment, tape for a line attachment, or pipe for a file attachment software security third-party forms to the backup system this annex; tse іm'ya vikoristovuutsya for the approval of operators BACKUP and RESTORE. The physical_im'ya parameter is the value assigned to the file by the system.

Having created one or more backup attachments, you can view the backup copy.

For a backup copy of the Enterprise Manager, check out the following.

1. Viklichte SQL Server Backup utility in addition to one of the hover methods below.

· Open the server folder in the left panel of Enterprise Manager and open the Management folder. Click the right mouse button on Backup and select the Backup A Database item from the context menu.

· Open the server folder in the Enterprise Manager panel, click the right mouse button on the Database, select the All Tasks item in the context menu and select the Backup Database command.

· Open the server folder in the Enterprise Manager panel and click on the Databases folder. In the right panel, click the right mouse button on the database, select the All Tasks item in the context menu and select the Backup Database command.

The SQL Server Backup dialog box appears (div. Fig. 16.1).

Malunok 16.1 - General Tab of the SQL Server Backup Dialogue Window

2. In the Database list, open the top section of the dialogue window, select the database for which you want the database to be backed up. (Yak, we victoriously used the third method at the end of 1, and the text of the given base will also be vibrated.) Name fields. You can also enter a description for the backup in the Description text box. Tsey description can be very important for you before the hour of renewal of the base danih. For example, if you make a backup copy without the middle before the visible tables, you must include the fact before describing it. I want to back up your copy to see the new tributes before the new tributes, to update the information from your description.

3. The backup copy must be specified for the backup type of the dialog box. The available selection buttons will change in the left base from the base of your choice. For example, Truncate log on checkpoint was installed for promovchannyam for base danih Northwind. (Acceleration of the transaction log from the hour of the checkpoint). The Transaction Log and File and Filegroup choices are not available for backup programs. The Backup section should be set to the same buttons.

Database - Complete. Outside the backup copy of the base danih, tobto. all the diversified basis of danikh.

Database - Differential. Rizninne backup copy of base danih, tobto. All the tributes that changed from the front backup copy.

· Transaction Log. Back up the transaction log; at the same time, there is an increase in the transaction log.

· File And Filegroup. Backup copy of one file of chi group files; Please enter a file or a group of files.

You can vibrate only one of the three types of backup. If you want to make a backup copy of the database and back up the transaction log, you need to run the backup software.

4. For the Destination folder, select the type of backup attachment - Tape or Disk. By pressing the Add button, you can add logical or physical backup attachments. Show up on the Select Backup Destination dialog box (Div. Baby 16.2).

Malunok 16.2 - Dialogue window Select Backup Destination

At the end of the dialogue window, you can enter the file or select the backup settings from the Backup device list to open it. Press the OK button, then turn to the General tab of the SQL Server Backup dialog box. In the small 16.1 attachment, the Backup to list has two attachments. If you can see it, you can see it and press the Remove button. Look at the attachment, press the Contents button. If you have installed the backup copy, it has already been victorious earlier, the information about the backup will appear.

Name (Ім'я). Іm'ya, vibranet tim, hto launching a backup copy.

Server. Іm'ya server, on which the backup copy was displayed.

Database (Database). Іm'ya bazi danih, on yaku bulo vikonano backup copy.

Type. Backup type (Complete, Differential, Transaction Log, Filegroup, File)

Date. Date that hour of backup.

Expiration. The term of the end of the day, instructions for the backup copy.

Size (Size). Zagalny backup copy space.

Description. Description of tasks for backup.

Nagadaєmo, on one backup attachment you can open a number of backup copies (it’s often a matter of practice).

5. In the Overwrite section of the SQL Server Backup dialog box, you can select either by rewriting the media (the Overwrite selection button ...), such as a line or a disk, which is given before the previous data (Append ... button). Ale if you vikoristovyte lines and draw them, you need to see the information in front of you. If you want, you can overwrite the information by clicking on the Overwrite existing media selection button in the whole dialogue window, you should change the rule of using the information before backups. Tim by yourself will guarantee yourself a bit like re-recording of a line or a disk attachment.

6. In the Schedule distribution, you can set a distribution to start the backup at the first hour. A set of backups for the distribution is especially suitable for backing up the transaction log, as can be viewed regularly, so that the transaction log is re-uploaded. To set up a backup copy, set the foreman Schedule and click on the buttons to look around (...), then the Edit Schedule window (Redaguvati distribution) (div. Baby 16.3).

7. Enter the name of the layout in the Name text box. The change of distributions allows you to open a chain of distributions, for example, an okremiy distribution for skin backup.

Figure 16.3 - Edit Schedule dialog box

For the Schedule type distribution, you can select one of the upcoming types of distribution (in the order of the buttons you select): automatically when starting SQL Server Agent, if there is no CPU usage, start the backup once or repeat it. If you have a one-time start of a backup copy vibrato, you can select the On date splicing calendar for the backup date selection and the At time for the hour selection.

To set up a backup copy, which will be repeated periodically, click on the Recurring button and click on the Change button.

Enter the dialog box Edit Recurring Job Schedule (Div. Babies 16.4). We will give you a great deal of dialogue and flexibility to start retailing. Vikoristovuchi options Daily (Schodnya), Weekly (Тizhnya) or Monthly (Shomyachno), you can specify the frequency of the same term of the period.

8. Click OK, then turn to the Edit Schedule dialog box, click OK again, then turn to the SQL Server Backup dialog box, and then click the Options tab (Div. Baby 16.5). If you have a backup, you can make sure you need to revise the backup copy after the backup is complete, and you can also need to have a way to create a header (title) of the backup copy. The parameters of the tab are pointed at the bottom.

Malunok 16.4 - Dialogue window Edit Recurring Job Schedule

Figure 16.5 - Options Tab of the SQL Server Backup Dialogue Window

Verify backup upon completion. Viklikak revision of the backup copy of the reading. To overwhelm deprive the integrity of the copy; The whole process does not change, but the backup copy is to take revenge on the data.

Eject tape after backup. Viymaє line from the attachment to the completion of the backup copy. Tsey great priest korisno vikoristovuvati, as well as the program for koristuvachiv, you have access to the outbuildings. This will allow you to save your line from being overwritten by our own koristuvach.

· Remove inactive entries from transaction log. Increase the transaction log for backup.

Check media set name and backup set expiration. In addition, it is necessary to rewrite and not overwrite it, if the end date has not come.

· Backup set will expire. Allowing you to set the date for the end of the term of the given wear.

Initialize and label media Allowing you to ask a tag for the whole wear.

9. After completing the installation of the parameters, press the OK button, then proceed to the scheduled backup.

Vikoristannya T-SQL Operators for Backing Up the Database can be tricky, niz Vikoristannya Enterprise Manager. Ale, you are put to quiet administrators, as the will to automate operations for additional scenarios, the whole method will be useful to you. In addition, the T-SQL BACKUP statement gives you much more power than the Enterprise Manager backup program. The syntax for the parameters of the BACKUP operator is clear in a wide variety of ways. As a matter of fact, there are two backup operators; The operator's vibe is to be stored in a type of backup copy, which is required by the visitor. Tse such operators:

BACKUP DATABASE. Vikoristovuєtsya for a backup copy of all bases danikh chi file chi group files.

· BACKUP LOG. Get victorious for backing up the transaction log.

Oscillations and two operators will preserve the same possibility, we will look at them at once.

The BACKUP statement for a repeated backup of the base danikh is the next syntax:

For the whole operator, the binding parameters will deprive the base of the data and the attachment of the backup copy.

The operator of the backup copy of the file or the group of files is the new syntax:

BACKUP DATABASE

іm'ya_file or іm'ya_group_files [, ... n]

TO set_backup_copy

[WITH optional parameters]

For the whole operator, the binding parameters should not be used for the database, for the file or for the group of files and the attachment of the backup copy. You can add a few names of files or groups of files that are separated by comas.

The statement for backing up the transaction log is coming syntax:

BACKUP LOG im'ya_base_danih

([WITH \ NO_LOG | TRUNCATE_ONLY)])

| (TO set_backup_copy)

[WITH optional parameters]

For the whole operator, the binding parameters are used to deprive the base of the given parameter WITH NO_LOG or WITH TRUNCATE_ONLY or the backup attachment. You can just add some parameters you need. Parameters NO_LOG and TRUNCATE ONLY є synonyms; offend to vkazuyut increase to the magazine without the establishment of a backup copy. If you are victorious, be it from these parameters in your BACKUP LOG operator, then if you have seen the system and you will not be able to update the database until I start, as it was at the time of viewing, I will not be too careful to write down the log. Stagnation of qih parameters is not recommended; vikoristovyte їkh on the government approval.

In the three important backup commands, the database is the database for which the backup will be created. Pristroy_reserve_copy - the purpose of a logical attachment of a backup or a physical attachment. If a physical attachment is indicated, then I will attach the text DISK =, TAPE = or PIPE = (I will be attached to the type of attachment). You can install one attachment or a set of built-in attachments.

In tables 16.1, a list of additional parameters is displayed, which can be accessed by the BACKUP operator. If any parameter is available for backup, if the base is not given, or the transaction log will be discussed.

Table 16.1 - Optional BACKUP Operator Parameters

Follow the team that you asked - add a backup copy to the existing data or overwrite the data that is described; Vibration option is added to the amount of money, as you can change it on the page. When you back up the tribute to the line, you can still get it without erasing the line (or overwriting it), you may not be able to read the message on the page. In the mode of adding the backup program, it will be victorious if you have less space, but it will be lost before the end of the line.

It will be viewed automatically, once a day. KOMTET promoted an additional option - a backup copy of the corystuvach and renewal of the tribute. Clients can arrange backups independently for the additional Hosting Panel (option to deposit in the tariff).

To back up a domain (website):

1. Go to distribution Domains>im'ya domain> Manager backup copy.
2. Natisnit Backup copy.
3. Add the following parameters:
   • Prefix for backup file and description. You can use the same file. However, you can also customize the prefix to the backup file before the panel. Remember that the Kerovan panel will automatically add to the names of the backup files the date and hour of the backup (for the all-time hour).
   • Attached the backup file. If you want to open a large volume of archives, indicate the size of the volume in megabytes by the warrant officer.
   • Easy to save the backup file. Viber the map until you need to save the backup file.
   • Yakі danі must be included before the backup copy. You can set up a backup copy from setting up a web hosting, or setting up a web hosting all at once from the use of data from koristuvachiv.
   • By email when the backup is complete. If it is necessary, if the backup copy is finished, it will be sent by e-mail, enter the required address e-mail.
   • Block the website until the backup is complete. Put the foreman at the whole field, if you need to fence the criminals to replace the content or set up the website for an hour of backup. *
4. Natisnit Backup copy... The backup process will be started. Information about the status of the visitor will be shown on the insert Stream backup... Push the button Onoviti, how about new data, which are displayed on the screen.
5. When the backup is completed, the backup file will be saved to your selected file, and access to it can be read through an FTP server or distributed Domains>im'yadomain> Backup Manager.

For that schob update Data from the backup file:

1. Go to distribution Domains > im'ya domain >Manager backup copy.

1. Oberit required file backup copy.
2. Set these parameters:
   • Tipi danikh, as it is necessary to update.
   • Block the domain (website) until the completion of the renewal Viber opt-in, if you want to avoid conflicts, as you can win, if you change your website, or if you want to change it, if you see an updated website. *
   • Support is provided for the electronic mailing of the update. Enter your e-mail address, as the Keruvannya panel overrides when the update is completed.
   • Conflict policy Please note that it’s going to work in the event of a confl ict every hour of renewal.
3. Natisnit Vidnoviti.

   As soon as the process of renewal of the dues is getting confused, the maister will send the message to the confirmation of the problem. Follow the instructions on the screen to complete the master's robot.

   Note : The overwrite mode before the hour of updating the data means that from the backup copy all the objects will be updated regardless of what the system stinks at the time of the update. The overwrite mode is like this:

   • If the backup file is not set up in Parallels Plesk Panel, the stench will be installed in Parallels Plesk Panel.
   • If you have set up the backup file in Parallels Plesk Panel, you can also overwrite the backup file from the backup file in Parallels Plesk Panel.
   • If you have an object or set up є for Parallels Plesk Panel, if you see a backup file, then you can’t change it for Parallels Plesk Panel.

Shlyakh for the base of the backup copy, you can vibrate, for example, httpsdocs (root is not available for recording):
/ home / vhosts / your_domain / httpsdocs / backup

* If this option is enabled, the domain will be unlocked for a year. Not recommended for victorian, because when the archiving process changes, it can automatically unlock.

Beast of respect, for backup copies, with the help of the Client, to enter the disk quota (disk space). System backups do not enter the quota.

If you have a power supply, go to life