必要な環境

SQL Clone Server requirements

A single central server is required to use SQL Clone within an organization, it co-ordinates agents, and serves the SQL Clone web app.

• Operating System 64bit (one of):
  • Windows Server: Windows Server 2012 R2 or later
  • Windows Desktop: Windows 8.1 or later
• Recommended CPU: 4 core 2.0GHz or higher
• Recommended RAM: 4GB or higher
• Access to a SQL Server instance for storing configuration data
  • SQL Clone's configuration database can be installed on SQL Server 2012 or later (including cloud-hosted SQL Server databases such as Azure SQL Database)
  • An empty database, or CREATE ANY DATABASE permission on the server so that SQL Clone can create its configuration database
  • At least SELECT/UPDATE/INSERT/DELETE/ALTER permissions on the configuration database
  • This database will be used only for metadata, and generally is expected to be 1GB or less in size
• By default the SQL Clone server web UI is served over HTTP and uses port 14145. To use HTTPS or a different port number follow the instructions on Configuring HTTPS and custom ports
• Firewall must permit incoming connection to Port 14145 (or the custom configured port - see above) and port 14146

SQL Clone Agent requirements
An agent should be installed on the same machine as any SQL Server you wish SQL Clone to use as a source of images, destination for clones, or temporary scratch space for restoring backups.

• Operating System 64bit (one of):
  • Windows Server: Windows Server 2016 or later
  • Windows Desktop: Windows 8.1 or later
• Recommended CPU: 4 core 2.0GHz or higher
• Recommended RAM: 4GB or higher
• SQL Server 2012 or later (Express edition is sufficient - though Clones will not circumvent SQL Server Express' 10GB database size limit)
• .NET Framework 7 or later (part of installation)
• Outbound connection to remote (SQL Clone Server) port 14146 must be allowed
• The Volume Shadow Copy Service must be available in order to make images from SQL Server instances:
  • The 'Volume Shadow Copy' service must be enabled
  • A shadow copy provider must also be enabled. The default software provider service is called ' Microsoft Software Shadow Copy Provider', but you may have a different provider (for example, if you're using a storage device that provides hardware support for shadow copying)
• This requires a Windows user account which has:
  • Local admin privileges in order to use the Virtual Disk Service
  • Read/write and change permissions access to network locations where images will be stored
• On local SQL Server instances where clones will be created or dropped, or images created from, the agent will also need a login with:
  • Membership in the sysadmin fixed server role
• This can be either a Windows login tied to the agent's Windows account, or a SQL Server login.
• If you want to use a SQL Server login, you will need to provide the username and password (once) when creating an image or clone with the instance.
• The agent must have enough disk space to store the clones, bearing in mind that they may grow over time.