2. Copy the file path to where you want the backup to be located.
The provided example uses the following name and location: C:\Manex\SQLData\v2021_06_21\
3. On the script, you are going to paste your file path and then add the name for it. Also, make sure it is pointing to the correct database that you want to backup.
4. Then depress "Execute."
5. You should get the following message at the bottom of the screen: "Query executed successfully"
6. You should be able to open that folder listed in the file path and find your backup. See example below:
If you were to upload your backup to CRM, you need to convert it to a zip file. (Make sure you have 7zip downloaded)
1. Open 7zip and find the backup you created.
2. Once you find you backup on 7zip, you can right click on the backup and choose add to “filename.7z”
3. This will compress it to a zip file and you can upload that to CRM.
Attachments:
SQL_DB_backup.sql