{"id":2389,"date":"2012-01-06T10:10:14","date_gmt":"2012-01-06T18:10:14","guid":{"rendered":"http:\/\/www.technosolutions.com\/kb\/2389\/how-to-apply-fix-patch-on-sql-server-database\/"},"modified":"2016-12-01T23:20:40","modified_gmt":"2016-12-02T07:20:40","slug":"how-to-apply-a-fix-patch-on-sql-server-database","status":"publish","type":"post","link":"http:\/\/www.technosolutions.com\/kb\/2389\/how-to-apply-a-fix-patch-on-sql-server-database\/","title":{"rendered":"How to apply a fix patch on SQL Server Database"},"content":{"rendered":"

<\/p>\n

\n
\n

What is this article about?<\/h3>\n
\n

This article describes the procedure to apply a fix patch on SQL Server Database<\/em>.<\/p>\n<\/div>\n<\/div>\n

\n

Who should read this?<\/h3>\n
\n
    \n
  • Database Administrators<\/li>\n
  • TopTeam Administrators<\/li>\n<\/ul>\n<\/div>\n<\/div>\n
    \n

    Prerequisites<\/h3>\n
    \n
      \n
    • Ensure that all the users are disconnected from TopTeam Application Server<\/em>, while applying this upgrade fix patch.<\/li>\n
    • It is recommended that you must take a backup of the database.<\/strong><\/li>\n<\/ul>\n<\/div>\n<\/div>\n
      \n

      Step 1. Download the fix patch utility from the link provided by TechnoSolutions Support<\/h3>\n<\/div>\n
      \n

      Step 2. Extract the downloaded DB Schema upgrade patch<\/h3>\n
      \"wpid2379-media_1316169496332.png\"<\/div>\n
      \n

      Verify the structure of the extracted folder as shown in the above screen.<\/p>\n<\/div>\n<\/div>\n

      \n

      Step 3. Welcome to the SQL Server DB Schema Installer<\/h3>\n
      \"wpid2380-media_1316169565314.png\"<\/div>\n
      \n<\/div>\n<\/div>\n
      \n

      Step 4. Choose Apply patch to or upgrade existing database schema<\/h3>\n
      \"wpid2381-media_1316169729960.png\"<\/div>\n
      \n<\/div>\n<\/div>\n
      \n

      Step 5. Backup the existing database schema<\/h3>\n
      \"wpid2382-media_1316169850051.png\"<\/div>\n
      \n

      It is highly recommended the you take a backup of TopTeam Database <\/em>before upgrading.<\/p>\n<\/div>\n<\/div>\n

      \n

      Step 6. Login to Repository Schema<\/h3>\n
      \"wpid2387-media_1325602960227.png\"<\/div>\n
      \n<\/div>\n<\/div>\n
      \n

      Step 7. Select Repository Database Name<\/h3>\n
      \"wpid2383-media_1316170057172.png\"<\/div>\n
      \n<\/div>\n<\/div>\n
      \n

      View Scripts Files (optional)<\/h3>\n
      \"wpid2384-media_1316170092926.png\"<\/div>\n
      \n<\/div>\n<\/div>\n
      \n

      Step 8. Apply the patch<\/h3>\n
      \"wpid2388-media_1325603155732.png\"<\/div>\n
      \n<\/div>\n<\/div>\n
      \n

      Step 9. Finish the wizard<\/h3>\n
      \"wpid2385-media_1325254204201.png\"<\/div>\n
      \n<\/div>\n<\/div>\n
      \n

      Step 10. Log Files<\/h3>\n
      \"wpid2386-media_1325254253516.png\"<\/div>\n
      \n

      The log file is created in the following folder:
      \nC:\\\u2026\\My Documents\\TechnoSolutions\\DB Schema Installer<\/p>\n

      In case you face any difficulty in upgrading TopTeam Database<\/em>, TopTeam Support<\/em> will need this log file to analyze the problem.
      \nKeep a backup of this file for future reference.<\/p>\n<\/div>\n<\/div>\n

      \n
      \n

      Revised: September 7th, 2015<\/p>\n<\/div>\n<\/div>\n<\/div>\n

      <\/p>\n","protected":false},"excerpt":{"rendered":"

      What is this article about? This article describes the procedure to apply a fix patch on SQL Server Database. Who should read this? Database Administrators TopTeam Administrators Prerequisites Ensure that all the users are disconnected from TopTeam Application Server, while applying this upgrade fix patch. It is recommended that you must take a backup of the database. Step 1. Download the fix patch utility from the link provided by TechnoSolutions Support Step 2. Extract the downloaded DB Schema upgrade patch Verify the structure of the extracted folder as shown in the above screen. Step 3. Welcome to the SQL Server <\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[5],"tags":[281,9],"class_list":["post-2389","post","type-post","status-publish","format-standard","hentry","category-database","tag-database","tag-sql-server"],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/paoaNA-Cx","_links":{"self":[{"href":"http:\/\/www.technosolutions.com\/kb\/wp-json\/wp\/v2\/posts\/2389","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.technosolutions.com\/kb\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.technosolutions.com\/kb\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.technosolutions.com\/kb\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"http:\/\/www.technosolutions.com\/kb\/wp-json\/wp\/v2\/comments?post=2389"}],"version-history":[{"count":3,"href":"http:\/\/www.technosolutions.com\/kb\/wp-json\/wp\/v2\/posts\/2389\/revisions"}],"predecessor-version":[{"id":30055,"href":"http:\/\/www.technosolutions.com\/kb\/wp-json\/wp\/v2\/posts\/2389\/revisions\/30055"}],"wp:attachment":[{"href":"http:\/\/www.technosolutions.com\/kb\/wp-json\/wp\/v2\/media?parent=2389"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.technosolutions.com\/kb\/wp-json\/wp\/v2\/categories?post=2389"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.technosolutions.com\/kb\/wp-json\/wp\/v2\/tags?post=2389"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}