new problem - RESTORE

From: AllcompPC (allcomppc_at_sbcglobal.net)
Date: 02/11/05

  • Next message: Henry: "Re: SQL query" 
    Date: Fri, 11 Feb 2005 16:01:56 -0500

    I thought I have successfully restored a backup from another instance of
    MSDE, however in my .NET program I am getting an error message about the
    login failed. So what I did is create a login id using sp_grantlogin. I
    assume that this allows my Windows login to be authenticated. Just in case,
    I also added a new login account using sp_addlogin. Those both worked.

    Now when I do...EXEC sp_grantaccess to the database, I get an error:
    Database cannot be opened. It is in the middle of a restore.

    When I was restoring, I did the RESTORE FILELISTONLY to get the names of the
    files in the backup. I then did RESTORE DATABASE using WITH and MOVE which
    announced it was successful, and the two files were placed into the
    directory. I thought this was it, what did I miss?

    Thanks,

    Brad

  • Next message: Henry: "Re: SQL query"

    Relevant Pages

    • Re: Error during restore
      ... >of different versions of the backup is not possible. ... >Error message: "Could not copy the following files to the device. ... >Establishing a new partnership doesn't change anything either. ... I'm assuming you are doing a restore from ActiveSync, ...
      (microsoft.public.pocketpc.activesync)
    • Re: ActiveSync Restore Error
      ... had tried that already and I get the same error message. ... > An Activesync backup can be restored only under guest mode. ... Did you restore ... > The selected backup file was created by an incompatible version of backup. ...
      (microsoft.public.pocketpc.activesync)
    • Re: Too many backup devices
      ... from a backup which is striped over more than 64 backup devices. ... are doing a series of restore operations where each restore only work against *one* backup device. ... At least this is my understanding of the error message. ...
      (microsoft.public.sqlserver.server)
    • Re: NTBACKUP on XP Fails to Restore .BKF File from CD
      ... I tried to restore from Backup MyPC, ... >> I'm getting the following error message when I try to restore a .BKF file ...
      (microsoft.public.windowsxp.basics)
    • Re: Script A Login
      ... When you create a Windows Login it identifies that Login by using the windows account SID which is unique. ... So you can take a DB from any server and plop it down (restore it) on any other server and the two will always match up. ... When I restore a database, all of the database User Accounts and Database Roles are restored. ... When I restore a backup, are you saying the connection between the SQL Login in the server and the User Account in the database is broken? ...
      (microsoft.public.sqlserver.security)