Home Forums SQL Server 2008 SQL Server 2008 - General restore database without overwriting users RE: restore database without overwriting users
Ant-Green
SSC Guru
Points: 113445
More actions
March 26, 2013 at 8:21 am
#1600828
You can't
SQL needs to restore the database as it was at the time of backing it up.
To do what you need to do add another script to your batch which creates the login and user and assigned the necessary permissions.