Skip users during sql backup

Posted on 2011-10-17
Last Modified: 2012-05-12
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?
Question by:ichbinp3t3
    LVL 75

    Accepted Solution

    No, unfortunately there is no such option.. You need to remove them after restoring the database
    LVL 25

    Expert Comment

    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.

    Featured Post

    IT, Stop Being Called Into Every Meeting

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Join & Write a Comment

    When writing XML code a very difficult part is when we like to remove all the elements or attributes from the XML that have no data. I would like to share a set of recursive MSSQL stored procedures that I have made to remove those elements from …
    Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
    This video is in connection to the article "The case of a missing mobile phone (". It will help one to understand clearly the steps to track a lost android phone.
    This video discusses moving either the default database or any database to a new volume.

    745 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    16 Experts available now in Live!

    Get 1:1 Help Now