SQL Server Performance Forum – Threads Archive

2 user accounts and default db got swapped

Hey guys, We placed a db in offline mode and moved it to a different drive. When we brought it back online, the default db for admin1 pointed to the default db of admin2, then vice versa.
orginally:
admin1->db1
admin2->db2 then after movement:
admin1->db2
admin2->db1 I found out via EM, Security and right-clicking on those 2 user. Any ideas? Took us a while to troubleshoot. Thanks, V1rt

---

Seehttp://www.sql-server-performance.com/q&a27.asp Run the resync script on each database after restoring it from backup. Good idea to do this as a matter of routine

---

]]>