How to restore a database with minimal log?
My production db has 20 GB log space which it needs. When I want to restore its copy on to Dev in different versions as required by the business needs each time I have trouble with log space on the disk. Is there a way to restore prod backup copy on the Dev with minimal log as Dev doesn't need so much log.
I know, we can shrink prod and take a backup after shrinking the log and then restore on the Dev. But this work-around is not always possible. Any ideas are greatly appreciated!
Thanks,