Is it possible to keep SQL Logins after detaching/attaching databases?
Posted on 2009-07-14
I am in the process of moving some databases from one storage drive to another. So it will be still on the same server, but a different drive letter.
At first I was detaching the database, robocopy the data/log files to the new drive, then reattaching the database.
The problem I noticed is when I reattached the db, it did not have all the SQL login accounts associated with the database anymore. Just some default ones, dbo, etc.
Does anyone know how I can move a database to another drive but keep the sql logins intact?