I am using SQL 2008
I have two databases, one on my dev server and one on my production server. Both are the same databases but they have different .mdf and .ldf sizes.
I'm have backup (.bak) of the production database and I want to overwrite the one in dev but the production one has a huge transaction log and there isn't space on the dev server to store.
How can I overwrite the dev database with the production database backup file WITHOUT truncating the log in production.