Accidentally dropped DBO from database

From: Linda (Linda_at_discussions.microsoft.com)
Date: 01/18/05

  • Next message: Jason Delaune: "Re: Error Granting DB / Role Access" 
    Date: Tue, 18 Jan 2005 06:25:03 -0800

    I altered a script that drops all users from a database and accidentally
    changes an AND to an OR so that the user DBO was dropped after a refresh from
    production to dev.

    Can I readd this user or is the only solution is to restore from backup?

    Thanks,
    Linda

  • Next message: Jason Delaune: "Re: Error Granting DB / Role Access"

    Relevant Pages

    • Re: Enterprise Manager Newbie Question
      ... a SQL backup is not a simple copy of the database files. ... Is it possible to write a script that one could run from a workstation and ...
      (microsoft.public.sqlserver.tools)
    • RMAN backup strategy on 10g r2 on linux
      ... "Oracle Database 10g Linux Administration" book in order to understand ... how to efficiently backup and restore our instance of the db. ... I wrote a shell script that is called by cron every night. ...
      (comp.databases.oracle.server)
    • Re: RMAN backup strategy on 10g r2 on linux
      ... running (e.g. if your database was created after Oracle installation ... database, which of course is the proverbial chocolate fireguard. ... how to efficiently backup and restore our instance of the db. ... I wrote a shell script that is called by cron every night. ...
      (comp.databases.oracle.server)
    • Re: Enterprise Manager Newbie Question
      ... and have a script run from the workstation so that we ... SSMS does work with SQL 2000 and SQL ... why don't you write a short backup script using the SQLCMD utility ... Senior Database Administrator ...
      (microsoft.public.sqlserver.tools)
    • Re: RMAN backup strategy on 10g r2 on linux
      ... "Oracle Database 10g Linux Administration" book in order to understand ... how to efficiently backup and restore our instance of the db. ... I wrote a shell script that is called by cron every night. ...
      (comp.databases.oracle.server)