how to save space copying data to read-only database RRS feed

  • Question

  • Dear all, we need to create a readonly copy of database from an actively used database with a lot of free space in its files.

    We wanted to use backup/restore, but are open to other solutions.

    Obviously, we want the backup to be as compact as possible and we do not want any of the free space in the read-only database files. What is our best option? We are on SQL Server 12 and14

    Wednesday, July 10, 2019 7:39 PM