Comments
Sort by recent activity
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 / comments
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
Hi, yes the DB already exists. If I remove the DISCONNECT_EXISTING option, I get the same error.
Thanks,
Dan / comments
Hi, yes the DB already exists. If I remove the DISCONNECT_EXISTING option, I get the same error.
Thanks,
Dan
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...........! / comments
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 trans...
Here you go:
syslive 14 15 MULTI_USER ONLINE
/ comments
Here you go:
syslive 14 15 MULTI_USER ONLINE
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.
/ comments
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...
Brilliant, thanks for that.
Dan / comments
Brilliant, thanks for that.
Dan