简体中文(ZH-CN) English(EN) 繁体中文(ZH-TW) 日本語(JA) 한국어(KO) Melayu(MS) Français(FR) Deutsch(DE)
Home > Database > Mysql Tutorial > body text

mssql 收缩数据库与收缩数据和日志 sql语句

WBOY
Release： 2016-06-07 17:47:41
Original
1752 people have browsed it

mssql 收缩数据库与收缩数据和日志 sql语句本教程只讲取关于mssql server 数据库的收缩语句，索引重建的sql语，以及mssql server 收缩数据和日志的sql语句哦。

mssql 收缩与收缩数据和日志 sql语句本教程只讲取关于mssql server 数据库的收缩语句，索引重建的sql语，以及mssql server 收缩数据和日志的sql语句哦。

收缩数据库

--重建索引

dbcc reindex
dbcc indexdefrag

--收缩数据和日志

dbcc shrinkdb
dbcc shrinkfile

Related labels：
mssql data database log
source：php.cn
Previous article：php mssql 不能用 DB-Library（如 ISQL）或 ODBC 3.7 或更早版 Next article：sql delete删除语句详细语法
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Latest Articles by Author
Latest Issues
When using Laravel on Ubuntu, an unsupported property was specified on the PDO object: MSSQL My UbuntuvagrantLaravelHomestead setup is configured to connect to MSSQL. Randomly, it sta...
From 2023-10-30 23:05:50
0
1
256
SSL Provider Error: Certificate chain issued to MSSQL Server by an untrusted authority in PHP First of all, I'm really new to this. (sorry) Secondly, I tried to connect php to mssql se...
From 2023-10-30 18:03:00
0
2
251
Engage in PHP-based word processing I have retrieved data from MSSQL server table. Thanks to the query I am able to display th...
From 2023-09-02 22:45:43
0
2
235
The title is rewritten as: The Chinese translation of converting string to date is MYSQL function STR_TO_DATE I have this date in this: STR_TO_DATE('28-AUG-60','%d-%M-%y') When I insert into the table...
From 2023-09-02 11:09:45
0
1
179
Ask for alternatives mssql m request alternative mssql_data_seek,mssql_field_name,mssql_fetch_row
From 2021-07-16 18:37:33
0
1
898
Related Topics
More>
Popular Recommendations
Popular Tutorials
More>
Related Tutorials
Popular Recommendations
Latest courses
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template
About us Disclaimer Sitemap
php.cn：Public welfare online PHP training，Help PHP learners grow quickly！