Current location - Loan Platform Complete Network - Big data management - SQL database log file Can you delete it?
SQL database log file Can you delete it?

Yes

Open?SQL?Server?Management?Studio and connect to the Database Engine database.

Expand the Database node in the Object Explorer pane.

Right-click on the database you want to modify, select the "Properties" command in the pop-up shortcut menu to open the "Database Properties" dialog box, select the "File" option. The file settings interface is displayed.

To add a file, click the "Add" button, in the "Database Files" list box will appear a new file, set the parameters of the file can be.

To delete a file, select the file you want to delete and click the "Delete" button. It is important to note that when deleting data files and log files, you must make sure that the files do not contain data or logs, i.e., they are empty files.

Complete the corresponding operation, click "OK" button.

References

SQL database log files, can they be deleted? Baidu experience[cited 2018-1-3]