SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 Best way to upgrade Database?
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

denis_the_thief
Aged Yak Warrior

Canada
594 Posts

Posted - 02/24/2013 :  14:10:43  Show Profile  Reply with Quote
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
Flowing Fount of Yak Knowledge

United Kingdom
2075 Posts

Posted - 02/24/2013 :  14:15:25  Show Profile  Visit jackv's Homepage  Reply with Quote
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

Canada
594 Posts

Posted - 02/24/2013 :  14:24:23  Show Profile  Reply with Quote
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
Flowing Fount of Yak Knowledge

United Kingdom
2075 Posts

Posted - 02/25/2013 :  01:35:54  Show Profile  Visit jackv's Homepage  Reply with Quote
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
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.08 seconds. Powered By: Snitz Forums 2000