In preparation for upgrade testing, backing up your database is a very important step. Here are the steps to manually back up your SalesLogix MS SQL Server 2005 database to disk (SQL Server Management Studio):
1. Start | All Programs | MS SQl Server 2005 | SQL Server Management Studio
2. After connecting to the appropriate instance of the Microsoft SQL Server Database Engine in Object Explorer, click the server name to expand the server tree
3. Expand databases and highlight the appropriate SalesLogix database
4. Right-click the database, point to Tasks, and click Back Up. The ‘Back Up Database – SalesLogix’ dialog box appears
5. In the Database list box, verify the database name
6. You can perform a database backup for any recovery model, but in our case select or confirm FULL in the list box
7. In the Backup type list box, select Full
8. For Backup component, click Database
9. Either accept the default backup set name suggested in the Name text box, or enter a different name for the backup set
10. Optionally, in the Description text box, enter a description of the backup set
11. Ignore the information about when the backup set will expire, unless it is needed for some reason. Note: To have the backup set expire on a specific date, click On and enter the date on which the set will expire
12. Choose the type of backup destination by clicking Disk
13. To remove a backup destination, select it and click Remove
14. To view or select the advanced options, click Options in the Select a Page pane
15. Select an Overwrite Media option, by clicking one of the following:
16. Select Add to provide a destination for saving the database backup location
17. In the Select Backup Destination screen, select the square icon with four dots at the end
18. MSQL will open the Locate Data Files Dialog screen to the default location for backups. Make sure you choose a location that is local to the server and has adequate space
19. In the File Name text box enter the name of the database backup, like SalesLogixBackup20110426.bak
20. Select OK
21. Select OK
22. In the upper left hand side, select the Options page
23. Confirm Overwrite is selected
24. In the Reliability section, optionally check: Verify backup when finished. Perform checksum before writing to media and continue on checksum error
25. Select the General page again
26. Select OK
27. The database will back up and go through a verify phase. After it is completed, you will see a dialog, Microsoft SQL Server Management Studio, with the message, ‘The backup of database ’saleslogix’ completed successfully.’
28. Select OK
You have successfully completed a manual backup of your SalesLogix database!
If you would like to learn more tips, or have a CRM topic you would like us to write about, please contact Simplesoft Solutions, Inc. in one of our Cincinnati/Dayton (OH), Charleston (WV), or Charlotte (NC) surrounding area office locations:
Dayton, Ohio Office:
Simplesoft Solutions, Inc.
550 N. Main St. Suite A
Springboro, OH 45066
Phone: (937) 885-1204 x 3204
Fax: (937) 885-3580
sales@simplesoft.net
Ripley, WV Office:
Simplesoft Solutions, Inc.
710 Random Rd.
Ripley, WV 25271
Phone: (304) 521-2387
Fax: (937) 885-3580
sales@simplesoft.net
Charlotte, NC Office:
Simplesoft Solutions, Inc.
3635 Eastover Ridge Drive
Charlotte, NC 28211
Phone: (704) 910-3872
Fax: (937) 885-3580
sales@simplesoft.net



















