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.
| Author |
Topic |
|
sunsanvin
Master Smack Fu Yak Hacker
1274 Posts |
 Posted - 2008-08-04 : 02:05:01
|
| Dear All,i'm going with side by side upgradation on my production server.i've decided to go for backup and restore. now my doubt is1) how to get the users and jobs (ith schedule) to the new server? can i generate script them and run in the new server?2) same way if i script the users and run in the new servers, will the users have the same permissions and on same databases with same passwords? or i need to modify any thing?3)msdb databse backup and restore will create all the jobs and schedues automatically?oris there any better way to do all these?ArnavEven you learn 1%, Learn it with 100% confidence. |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-08-04 : 09:39:05
|
| 1) For Logins: use this:http://support.microsoft.com/kb/246133Make sure you execute sp_help_revolvelogin 2000 to 2005 .2)For jobs,Use Transfer job task in SSIS. |
 |
|
|
|
|
|
users and jobs