10
Am reading the installation instructions for SL 2018 CU1
The article refers to Knowledge Base Article 916090
However this does not come up on the North America Microsoft Knowledgebase.
*This post is locked for comments
Hello PelicanPete,
Perhaps it would be helpful - Its a long one.
How to prepare a database so that you can upload the database at the request of a support professional in Microsoft Dynamics SL
View products that this article applies to.
Article ID : 916090
First Published: : 3/4/2006
Last Revised: : 1/3/2015
INTRODUCTION
This article describes how to prepare databases for upload to Microsoft Dynamics SL (Solomon) Technical Support when requested. This article explains how to create a backup, and then how to compress the backup files.
MORE INFORMATION
To prepare a database so that you can upload the database, use the method for the version of Microsoft SQL Server that you are using.
Method 1: How to prepare a database in SQL Server 2005 or in SQL Server 2008
1. Identify the database recovery model for the application database. To do this, follow these steps:
a. Start SQL Server Management Studio.
b. In the Object Explorer pane, expand Databases , right-click the appropriate database, and then click Properties .
c. In the Database Properties dialog box, click Options in the Select a page pane.
d. Note the value in the Recovery model box:
• If Full is selected in the Recovery model box, close the Database Properties dialog box, and then go to step 2. You must back up the transaction log separately from the database to maximize the amount of space that is used on the server.
• If Simple is selected in the Recovery model box, close the Database Properties dialog box, and then go to step 3.
Note The default value in the Recovery model box is Full .
2. Back up the transaction log for the application database. To do this, follow these steps:
a. Right-click the appropriate database, point to Tasks , and then click Back Up .
b. In the Back Up Database dialog box, select the appropriate database in the Database box under Source .
c. In the Backup type box, select Transaction Log .
d. Under Destination , click Add to specify the location and the file name of the backup file for the transaction log.
e. In the Select a page pane, click Options .
f. Under Transaction Log , click Truncate the transaction log , and then click OK .
3. Back up the application database. To do this, follow these steps:
a. Right-click the appropriate database, point to Tasks , and then click Back Up .
b. In the Back Up Database dialog box, select the appropriate database in the Database box under Source .
c. In the Backup type box, select Full .
d. Under Destination , click Add to specify the location and the file name of the backup file for the transaction log.
e. Click OK .
4. Repeat steps 1 through 3 to back up the system database.
5. Compress the databases by using a compression program such as WinZip or WinRAR. Do not use PKWARE PKZip. You do not have to include the backup of the transaction log that you created in step 2. You only have to include the backup of the database that you created in step 3.
Note WinRAR compresses files that are too large for WinZip to compress.
6. Upload the compressed databases by following the instructions in the e-mail that you received from mbsitmsg@microsoft.com. The e-mail contains the following title: "You are being invited to upload file(s)."
Method 2: How to prepare a database in SQL Server 2000
1. Identify the database recovery model for the application database. To do this, follow these steps:
a. Start SQL Server Enterprise Manager.
b. Expand Microsoft SQL Servers , expand SQL Server Group , expand the instance of SQL Server, and then expand Databases .
c. Right-click the appropriate database, and then click Properties .
d. In the Database Properties dialog box, click the Options tab.
e. Under Recovery , note the value in the Model box:
• If Full is selected in the Model box, close the Database Properties dialog box, and then go to step 2. You must back up the transaction log separately from the database to maximize the amount of space that is used on the server.
• If Simple is selected in the Model box, close the Database Properties dialog box, and then go to step 3.
Note The default value in the Model box is Full.
2. Back up the transaction log for the application database. To do this, follow these steps:
a. Right-click the appropriate database, point to Tasks , and then click Back Up Database .
b. In the SQL Server Backup dialog box, verify that the appropriate database appears in the Database box.
c. Under Backup , click Transaction log .
d. Under Destination , click Add to specify the location and the file name of the backup file for the transaction log.
e. Click OK .
3. Back up the application database. To do this, follow these steps:
a. Right-click the appropriate database, point to All Tasks , and then click Backup Database .
b. In the SQL Server Backup dialog box, verify that the appropriate database appears in the Database box.
c. Under Backup , click Database - complete .
d. Under Destination , click Add to specify the location and the file name of the backup file for the transaction log.
e. Click OK .
4. Repeat steps 1 through 3 to back up the system database.
5. Compress the databases by using a compression program such as WinZip, WinRAR, or WinACE. Do not use GZip or PKWARE PKZip. You do not have to include the backup of the transaction log that you created in step 2. You only have to include the backup of the database that you created in step 3.
Note WinRAR compresses files that are too large for WinZip to compress.
6. Upload the compressed databases by following the instructions in the e-mail that you received from mbsitmsg@microsoft.com. The e-mail contains the following title: "You are being invited to upload file(s)."
The third-party products that this article discusses are manufactured by companies that are independent of Microsoft. Microsoft makes no warranty, implied or otherwise, about the performance or reliability of these products.
REFERENCES
For more information about data recovery models, visit the following Microsoft Web site:
For more information about the data recovery models in SQL Server, see the following topics in SQL Server Books Online:
• Selecting a recovery model
• Simple recovery
• Full recovery
• Bulk-logged recovery
• Switching recovery models
Best Regards,
Jana MacDonald
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
290,946
Super User 2024 Season 2
#2
Martin Dráb
229,426
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
