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 |
|
WrecknRoll
Starting Member
9 Posts |
 Posted - 2011-10-07 : 13:39:19
|
| (I am running SQL Server 2005 SP2 Developer on Windows XP)One of the things I have to be able to do is programatically save (Backup) or restore (Refresh) some of my SQL Databases. The easiest/simplest way to do this is to stop my SQL Server then copy my .mdf and .ldf files either from the active folder to the backup or vice-versa.This has worked perfectly in the past, never had any problems. Now however a strange thing is happening. I stop SQL Server then copy my active files to a backup folder (so the active files remain completely unchanged, just copied only). Then I restart SQL Server.After doing this my User Mappings for the databases are gone. The users within each specific database have become orphaned.Why is it losing these mappings after simply stopping, copying then restarting? Any help y'all could offer would be much appreciated! Thanks... |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2011-10-08 : 05:48:32
|
| Google for 'orphaned users'. Tonnes of info on reasons and fix.--Gail ShawSQL Server MVP |
 |
|
|
paultech
Yak Posting Veteran
79 Posts |
|
|
|
|
|
User Mappings lost