Experience with MS SQL Server?

Discussion in 'Acronis True Image Product Line' started by Adramalech, May 10, 2005.

Thread Status:
Not open for further replies.
  1. Adramalech

    Adramalech Registered Member

    Joined:
    Apr 17, 2005
    Posts:
    79
    Hi @all

    Does anybody have experience with MS SQL Server, regarding database inconsistency? There's an option to enter an executable before and after the snapshot, but not a command.

    Any suggestions?

    greetz
    Adra
     
  2. Acronis Support

    Acronis Support Acronis Support Staff

    Joined:
    Apr 28, 2004
    Posts:
    25,885
  3. napoleon

    napoleon Registered Member

    Joined:
    Mar 26, 2005
    Posts:
    110
    Beginning with Build 1124, you can write scripts to stop and restart the DB service and link them to an image job. This only happens for a few seconds when the image first kicks on. We use this for our SQL servers, as well as our Lotus Notes servers.
     
  4. Adramalech

    Adramalech Registered Member

    Joined:
    Apr 17, 2005
    Posts:
    79
    @napoleon

    Can you please give me an example of what this script has to look like for MS SQL? I'm not really that familiar with SQL.

    Thanks

    Adra
     
  5. napoleon

    napoleon Registered Member

    Joined:
    Mar 26, 2005
    Posts:
    110
    Sure. Download the manual for TI Enterprise Server here: http://www.acronis.com/enterprise/download/docs/

    When you open the document in Adobe, check out the script examples on Adobe page 42 (manual page 41). This should outline it for you fine. I hope this helps!
     
  6. Adramalech

    Adramalech Registered Member

    Joined:
    Apr 17, 2005
    Posts:
    79
    Yes, it helps. Thanks!

    So you're using the simple net stop/start command too? Did you ever try to restore the database? I'm hearing different stories from different kind of people (and the data is really high-risk)...
     
  7. Adramalech

    Adramalech Registered Member

    Joined:
    Apr 17, 2005
    Posts:
    79
    .....well, i'm going to test then. Thanks again ;)
     
  8. Acronis Support

    Acronis Support Acronis Support Staff

    Joined:
    Apr 28, 2004
    Posts:
    25,885
    Hello Adramalech,

    Thank you for choosing Acronis Enterprise Disk Backup Software.

    If you have any questions concerning our software, please feel free to contact us. We are always at your service should you have any further questions.

    Thank you.
    --
    Irina Shirokova
     
Thread Status:
Not open for further replies.