Comments
Sort by recent activity
That resolved it.....Thank you / comments
That resolved it.....Thank you
Same error as before. Exclusive access could not be obtained. There are no locks on this database. there are no processes using this database. There are no tables in this database. I cannot understand what the error message is refering to. What do the Msg numbers signify? Any suggestions? / comments
Same error as before. Exclusive access could not be obtained. There are no locks on this database. there are no processes using this database. There are no tables in this database. I cannot underst...
I ran the script
EXECUTE master..sqlbackup N'-SQL "RESTORE DATABASE [Northwind] FROM DISK =
''\\store\Backup\FULL_SQL2005_Northwind_*.sqb'' WITH RECOVERY, REPLACE"'
on the backup server. It runs fine and return a 0 return code. Unfortunately there are no tables in the database and it seems to run too quickly. There is only ever one backup on the SAN drive but it is almost like SQL Backup can't see the drive. I cannot restore the file graphically using RedGate because it cannot see the drive so that is my assumption for the job. I don't understand the 0 return codes. I just want it to restore whatever file is there. / comments
I ran the script
EXECUTE master..sqlbackup N'-SQL "RESTORE DATABASE [Northwind] FROM DISK =
''\\store\Backup\FULL_SQL2005_Northwind_*.sqb'' WITH RECOVERY, REPLACE"'
on the backup server. It runs f...
2/7/2009 6:00:21 PM: Server: Msg 3013
RESTORE DATABASE is terminating abnormally.
2/7/2009 6:00:21 PM: Server: Msg 3101
Exclusive access could not be obtained because the database is in use.
Nothing runs on this box (supposedly). Gives me another avenue to research though. Thanks for yoiur help I will post my findings. / comments
2/7/2009 6:00:21 PM: Server: Msg 3013
RESTORE DATABASE is terminating abnormally.
2/7/2009 6:00:21 PM: Server: Msg 3101
Exclusive access could not be obtained because the database is in use.
Nothin...
Tried to apply the code and kept getting syntax error. Couldn't figure it out for the longest time. Then I hit the answer. We are running SQL Backup 4.6...ERASEFILES_REMOTE isn't valid yet. Is there a workaround? / comments
Tried to apply the code and kept getting syntax error. Couldn't figure it out for the longest time. Then I hit the answer. We are running SQL Backup 4.6...ERASEFILES_REMOTE isn't valid yet. Is ther...
The backups are once a day. I need to restore once a day. Customer only needs to be able to restore to last nights backup. if I set the backup job to delete any file on the NAS drive older than say 12 hours than there should only ever be one file for the backup server to see on the san. That should make it easier. Maybe some kind of script to read in the .sqb filename from the drive and place it a s a variable in the restore script? / comments
The backups are once a day. I need to restore once a day. Customer only needs to be able to restore to last nights backup. if I set the backup job to delete any file on the NAS drive older than say...