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

  • Re: How do I re-establish my client security channel
    ... The Windows restore and service packs, ... First question might be how old was the backup you restored? ... How big is your C partition. ... when I disjoin and rejoin a client to the Domain ...
    (microsoft.public.windows.server.sbs)
  • 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)