I need to upgrade a Database to a new version of the vendor's software (i.e. a whole bunch of update scripts containing table changes, Stored Procs etc...).
I obviously don't want anyone using it during the upgrade.
What is the recommended practice here? Single User mode - Restricted User mode? Detach it from the Server and perform the upgrade on my personal computer and then put it back? Or any other idea would be appreciated.
A few ideas: 1) Take a full backup before you start anything for a rollback point 2)Is there some way you can limit how the applications connect? Single user mode may be restrictive during an upgrade as multiple DBAs may need to work on the db 3)Detaching it and working from another server is ok , will depend on point 2