 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
SQL Server Forum / General / Security / July 2008move users
SQL 2005 sp2 We're replacing our old Prod server with a new box. What's the best way to setup my users on the new box so when I restore a backup from the old Prod server the users will be in place, and I don't have to go through the painful exercise of setting up permissions? If I use SSIS' Transfer Logins task prior to restoring the dbs will that work? Or is there a better way? Thanks, Andre Check out: http://support.microsoft.com/kb/918992/  SignatureTom ---------------------------------------------------- Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS SQL Server MVP Toronto, ON Canada https://mvp.support.microsoft.com/profile/Tom.Moreau SQL 2005 sp2 We're replacing our old Prod server with a new box. What's the best way to setup my users on the new box so when I restore a backup from the old Prod server the users will be in place, and I don't have to go through the painful exercise of setting up permissions? If I use SSIS' Transfer Logins task prior to restoring the dbs will that work? Or is there a better way? Thanks, Andre If you're just replacing servers, your master database backup should be enough. What I do is simply copy the entire SQL Server folder with all the MDF/LDF files from the old box and copy it back to the new box as long as the configurations are exactly the same. Of course, the assumption here is you've got large storage > Check out: > [quoted text clipped - 11 lines] > > Thanks, Andre Exactly what I needed. Thanks much Tom. Andre |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.