Got it

Huawei Enterprise Support Community

Community Forums Intelligent Collaboration

Disk space is insufficient

Created: May 23, 2019 03:19:16Latest reply: Jun 1, 2019 10:56:45 1370 3 12 0 0

View the author ^1#

Hello there, Community!

This post is about the issue that disk space is insufficient. Please see more details below.

SQL Server

ISSUE DESCRIPTION

The disk space is insufficient due to oversized SQL Server transaction logs, resulting in a data connection or read/write error.

ANALYSIS

After the SQL Server is running for a period of time, operations generate massive transaction logs that are stored in the ldf file. As the file is increasingly large, the disk space is insufficient, resulting in a data connection or read/write error.

SOLUTION

1. Choose Start > All Programs > Microsoft SQL Server 2008 > SQL Server Management Studio. Log in to the SQL Server Management Studio.

2. Right-click a database node, such as BMU, with oversized transaction logs.

3. Choose Tasks > Shrink > Database and perform the operation.

x
convention：
Emotion(0)

Like (12) Dislike (0) Favorite(0) Report

 Previous: Fail to execute the dual screen mode between monitor and Cloudlink Board

Next: How to Reset User Passwords on VCN500



(0) (0)

^2#

Steve001

Created May 23, 2019 06:44:35

is there any other reason that can result to read / write error in a data connection？

x
convention：

(0) (0)

^3#

picture_why

Created May 24, 2019 06:35:56

SQL Server transaction logs?

x
convention：

(0) (0)

^4#

umaryaqub

MVE Created Jun 1, 2019 10:56:45

How much can it shrink the transaction size?

x
convention：

Comment

Notice: To protect the legitimate rights and interests of you, the community, and third parties, do not release content that may bring legal risks to all parties, including but are not limited to the following:

Politically sensitive content
Content concerning pornography, gambling, and drug abuse
Content that may disclose or infringe upon others ' commercial secrets, intellectual properties, including trade marks, copyrights, and patents, and personal privacy

Do not share your account and password with others. All operations performed using your account will be regarded as your own actions and all consequences arising therefrom will be borne by you. For details, see " User Agreement."

My Followers

Are you sure to block this user?
Users on your blacklist cannot comment on your post,cannot mention you, cannot send you private messages.

Please bind your phone number to obtain invitation bonus.

Enterprise

Consumer

Corporate

Carriers

Disk space is insufficient

Third Party’s Trade Secret

My Followers