SQL Copy Database – Detach and Attach Drops Permissions - Blogs

SQL Copy Database – Detach and Attach Drops Permissions

Published by: jeremy_stoltzfus on 14th Dec 2011 | View all blogs by jeremy_stoltzfus

Apparently, in SQL Server Management Studio, copying a database via Tasks -> Copy Database and choosing the “Detach and Attach” method can drop all user permissions from the source database. Awesome.

I’ve yet to figure out whether this always happens or if it’s only in specific circumstances, but I can say that I’ve had it happen to me multiple times. My advice: use the tried-and-true method of backing up the source database and restoring it to the new destination instead.