Re: ISV Using SQL Authentication - a login concern

From: dev (anonymous_at_discussions.microsoft.com)
Date: 05/26/04 

Date: Wed, 26 May 2004 13:06:08 -0700

Thanks Geoff,

I will need backup, restore, attach and detach (occasionally) and will have only 1 login & user (as I mentioned). So:
- how can I login as sa (who is part of sysadmin role) and backup or restore the database while the client is interacting with the database logged in as myAppUser. I mean how do I specify to use sa just for the action of backup and restore.

Thanks

Relevant Pages

  • Backup and Restore Files
    ... What is the best way to backup and restore a runtime database file? ... pszDisplayName As String ...
    (microsoft.public.access.gettingstarted)
  • Re: AD Disaster Recovery
    ... another client. ... I ran the NT Backup restore and boot into DS Restore mode. ... > scripts to recovery our AD Domain controllers. ...
    (microsoft.public.windows.server.active_directory)
  • Re: [opensuse] About Backing Up
    ... there is a data failure we can restore. ... the restoration is to get the backup file that we first complete as it ... failure, physical destruction, or it has been half inched. ... Other data should be archived to media. ...
    (SuSE)
  • Re: Exchange in Recovery Mode
    ... On the backup SBS server, did you restore Mailbox Store from backup ... After Mailbox Store was restored, ... Create a Recovery Storage Group. ... Restore the backup to Recovery Storage Group with NTbackup. ...
    (microsoft.public.windows.server.sbs)
  • Re: RAID, SCHMAID.......
    ... And risky to change it later without a full image backup. ... partition, & then restore only the OS, but still verydoable. ... partition before an install of something you havent installed before, ... but so many ppl make a mess of things esp with today's big drives. ...
    (comp.sys.ibm.pc.hardware.storage)