Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 Best way to upgrade Database?

Author  Topic 

denis_the_thief
Aged Yak Warrior

596 Posts

Posted - 2013-02-24 : 14:10:43
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.

jackv
Master Smack Fu Yak Hacker

2179 Posts

Posted - 2013-02-24 : 14:15:25
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

Jack Vamvas
--------------------
http://www.sqlserver-dba.com
Go to Top of Page

denis_the_thief
Aged Yak Warrior

596 Posts

Posted - 2013-02-24 : 14:24:23
Thanks, there may be a way to limit connections from the application but I am not sure.

Then maybe Restricted user would work? I would not have to worry about other connections and it would allow other DBAs to work on it.

Go to Top of Page

jackv
Master Smack Fu Yak Hacker

2179 Posts

Posted - 2013-02-25 : 01:35:54
Resetricted_user mode is a good idea, as long as the users through the apps are not set at db_owner, dbcreator or sysadmin.

Jack Vamvas
--------------------
http://www.sqlserver-dba.com
Go to Top of Page
   

- Advertisement -