You are viewing limited content. For full access, please sign in.

Question

Question

Can Avante with SQL Express use SQL Standard

Laserfiche Licensing
Updated July 14, 2014
asked on July 8, 2014

 So I have a customer that has Avante with SQL Express because they're only 2 employees, however, they do own SQL Standard for another program they use.  They would like to be able to use SQL  management studio to create a maintenance plan to do a backup. However, this option isn't available with SQL Express...would he be able to use his Standard SQL to run with the Avante in order to accompish this?  What are others doing to accomplish this if you're using SQL Express?

0 0

Answer

SELECTED ANSWER
replied on July 8, 2014

If the Laserfiche server license they purchased is for SQL Express, they can not use it with SQL standard. They would have to purchase the "Laserfiche Avante for MS SQL with Workflow" license. You may not be able to use the automated backup using Management Studio to do the backup, but you should be able to write a script.

0 0

Replies

replied on July 14, 2014

Hi Daryl,

 

Another consideration, some backup software is capable of backing up SQL databases directly through the backup software. This isn't dependent on SQL version. Might be worth investigating this as I know the cost between Avante for SQL Express and full SQL is a considerable amount from memory. I know that Symantec Veritas software is capable of doing this off the top of my head.

 

Just a thought.

 

Hope this helps!

1 0
replied on July 14, 2014

If you look at Implementing a Simple SQL Server Backup Script, you can see how to automate backing up SQL DBs without needing the scheduling tools in the full version of the SQL management studio.

0 0
You are not allowed to follow up in this post.

Sign in to reply to this post.

Details
Related Posts
Loading ...