Error in Restoring SQL 2000 Backup
Posted on 2006-11-27
SQL 2000 database reporting "(Suspect)" and not available.
Attemtped to restore from backup
Selected database_name and attempted 'Restore Database...'
Defaults directly to the location and most recent backup copy of the database.
Select 'OK' on the Restore Database option
"Microsoft SQL-DMO (ODBC SQLState: 42000)
Cannot overwrite file 'database_name_1_Log' because it is marked as read-only.
RESTORE DATABASE is terminating abnormally."
I am an inexperienced "dba", any ideas?