Experience with MS SQL Server?

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

 

Hello Adra,

Thank you for choosing Acronis Disk Backup Software.

There should be no problems with Microsoft SQL Server if you suspend it as described at Acronis article concerning imaging with complex application running.

Thank you.
--
Ilya Toytman

 

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.

 

@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

 

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!

 

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)...

 

.....well, i'm going to test then. Thanks again

 

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