{"id":845,"date":"2011-10-23T05:45:55","date_gmt":"2011-10-23T10:45:55","guid":{"rendered":"http:\/\/swildow.darktech.org\/wp\/?p=845"},"modified":"2011-10-23T05:45:55","modified_gmt":"2011-10-23T10:45:55","slug":"how-do-i-use-microsoft-sql-server-management-studio-express-for-prosystem-fx-practice-management-sql-database-backups","status":"publish","type":"post","link":"http:\/\/www.wildow.com\/blog\/?p=845","title":{"rendered":"How do I use Microsoft SQL Server Management Studio Express for ProSystem fx Practice Management SQL Database Backups?"},"content":{"rendered":"
How do I use Microsoft SQL Server Management Studio Express for ProSystem fx Practice Management SQL Database Backups?<\/div>\n
\n
\n

Article Information<\/h1>\n\n\n\n\n\n\n\n\n\n\n
Article ID:<\/td>\nsw32822<\/td>\n<\/tr>\n
Last Modified:<\/td>\nApril 6, 2011<\/td>\n<\/tr>\n
AID:<\/td>\nsb20110406<\/td>\n<\/tr>\n
Direct Link:<\/td>\nClick to view<\/td>\n<\/tr>\n
<\/td>\n<\/tr>\n
\n
\n<\/td>\n<\/tr>\n
E-Mail Article<\/td>\n<\/tr>\n
Printable View<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n

Download and Install<\/strong><\/p>\n

<\/p>\n

SQL Management Studio Express is a free download from the Microsoft website. Follow these<\/p>\n

instructions to download and install SQL Management Studio Express on your Server.<\/p>\n

 <\/p>\n

    \n
  1. Go to the Microsoft site at\u00a0http:\/\/www.microsoft.com<\/li>\n
  2. Select\u00a0Downloads & Trials<\/strong>\u00a0on the main Microsoft webpage.<\/li>\n
  3. Select the\u00a0Download Center<\/strong>.<\/li>\n
  4. Search for\u00a0Management Studio<\/strong>\u00a0to find this tool in the list of available downloads. The first result will be for\u00a0Microsoft SQL Server Management Studio Express<\/strong>.<\/li>\n
  5. Select this tool. Read the Overview and Instructions. Note that because you have installed ProSystem\u00a0fx<\/em>\u00a0Practice Management, you will have already installed SQL Server 2005 and.NET Framework 2.0 on the Server.<\/li>\n
  6. Download this tool to the\u00a0Server<\/strong>\u00a0by clicking the\u00a0SQLServer2005_SSMSE.msi<\/strong>\u00a0Download button.<\/li>\n
  7. Once the tool is downloaded you are ready to install. Select\u00a0Run<\/strong>. A wizard displays, walking you through the installation process. Accept the license agreement and follow the instructions to install\u00a0SQL Server Management Studio Express<\/strong>\u00a0on your\u00a0Server<\/strong>. Do not install to a workstation.<\/li>\n<\/ol>\n

     <\/p>\n

    Back up<\/strong><\/p>\n

     <\/p>\n

    Follow these instructions to make your nightly backups at your firm.<\/p>\n

     <\/p>\n

      \n
    1. Select\u00a0Microsoft SQL Server 2005\u00a0from the\u00a0Start\/Programs\u00a0menu. Then select\u00a0SQL Server Management Studio Express.<\/li>\n
    2. The\u00a0Connect to Database\u00a0window displays.<\/li>\n
    3. Server name\u00a0displays your\u00a0ProSystem\u00a0fx<\/em>\u00a0Practice Management Server\u00a0name. Accept this default.<\/li>\n
    4. Authentication\u00a0displays the default of\u00a0Windows Authentication. Accept the default.<\/li>\n
    5. Click\u00a0Connect\u00a0to connect to the database.<\/li>\n
    6. Click\u00a0Databases<\/strong>\u00a0in the navigation bar to expand the list of available SQL databases.<\/li>\n
    7. Right-click your firm\u2019s ProSystem\u00a0fx<\/em>\u00a0Practice Management SQL database and select\u00a0Task<\/strong>\u00a0from the right-click menu. Then select\u00a0Back Up<\/strong>.<\/li>\n
    8. Use the\u00a0Back Up Database<\/strong>\u00a0window to make your backup instructions. Two windows are available from the navigation pane (General<\/strong>\u00a0andOptions<\/strong>).<\/li>\n
    9. Use the\u00a0General<\/strong>\u00a0window to select the Backup type and backup file Destination.<\/li>\n
    10. Verify the\u00a0Database<\/strong>\u00a0name on the\u00a0General<\/strong>\u00a0window. Notice that the ProSystem\u00a0fx<\/em>\u00a0Practice Management SQL database selected in Step 7 will be selected by default.<\/li>\n
    11. Use the\u00a0Description<\/strong>\u00a0box on the\u00a0General<\/strong>\u00a0window to enter a description of the backup.<\/li>\n
    12. Specify when the\u00a0Backup set will expire<\/strong>. Notice that the default value of\u00a00<\/strong>\u00a0means that the backup will never expire.<\/li>\n
    13. Select the\u00a0Options<\/strong>\u00a0window to set Overwrite and Reliability options. Make sure you select to\u00a0Overwrite all existing backup sets<\/strong>\u00a0so that your backups will overwrite and not append. You may also want to select to verify the backup when it is finished to make sure your backup will be available should you need to restore it.<\/li>\n
    14. Click the\u00a0Help<\/strong>\u00a0icon at the top of the window for online Help and more information on backing up and restoring databases. A\u00a0See Also<\/strong>\u00a0list ofTasks<\/strong>\u00a0is available in Help with detailed \u201cHow To\u201d instructions on creating a Full Database Backup and restoring a Database Backup.<\/li>\n
    15. If you want to back up manually, click\u00a0OK<\/strong>\u00a0to make the backup. To automate the backup, continue with the instructions for\u00a0Automatic Backup<\/strong>.<\/li>\n
    16. A message displays when the backup is successfully completed and a log displays backup task information.<\/li>\n<\/ol>\n

       <\/p>\n

      Automatic Backup<\/strong><\/p>\n

       <\/p>\n

        \n
      1. Follow Steps 1-15 above to build the backup instructions.<\/li>\n
      2. Save your backup instructions to a Script so that you can select the script to run the backup in the future by clicking the drop-down\u00a0Script<\/strong>\u00a0arrow at the top of the window and selecting\u00a0Script Action to File<\/strong>.<\/li>\n
      3. If you have not already done so, create a special SQL Backup folder on the Server. You can use the\u00a0Create New Folder<\/strong>\u00a0icon on the\u00a0Save As<\/strong>window. Browse to the location on your Server and enter the folder name (for example,\u00a0PMBackup<\/strong>). Make sure that your folder (path) name does not contain any spaces.<\/li>\n
      4. Enter the name of your backup script (for example,\u00a0SQLBackup)<\/strong>\u00a0and click\u00a0Save<\/strong>. Your script will be saved with a .SQL file extension.<\/li>\n
      5. Close SQL Management Studio Express.<\/li>\n
      6. Use Notepad or the editor of your choice to create a batch file using the script file you created.<\/li>\n<\/ol>\n

        In the batch file, enter the following command:<\/p>\n

         <\/p>\n

        SQLCMD.EXE \u2013S<\/strong>\u00a0YourServer\\Instance<\/em>\u00a0\u2013i<\/strong>\u00a0path\\script.sql<\/em><\/p>\n

        \u00a0<\/em><\/p>\n

        Where:<\/p>\n

        YourServer\\Instance<\/em>\u00a0is your\u00a0Server name\\Instance<\/strong>\u00a0(for example,\u00a0Server\\PracticeMgmt<\/strong>)<\/p>\n

        and<\/p>\n

        path\\script.sql<\/em>\u00a0is the path and name of the script created in Step 4 (for example,<\/p>\n

        c:\\PMBackup\\SQLBackup.sql<\/strong>)<\/p>\n

         <\/p>\n

        Note<\/strong>:The command is case sensitive and the \u201c\u2013S\u201d must be upper case while the \u201c-i\u201d is<\/em><\/p>\n

        lowercase.<\/em><\/p>\n

         <\/p>\n

          \n
        1. Save your batch file with a\u00a0.BAT<\/strong>\u00a0file extension. You may want to store it in the same SQL backup directory as the Script file created in Step 3 above.<\/li>\n
        2. On the Server, from the\u00a0Start<\/strong>\u00a0menu, open\u00a0Control Panel<\/strong>\u00a0and select\u00a0Scheduled Tasks<\/strong>. This opens the Windows Task Scheduler. Make sure you are scheduling the backup on the Server and not a workstation as the backup will not run properly from a workstation.<\/li>\n
        3. Select to\u00a0Add Scheduled Task<\/strong>. Follow the directions in the Wizard to add the backup as a scheduled task on the Server. Click\u00a0Next<\/strong>\u00a0to continue.<\/li>\n
        4. Browse to the\u00a0.BAT<\/strong>\u00a0file you created for the Script and select it as the program to run.<\/li>\n
        5. Enter a name for the task and select how often to perform this task (Daily, Weekly, etc.) and click\u00a0Next<\/strong>.<\/li>\n
        6. Select the day and time when you want this task to start and click\u00a0Next<\/strong>.<\/li>\n
        7. Enter the name and password of a user on the system. The task will run as if started by the user\/password you enter here. You must enter this information for the task. The backup will not run as scheduled if the password is not entered. Then click\u00a0Next<\/strong>.<\/li>\n
        8. Click\u00a0Finish<\/strong>\u00a0to complete the Wizard.<\/li>\n
        9. Your backup will be made in the Destination folder you specified in\u00a0Step 9 (Back Up<\/strong>).<\/li>\n
        10. Verify the backup and make sure it is running properly. Also make sure you can restore from the backup.<\/li>\n<\/ol>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

          How do I use Microsoft SQL Server Management Studio Express for ProSystem fx Practice Management SQL Database Backups? Article Information Article ID: sw32822 Last Modified: April 6, 2011 AID: sb20110406 Direct Link: Click to view E-Mail Article Printable View Download … Read More »<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-845","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"_links":{"self":[{"href":"http:\/\/www.wildow.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/845","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.wildow.com\/blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.wildow.com\/blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.wildow.com\/blog\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.wildow.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=845"}],"version-history":[{"count":1,"href":"http:\/\/www.wildow.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/845\/revisions"}],"predecessor-version":[{"id":846,"href":"http:\/\/www.wildow.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/845\/revisions\/846"}],"wp:attachment":[{"href":"http:\/\/www.wildow.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=845"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.wildow.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=845"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.wildow.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=845"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}