Re: ISV Using SQL Authentication - a login concern

From: Geoff N. Hiten (SRDBA_at_Careerbuilder.com)
Date: 05/26/04 

Date: Wed, 26 May 2004 16:19:52 -0400

How you login depends on the tool you are using.

If you are writing code using ADO you provide a different login and password
in the connection string.
If you are using SQL-DMO for the administrative tools, you change the server
connection credintials.
If you are using Enterprise Manager or Query Analyzer, you are violating the
license.

Again, you can backup a database with users in it. You myst have exclusive
access to restore a database. 

-- 
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"dev" <anonymous@discussions.microsoft.com> wrote in message
news:731A9102-7063-4ED3-966E-DC01267ED0AD@microsoft.com...
> 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: How do I restore from mdf and ldf files?
    ... Tasks -> Backup Database ... Tasks -> Restore Database ... Windows 2003 Server with Latest Service Pack ... Pre-requisites for Sharepoint Backup and Restore: ...
    (microsoft.public.sharepoint.portalserver)
  • Re: POINT IN TIME RESTORE
    ... This is what you should have done in order to do the restore as you wish: ... > 3- erase data ... > 5- restore database with norecovery ... The BACKUP DATABAE can of course be at an earlier point in time, ...
    (microsoft.public.sqlserver.server)
  • RE: How to restore edb & stm files from bkf backup file on another exc
    ... copied to a different storage group on the same server or to a different ... On production server successfully backup information ... Restore Status ... Failed to find a database to restore to from the Microsoft ...
    (microsoft.public.exchange.admin)
  • Re: Transaction Log ??
    ... we used to simplify our database restore process: ... every database got their respective backup folder. ... -- get logFileName, FirstLSN, LastLSN list ...
    (microsoft.public.sqlserver.security)