What are the challenges you face when working across database platforms? Take the survey
Options

Request INIT option in CONVERT command

Randy DoubRandy Doub Posts: 26
edited November 13, 2008 5:21AM in SQL Backup Previous Versions
A db is backed up nightly and restored to a "Reporting" server. To make my code simplier when the originating server started using SQL Backup I used the Convert command to convert to the same file name every night (rather than figure out dates and quote more quotes). I got the message that the filename already exists and won't be overwritten. I handled by deleting the destination MTF file prior to converting, but an INIT option would be handy.

Comments

Sign In or Register to comment.