• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 282
  • Last Modified:

Skip users during sql backup

Is it possible to do a sql backup and skip the user accounts associated with the database?  we are moving databases to a new server and assigning new accounts and need to get rid of the old accounts prior to restore so we do not have to deal with managing orphaned accounts.  So can you tell SQL to skip the user accounts associated with a database when it does a backup?
0
ichbinp3t3
Asked:
ichbinp3t3
1 Solution
 
Aneesh RetnakaranDatabase AdministratorCommented:
No, unfortunately there is no such option.. You need to remove them after restoring the database
0
 
TempDBACommented:
There is no option as such. You can remove them after restoring.
Or else you can restore in an intermediate server, remove users and do final backup. But it is waste of resources and time. Rather you can restore the database with different name and remove the users, followed by renaming the db to its original name.
0

Featured Post

Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now