Best practices recommend that you preserve a copy of each "finalized" or official database design. This should be performed as part of the deployment process and can be achieved through a variety of means. The motto "Its better to be safe than sorry" definitely applies here. So consider making multiple backup copies and storing them in separate locations.
Consider these options when looking to preserve a copy of a database design. This will enable quick access to the database design should you need to revert to a previous version, create an entirely new instance of the database, or copy it to use as the basis for a new release. Be sure to preserve a copy of each release deployed into the production environment.