How to rebuild the SQL database schema while perserving existing data. This can sometimes be necessary when corruption has been noticed or Windows event logs indicate that tables or stored proceedures cannot be found. The goal is to rebuild the underlying database schema and data format without altering existing data.
NOTE: If corruption of any kind has been take place to the database schema, data may also have been corrupted or lost. Always rely on regular backups of SQL databases to keep from loosing data for any reason.
To manually update the Deployment Server database schema, perform the following steps while on the Deployment Server: