SQL Server Performance Forum – Threads Archive
2 user accounts and default db got swappedHey 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.
admin2->db2 then after movement:
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