Move SQL Clone data and log files

jakobehnjakobehn Posts: 11 New member
We have a several testing environment where the data and log files of the SQL Clone databases were created on the wrong disk (due to the default location of the SQL Server instance was not set properly).

Is there any supported way of moving the files of these clones without having to re-clone every database? I tried running an ALTER DATABASE statement to move the files, but that left the database in a "pending recovery" state

Thanks
Tagged:

Answers

  • SQL Clone doesn't have a supported way of moving clones to a different location. The recomended way is to delete the clones and then create them in the new location. If this solution doesn't fit you, it's possible to do it by changing SQL Clone configuration, but you should contact the support for that, since manually editing the configuration database may leave it in an incosistent state.
  • jakobehnjakobehn Posts: 11 New member
    OK, thanks Alex

    /Jakob
  • WOndiWOndi Posts: 1 New member
    Is this means we cannot move a sql clone to a new server but recreate the clones on the new environment?
Sign In or Register to comment.