There are two approaches to restore the original A / C set information after the UFIDA server fails.

1. If the program is reinstalled consciously, the original set of books must be backed up just before reinstallation. For the backup approach, register as admin in the technique management and export the account set for the specified directory. Right after the method is reinstalled, the backup account set is re-introduced in to the program management.

Second, if the server is paralyzed on account of abnormal circumstances, even worse, the economic information is just not backed up. The solution is as follows:

Very first of all, you ought to rescue the monetary information. You need to know what drive letter the original monetary method is installed in. If it can be around the system drive (C: /) (or you might be not positive), it is actually advised to uninstall the server hard drive and hang it on a usable laptop , Copy each of the WF821 folders beneath the UFIDA installation directory; if it really is not in the method disk, you'll be able to directly reinstall the technique.

Immediately after reinstalling the system, install SQLSERVER first, and then install UFIDA method. To be able to stay clear of other failures following installation, it really is ordinarily installed on the original drive letter path.

Open the Enterprise Manager and proceed as follows:

1. Delete the UFSub and ufsystem in the database (for insurance purposes, you could back up initially, and then delete soon after replacement);

2. Attach the corresponding UFSub and ufsystem inside the Admin folder from the original installation directory to the database (appropriate click around the database-all tasks-attach the database);

3. Attach all original account database files in the original account set storage directory (frequently ZT001);

4. Expand the ufsystem database, come across the table UA_acount, return all of the rows and open it, confirm irrespective of whether the account set path is in the UFIDA installation drive, if it is actually inconsistent, you'll be able to directly modify it;

five. Re-configure the remote configuration inside the client system management (no matter whether or not the server name is changed), open the UFO on the server, and redefine the initial account set quantity (the default is 999 soon after reinstallation).

Test irrespective of whether the other functions on the A / C set are readily available right after the reinstallation around the server side plus the client side, and the A / C set recovery is comprehensive.

Inside the era of computerized accounting, the financial details of enterprises for several years is concentrated in a tough disk, and financial personnel should recognize the vulnerability of electronic data. For the protection of monetary information under computerization, I have the following ideas:

1. Frequently print vouchers, books and reports;

two. Set up the dual tough disk image from the financial server;

three. In the end of each and every fiscal year, burn the carried forward annual account data to disk, and make a minimum of two copies to be saved in unique space locations;

4. Back up the existing annual account each week (So that you can steer clear of manual backup slack, it really is encouraged to start the SQLServer and SQLServerAgent solutions at the very same time and setup an automatic database backup program);

five. Routinely copy the server difficult disk data to other external storage components (for instance mobile difficult disk);

six. If conditions permit, a backup server may be set up.

Within the case of only .MDF and .ldf, backup and restore the database. The UFIDA software program can not commence usually as a result of a virus dilemma. The system management cannot be entered. Consequently, the information can't be backed up typically. At this time, an more database is necessary. The database is associated with the UFIDA software through the more database. The steps are as follows: The content material below the ADMIN folder beneath the computer software is mainly the * .mdf and * .ldf files.For UFIDA Common 2005, it includes the method information UfSystem.MDF and UfSystem.ldf and also the contents under every single account set. 2 'Reinstall the system and software 3' Copy the files back to the original place. 4 'Attach the database by querying the analyzer SQL statement, or attach the database by Enterprise Manager / Server / Database / Correct click / More database.

example:

By way of the query analyzer SQL statement:

--sp_attach_db 'ufsystem', 'D: \\ UF2000 \\ Admin \\ ufsystem.mdf', 'D: \\ UF2000 \\ Admin \\ ufsystem.ldf'

// The very first line 'ufsystem' could be the system database name, 'D: \\ UF2000 \\ Admin' would be the physical address.

--sp_detach_db 'ufsystem'

// The second line, when the very first line is executed, it prompts that ufsystem already exists, so delete ufsystem, but pay attention, the redo system will have to be the identical as the preceding program. Otherwise, it may not be restored.

--sp_attach_db 'ufdata_001_2002', 'D: \\ UF2000 \\ Admin \\ ZT001 \\ 2002 \\ ufdata.mdf', 'D: \\ UF2000 \\ Admin \\ ZT001 \\ 2002 \\ ufdata.ldf'

// The third line 'ufdata_001_2002' may be the database of 001 account set 2002. 'D: \\ UF2000 \\ Admin \\ ZT001 \\ 2002' will be the physical address.

Precisely the same is accurate for other sets of books. best data recovery software in between was added on December 21.

The user sets the password of the SQLserver super user SA. Every person knows that after setting the SA password, it can be really inconvenient when other software program uses the SQLserver database. Therefore, the SA password have to be cleared. The strategy is: open the enterprise manager, and then open SQLserver group, open security, open login, right-click on SA, pick properties, clear the password items, and after that confirm

The above content material is taken from: http://xmsoft.blog.bokee.net/bloggermodule/blog_viewblog.do?id=2853530

About accidental operation

When the installation is complete, please do not uninstall or reinstall MicrosoftSQLServer7.0 effortlessly to prevent the loss of the connection involving the database of UFIDA U8 Management Software program 8.21 and MicrosoftSQLServer7.0. For those who should uninstall or reinstall, please use system management to carry out data backup very first. Or make use of the backup tool of MicrosoftSQLServer7.0 to create a comprehensive backup from the program database and user database (an additional shortcut would be to only backup the Master library).

