future, make the following settings:
Enterprise Manager-server-right-click Database-properties-Option-select "auto contract"
-SQL statement setting method:
EXEC sp_dboption 'database name ',
'Autoshrink', 'true'
6. If you want to prevent the log from increasing too much in the future
Enterprise Manager-server-right-click Database-properties-transaction log
-Limit file growth to xM (x is the maximum data
This morning, I received an email indicating that the job failed to be executed. (The job still runs properly a few days ago. I do not know why the error occurred today)
The mail shows that the third step of the job reports an error.
Step 3:
Msdb. dbo. sp_send_dbmail@ Profile_name = 'seagull2dbmail ',@ Recipients = 'v-white Dan @ Subject = 'feedback the first 50 statements with long execution time ',@ File_attachments = '\ 10.0.9.20.\ bcp \ bcp_10.0.8.103 \ top_ SQL .xls'
Run the precedi
This morning, I received a message that the job failed to execute (I can still run the job a few days ago, I don't know why I made a mistake today)
The message shows that the third step of the job is an error.
Step3 content:
Msdb.dbo.sp_send_dbmail@profile_name = ' Seagull2dbmail ',@recipients = ' v Baidandan @subject = ' Feedback The first 50 execution time statements ',@file_attachments = ' \\10.0.9.137\bcp\bcp_10.0.8.103\top_sql.xls '
Execute the above statement separately, the error:
) { True if (! Directory.Exists (PATH)) { Try { Directory.CreateDirectory (path); } catch (Exception) { TODO: Handling Exceptions False } } return result; } }}-Also, you need to set the maximum allowable
For Asp.net, only 2 MB files can be uploaded by default. The following configuration is added. You can customize the maximum file size.
Executiontimeout = "300"
Maxrequestlength = "40960"
Usefullyqualifiedredirecturl = "false"/>
If not, you can use the solution provided by Si Gui:We encountered one or more problems when uploading large files. Setting a large v
(Customer information)
--Shrink the specified data file, 1 is the file number, you can query through this statement:
SELECT * FROM Sysfiles
DBCC Shrinkfile (1)
4. In order to maximize the reduction of log files (if it is SQL 7.0, this step can only be done in Query Analyzer)
A. Detaching a database:
Enterprise Manager--server--database--right key--detach database
B. Delete log files on my Computer
C. Addit
This article describes how to solve the problem that the file size exceeds the PHP limit when PHPMyAdmin is imported. The cause is that the PHP Upload size is limited to 2 MB and PHP is modified. ini configuration can solve this problem. if you need it, you can refer to the problem encountered when the website was migrated, because the data has been backed up and
Modify PHP.iniWin Platform Wamp Modification
Steps
Left clickwamp
Choosephp
In the pop-up window, selectphp.ini
Make changes in the open file (modify the steps below)
Change complete, Save and restartwamp
Mac MAMPStepsFile------Edit Template-------PHPChoose your own version toModify ContentUse the search function of the text Editing tool to find the following options to modify
Set
displayed. Enter this number directly and click OK.
You can also use SQL statements to complete-- Shrink DatabaseDBCC shrinkdatabase (database name)
-- Contract the specified data file. 1 is the file number. You can use this statement to query: Select * From sysfilesDBCC shrinkfile (1)
4. To minimize log files (for SQL 7.0, this step can only be performed in the query analyzer)A. Separate the databas
to complete
-- Shrink Database
Dbcc shrinkdatabase (customer profile)
-- Contract the specified data file. 1 indicates the file number. You can use this statement to query:
Select * from sysfiles
Dbcc shrinkfile (1)
4. To minimize log files (for SQL 7.0, this step can only be performed in the query analyzer)
A. Separate the database:
Enterprise Manager -- server -- database -- Right-click -- detach Databas
Modify the file upload size limit in IIS
Modify the file upload size limit-- IIS knowledge
After a Web project is deployed on the IIS server, sometimes the file fails to be uploaded on the page. This is because the IIS server has restrictions and is generally not recommend
Configure PHP.ini files (for example, files of the size of 500M below)
Look for the following options and modify the->
File_uploads = on; open File upload option
upload_max_filesize = 500M; upload file upper limit
If you want to upload a larger file, only the above two is not enough, the server cache must be the up
Open php.ini1. Maximum Upload file size:Upload_max_filesize=2mChange to the size you need2. Maximum Post size:Post_max_size=2mChange to the size you need, the second is generally larger than the first value3. There is also a placeMax_execution_time=30This is the
Configure the limit upload file size and time in the Web. config file.You need to set the file upload limit of two attribute values in the configuration file:Maxallowedcontentlength,maxrequestlength allows the length of the uploaded file, and the length of the request, two sizes need to be set consistent, if not consis
Shrinkfile (1)
4. In order to maximize the reduction of log files (if it is SQL 7.0, this step can only be done in Query Analyzer)
A. Detaching a database:
Enterprise Manager--server--database--right key--detach database
B. Delete log files on my Computer
C. Additional databases:
Enterprise Manager--server--database--right Key--additional database
This method will generate a new log with a size of more than 500 k
or in code:
The following exampl
1. Add the configuration size in the directory/etc/nginx/ngins.conf file (red labeled Configuration and location to add):HTTP {# Set MIME type, type defined by Mime.type fileInclude/etc/nginx/mime.types;Default_type Application/octet-stream;Client_max_body_size 100m;# Set Log formatLog_format Main ' $remote _addr-$remote _user [$time _local] "$request" '' $status $body _bytes_sent ' $http _referer '' "$http
The following small series for you to share an
ASP . NET control File Upload Size method (super Simple), with a good reference value, I hope to learn
from you to help. Follow the mini-compilation with friends who are interested in
ASP .
Add the following code under the System.Web node in Web. config:
The 2nd line of maxrequestlength= "8192", where the maximum
In the upload Nginx returned 413 error, view log file, the error message displayed is: "413 Request Entity Too Large", and then found the Internet under the "Nginx 413 error" To find the following settings:
In nginx.conf add client_max_body_size related settings, this value defaults to 1m, can be increased to 8m to increase the file size limit;
I set it to clie
Asp.net| Solution | upload
For ASP.net, the default is to upload only 2M files, add the following configuration, you can generally customize the maximum file size.
executiontimeout= "300"
Maxrequestlength= "40960"
Usefullyqualifiedredirecturl= "false"/>
If not, you can use the scenario provided by Shi:
We have had this or that problem when uploading large files.
1. Modify Max_execution_time
In PHP, the default page execution time is 30 seconds, more than 30 seconds, and the script stops executing.This will cause you to be unable to open the page. Then we can modify the Max_execution_timeLook in the php.ini.
Max_execution_time
The default is 30 seconds.
Max_execution_time = 0
0 means no Limit
2. Modify Post_max_size
Post_max_size sets the maximum size allowed
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.