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 |
|
Jay1Jay
Yak Posting Veteran
50 Posts |
 Posted - 2003-07-31 : 09:42:13
|
| I have a SQL database called "Acts" on SQL2000 server that was created by installation of an application. On that SQL server we have created Logins for this particular "Acts" database so users can use the application. Management has now asked us to move this database to another server with a different server name. My question is can I just backup "Acts" database on the old server and restore it on the new server. Will that bring over the logins ID and their info or if it doesn't what would I have to do to get that info. Or would I have to backup the entire SQL2000 databases(master, acts, model,msdb,norhtwind,pubs,tempdb) from my old server and than restore all these databases on my new server.Any help is appreciated...thanks,Jay |
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2003-07-31 : 11:59:27
|
| No,You will have to migrate the logins seperartely. I believe Tara has a script in the scripts forum to do the migration. You will also need to fix orphaned users, I have a script in the scripts forum to do this.-Chadhttp://www.clrsoft.comSoftware built for the Common Language Runtime. |
 |
|
|
|
|
|
Database Migration