What to do if the database and relational layout are cleared

Ways to delete cache files on your phone:

Way 1To clean the cache in your phone's software: Settings - Find back to "Application Manager" - (All).

A - Select the name of the software that needs to delete the cache (in the case of the browser, select "Internet") - Storage) - Clear the cache.

Way 2Some machines have built-in smart managers (or memory managers) that delete unnecessary data such as caches.

Note: Please back up the important data in your phone before clearing the cache files to avoid data loss.

Teach you how to clear SQL logs.

1 Open Query Analyzer and enter commands.

dump transaction database name with no log

2.Then open Enterprise Manager -- right-click the database you want to compress -- All Tasks -- shrink the database -- shrink the file -- select the log file -- select Shrink to xxm in the shrink mode, here will give a minimum number of m that can be shrunk to, enter this number directly, OK.

There are two ways to clear the log:

1.Automatic removal method.

The trunc log on chkpt option is open to the database system, which automatically clears logs at regular intervals. The advantage of this method is that it does not require human intervention, it is automatically executed by SQL Server, and there is generally no log overflow. The disadvantage is that only the logs are cleared and no backups are made.

2.Manual removal method.

Run the dump transaction command to clear the log. The following two commands can clear the logs:

dump transaction with truncate_only

dump transaction with no_log

In general, the "dump transaction with trancate only" command can be used to delete the inactive parts of the transaction log, and this command is written into the transaction log with the necessary concurrency checks. Sybase provides "dump transaction with no log" to handle some very urgent cases, and using this command is very dangerous, SQL Server will pop up a warning message. To ensure database consistency as much as possible, you should use it as a "last resort".

If you want to back up logs, run the dump transaction database name to dumpdevice command.

There is no impact on the database after purging.

Many-to-one does not meet the design specifications of 2D tables, nor does it meet the unique business rules, so it is generally referred to as one-to-many.

For example, one person can have more than one bank card, but more than one person can use one bank card.

It's all about one-to-many.

Why? Grasp the main contradictions, and set an eye on the program.