Has the Landshark Engine DB Size Limits?

  • 0
  • 1
  • Question
  • Updated 4 years ago
  • Answered
I have managed to create dSource databases from existing SQL backup files. Seven in total, second largest one of 3GB original size and the largest one of 8GB original size.

The problem comes where i am not able to Provision the 8GB database from the dSource. I have tried to deploy to a remote SQL server and to a local SQL server where i am "sysadmin". I get the following message which is not entirely true as i am able to deploy 6 other dSources including the second largest one (3GB in original size).

Here is the message received:

Suggested Action:Make sure that the SQL Server instance "XXXXX" on 
the target host "YYYYY" is up and that the user 
"ZZZZZZ" has privileges to restore a database on the host.

Any suggestions to get the largest dSource database deployed would be appreciated.

My LandsharkEngine runs off 8GB RAM and 4 CPU. HDD is 38GB free.

Thanks
Sean
Photo of Sean

Sean

  • 130 Points 100 badge 2x thumb

Posted 4 years ago

  • 0
  • 1
Photo of Adam Bowen

Adam Bowen, Official Rep

  • 17,884 Points 10k badge 2x thumb
Official Response
There are no size limits, but you have to ensure that the os user is a domain user and has privileges on the source and the target, in order for this to work.
Photo of Adam Bowen

Adam Bowen, Official Rep

  • 17,884 Points 10k badge 2x thumb
Official Response
Photo of Sean

Sean

  • 130 Points 100 badge 2x thumb
Thanks Adam. Would the evidence that i have successfully Provisioned 6 other dSources void those requirements?
Photo of Adam Bowen

Adam Bowen, Official Rep

  • 17,884 Points 10k badge 2x thumb
Official Response
Well, it wouldn't "void" the requirements, per se. But, there is definitely something different in regards to permissions on the 8GB database. You could do a 800GB DB with Landshark if you wanted. Is this database from the same MSSQL instance as one of your other 6?
Photo of Sean

Sean

  • 130 Points 100 badge 2x thumb
Well this database is from the same SQL version as the others. They each come from a different instance from the same server. So they are identical in config, just the instance is different. Although I have one of the other databases from the same instance and it has been one of the successful ones.

I have set the SQL Server account to use a domain account to see if this improves things, but dont see why it should base on the other 6 successful DB's.
Photo of Sean

Sean

  • 130 Points 100 badge 2x thumb
I have managed to source another backup of the same database and that appears to have solved my problem. This appears to be a bit of a Red Herring.
Photo of Adam Bowen

Adam Bowen, Official Rep

  • 17,884 Points 10k badge 2x thumb
Glad to hear you got it sorted.