Re: restore permissions (Access .adp project using MSDE)

From: Mary Chipman (mchip_at_nomail.please)
Date: 05/24/03


Date: Sat, 24 May 2003 17:04:25 -0400


Yes -- see the Permissions subhead in the RESTORE topic in Books
Online.

-- Mary
Microsoft Access Developer's Guide to SQL Server
http://www.amazon.com/exec/obidos/ASIN/0672319446

On Sat, 24 May 2003 06:29:36 -0700, "Steve" <tsa_projects@yahoo.com>
wrote:

>hi ...
>
>I have a backup function working in my Access/MSDE .adp
>project but cannot get it to do a restore unless I give
>high level ( dbcreator ) permissions to the login account.
>
>There seems to be no way to grant restore priviliges to a
>login account ... is this really so ?
>
>Thanks,
>
>Steve



Relevant Pages

  • Restoring Backup with XP when performed on 98
    ... I backed up my system using the backup function in Windows 98 2nd edition. ... I am now running XP Home Edition. ... How can I restore some of these files that I have backed up with 98. ...
    (microsoft.public.windowsxp.general)
  • recover exchange folder for user
    ... if i have a backup (using the backup function in SBS2003) ... what is the easist way to restore a users exchange folder. ... need calender and tasks) ...
    (microsoft.public.windows.server.sbs)
  • Re: Backing Up WSS
    ... Backup and Restore Options for Windows SharePoint Services ... ·Use the Microsoft SQL Server 2000 tools to back up the databases. ...
    (microsoft.public.sharepoint.portalserver)
  • Re: Disaster Recovery question
    ... Can you post the SQL Server error log of the dysfunctional server? ... > You can restore master to another box. ... > 1) Drop the suspect DB's and simply restore from backup. ...
    (microsoft.public.sqlserver.server)
  • Re: Is it necessary to exclude the data folder when using NetBackup?
    ... When you do a RESTORE in SQL Server, the database is created, if it doesn't ... >>just back up the native SQL backup files to ...
    (microsoft.public.sqlserver.server)