The scenario is we have dev SQL servers that we need to restore a copy of the database to. However, we don't need to restore all the t-logs to the dev server, the size of some of these tlogs can be sizable. I'm assuming we could do this with a copy-only job. The catch is I would need a way to restore that specific job rather than another one of the fulls on a nightly schedule, and I don't think that's really any more storage efficient than just adding the necessary storage to restore the tlog files as well.
If we use the most recent point in time restore option, we still get the complete set of tlogs.
-
jmbi
- Influencer
- Posts: 14
- Liked: 3 times
- Joined: Mar 26, 2020 1:52 pm
- Contact:
Who is online
Users browsing this forum: No registered users and 2 guests