If MicrosoftSQLServer7.0 must be reinstalled because of accidental harm or deletion, you are able to use System (32) \\ UFAdmSql \\ UFAttach.exe immediately after the reinstallation to restore the information connection (supplied that the program database and user database are intact and not damaged mobile).

Usually do not perform the following operations: first close MicrosoftSQLServer7.0, and then manually delete the database file of UFIDA U8 management software program 8.21 (if only the LDF file is often restored, see the following directions; if the MDF file is deleted, it can't be restored), or execute the DropDatabase command Delete the database file accidentally. The resulting information loss could be the responsibility with the user.

Tips on how to take care of LDF file loss: One example is, UFSub, if its database log file UFSub.LDF is lost, then the very first time UFSub is made use of soon after the loss, SQLServer7.0 automatically generates a default LDF file-UFSub_Log.LDF. the site to the fact we agree that the key file name of the MDF file plus the LDF file should be exactly the same, you only have to manually modify the file name UFSub_Log.LDF to UFSub.LDF, and then run UFAttach.exe. This process also applies to system databases and user databases.

Do not perform the following operations: When operating UFIDA U8 management computer software 8.21, use the SQLServer7.0 tool to modify the sa user password. Doing so may lead to unexpected errors in the program operation. Normally speaking, you only must preserve the technique administrator password within the program management program.

About data upgrade

When the UFIDA U8 management computer software eight.21 user must migrate existing data in the Access platform towards the SQLServer7.0 platform, it is essential to retain the UFData.mdb under the annual path of the A / C set along with the UFSystem.mdb file under the program path in order to upgrade the information When used. By no means change the path of UFData.mdb; for those who modify the path of UFSystem.mdb, the data upgrade program will ask for its path.

Prior to uninstalling UFIDA U8 management software program, it really is most effective to get rid of the program administrator (ADMIN) password just before 8.21. If it's not removed, you can find the following situations: When the user uninstalls on the machine where the UFIDA U8 management computer software was originally installed, then install the UFIDA U8 management computer software V8.21 upgrades data, then there will likely be no dilemma; if the user backs up UFData.mdb and UFSystem.mdb and upgrades to yet another machine, except that UFData.mdb is place inside the original path, please use ACCESS97 exclusively Open UFSYSTEM.MDB, UFDATA.MDB, revoke the database password.

When choosing the annual path to upgrade the target A / C set, you can pick various possibilities. Which is, you may upgrade a number of A / C sets or various annual accounts at the exact same time, or you can choose only one. Press the Modify button to modify the target A / C set quantity, but not the year; after the target A / C set's annual library has been upgraded, it cannot be modified within the future. However, it is actually probable to upgrade the identical account set annual database repeatedly. To modify the target A / C set number, please very first position the vibrant bar around the corresponding A / C set.

If you will discover data errors in the Access database, for example the repeated abbreviation from the consumer or supplier, or the database will not be version eight.ten, or the database is damaged, then the information upgrade will report an error after which terminate. It is possible to right the error in the UFIDA U8 management software program eight.10 in accordance with the error data The information is modified. The upgrade log file is in the UFADMSQL directory under the method path, and also the file name is UPDATSQL.TXT.

Before performing Access = SQLServer information upgrade, please run \\ 8xxTo810 \\ Setment.exe of this installation disk (usually do not uninstall UFIDA U8 management software program eight.21). This program is usually a patch with the eight.0 / 8.0A = eight.10 upgrade system, which solves the issue of information upgrade related to buy settlement.

Files like the fixed asset printing template library under the A / C set path (all .rep and .vts files starting with FA) should also be kept and copied manually for the upgraded A / C set path immediately after the upgrade. Additionally, in the end in the month, the fixed assets checkout, if you need to restore the state prior to the checkout, it can be encouraged to resume inside the ACCESS version and then upgrade towards the SQL version.

Since the query syntax involved is extremely unique between ACCESS97 and SQLServer7.0, the previously defined user-defined account statements (made use of in account statement management) will not be automatically upgraded and call for customers to redefine them inside the SQL version.

⑤About carry-over final year

Troubles carried over within the earlier year are nevertheless handled with UFIDA U8 management software 8.20, or make contact with UFIDA agents and support.

⑥About version upkeep

Currently, UFIDA U8 management software program versions are: 8.0, eight.0A, eight.10, eight.ten (SQL), eight.11, 8.11A, eight.12, eight.12 (SQL), eight.13 (SQL), 8.20. Please do not set up two versions of UFIDA U8 management software on one particular machine at the exact same time, otherwise it might lead to conflicts of some system components. If this happens, please uninstall the older version initially and fully delete the relevant directories before reinstalling the newer version, or get in touch with your nearby UFIDA agent.

Special remind customers: the UFI U8 management software program eight.21 version installed on the server and also the client have to be constant, otherwise it can unquestionably cause challenges!

The above is taken from: http://bbs.iufida.com/thread-201-1-1.html

==

http://tianyuan8983031.blog.163.com/blog/static/297168220091094756598/