Reconfigure SQL Server Components

• 
  SQL Backup runs as a Windows service, so you'll need to look for a 'SQL Backup Agent - (instance name)' entry in the list of Windows Component Services, and change the service logon account. Stop the service first before making the change, and start the service after that.

  petey February 24, 2015 20:39

  - 0 +
• 
  Hi, I've done that but it still runs under the wrong user name. In the 'Activity History' log it shows as [someuser], when I've set the back service to run under my account [itsdanny] and [itsdanny] is the user i'm logged on as on my PC. I can guarantee the file is there etc. I did have a restore working under version 6 components.
  
  

  SQL Backup log file 7.7.0.7
   
  -SQL "RESTORE DATABASE [syslive] FROM DISK = 'M:sysliveperiodend_syslive.sqb' WITH RECOVERY, DISCONNECT_EXISTING, MOVE 'syslivelog' TO 'F:MSSQLLOGSsyslive.ldf', REPLACE, CHECKDB = 'NO_INFOMSGS, ALL_ERRORMSGS' "
   
  -----------------------------  ERRORS AND WARNINGS -----------------------------
    
  2/25/2015 9:01:34 AM: Restoring syslive (database) from: 
  2/25/2015 9:01:34 AM:   M:sysliveperiodend_syslive.sqb
   
  2/25/2015 9:01:34 AM: Error 890: RESTORE DATABASE permission denied for database:  (syslive)
  2/25/2015 9:01:34 AM: SQL error 913: Could not find database ID 15. Database may not be activated yet or may be in transition. Reissue the query once the database is available. If you do not think this error is due to a database that is transitioning its 
   state and this error continues to occur, contact your primary support provider. Please have available for review the Microsoft SQL Server error log and any additional information relevant to the circumstances when the error occurred.
  

  itsdanny February 25, 2015 04:08

  - 0 +
• 
  Does the [syslive] database already exist? What happens if you try restoring the database without using the DISCONNECT_EXISTING option?

  petey February 25, 2015 04:21

  - 0 +
• 
  Hi, yes the DB already exists. If I remove the DISCONNECT_EXISTING option, I get the same error.
  Thanks,
  Dan

  itsdanny February 25, 2015 04:24

  - 0 +
• 
  Could you please post the result of running this query on the instance where you are trying to restore the syslive database on?
  

  SELECT name, DATALENGTH(name), database_id, user_access_desc, state_desc FROM sys.databases WHERE name = 'syslive'
  

  petey February 25, 2015 04:47

  - 0 +
• 
  Here you go:

  syslive	14	15	MULTI_USER	ONLINE
  

  itsdanny February 25, 2015 05:10

  - 0 +
• 
  Could you please start SQL Profiler, and trace the SQL Backup activity when you run the restore? What user account is it using to run the queries, and what is the last query that's ran?

  petey February 25, 2015 05:28

  - 0 +
• 
  HI Peter, it runs under my account, so the 'itsdanny' one (i'm an admin)
  The last query is

  exec master..sqbdir
  

  .
  
  
  ... it seems the DB is brocken in some way, if I do a use syslive, it get the transition error in ssms...will fix that first...........!

  itsdanny February 25, 2015 05:46

  - 0 +
• 
  Would it be possible to drop the database, and then run the restore? If the database is restored successfully, then run the restore again and see if the same error occurs?

  petey February 25, 2015 05:58

  - 0 +
• 
  Hi, just to update this, the DB was in a bad way(it was visible in the objects but i couldn't expand e.g. the tables!) so droppping it sorted it out. Restore now works. Thanks for your help.
  Dan

  itsdanny February 25, 2015 11:12

  - 0 +

Add comment

Please sign in to leave a comment.