Restore issues with Eval version 4
Hereâ€™s what I did to test.
I did a full backup on our test SharePoint DB
I when into SharePoint and made a change
I tried to a restore but received an error that the DB was in use
I went into SQL 2005 admin and put the DB offline after shutting down SharePoint services
I tried the restore again but am receiving a SQL error 3159 saying the tail of the log for the database has not been backed up.
Itâ€™s telling me to use BACKUP LOG WITH NORECOVERY to backup the log but I donâ€™t know how to get this done. Also I canâ€™t get any further then this and it will not let me backup the DB again because it does not show up in the list.
For the test I only wanted to restore what I backed up to see if the DB with the change I made was back to itâ€™s original state.