cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Snoopstah
Pilgrim

SQL Database Best Practices

Can someone please tell me what the best practice is for SQL database distribution and uninstallation?

Currently our installer deploys a database, runs some sql scripts and the application deployed uses this database. Common scenario I'm sure.

When the user chooses to uninstall our product, I backup and then drop the database. There is still a copy of the database (via backup file) should the user decide they need to see the data again. Is this correct procedure, or should the uninstall leave the database on their system?

Can someone tell me if I am following best practice, or where I can read best practice for this scenario?
Labels (1)
0 Kudos
2 Replies
Snoopstah
Pilgrim

Re: SQL Database Best Practices

Surely someone knows the MSI standards ?
0 Kudos

Practice Assistant Task Manager

Am having this error on my server

Practice Assistant Task Manager
Unknown database
Alias:dbPAMgr.
0 Kudos