Skip to Content
author's profile photo Former Member
Former Member

PO details missing after updating SQL

Hi all,

I encountered this problem of a client of ours after updating MSSql 2008 where some of the PO details were missing and also affects the amount of the POs.

.

Although the document is still 'Open-Printed', but the printout details which was printed before was different compared to the PO details now. And I would think maybe because of the update we had yesterday.

What could possibly gone wrong with this problem?

Just wanna know why. 'Cause maybe I could get an idea on how to restore all the original PO details without restoring the database or editing further the PO.

Thanks ahead for the responses!

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Feb 09, 2012 at 01:02 PM

    Hi,

    What do you mean by after updating SQL? As you are aware the altering tables of SBO

    may loss your SAP support.

    More details please.

    Thanks.

    Clint

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Feb 10, 2012 at 06:03 AM

    Hi Drei_FTconsultant,

    If you have backup of Live Database before updating SQL then Uninstall SQL server and Reinstall upgraded version of SQL then restore your Live Database its very easy way to achive your task....

    upgrading SQL with DB its compleceted....

    Thanks,

    Srujal Patel

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Yes. That what I thought. It's just that it wasn't really an upgrade like from MSSQL 2008 to MSSQL 2008 R2.

      Only we're updating the build/version. But in any case, we could have made a backup database before going to update SQL in live environment.

      Thanks for your suggestions though.

  • author's profile photo Former Member
    Former Member
    Posted on Feb 09, 2012 at 02:26 PM

    Hi,

    Please clarify for after updating MSSql 2008. Have you upgraded your SQL Server?

    Thanks,

    Gordon

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi,

      Please follow the suggestion of Srujal Patel.

      Try the following :

      1. Leave the SQL server original version. Dont upgrade yet.

      If already upgraded uninstall and restore original version.

      2. Backup live database, then detach your database.

      3. Upgrade your SQL Server.

      4. After upgrading is done. Restore your live database.

      5. Then test.

      Thanks.

      Clint

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.