MSSQL backup export Shell Chinese path Solution

Source: Internet
Author: User

After some tossing, we will finally find the relevant method. It is estimated that many of you have known it for a long time. MARK it.
 
A school changed its website program, causing me to try again. The old method is to download any file to the database configuration file, connect to the database, database permissions, and back up and export shell through www.2cto.com.
 
 
 
During the export process, an error occurred while backing up to the Chinese path using the Nine-step manual differential backup method forwarded by multiple online users, prompting that the device cannot be turned on, after decoding SQL _encode, the encoded path d: \ \ x is found. asp changed to d :\
 
 
 
You can change the Export Statement to the same principle, but the method is different.
 
Backup database czwj to disk = 'd: \ \ x. asp 'with differential, FORMAT;
 
 
 
I found that there are multiple errors or deficiencies in some articles, and I have to find the information and make careful correction.

Author wdlei

Related Article

Contact Us

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.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.