SharePoint 2007 MOSS SP2.
SQL 2005 connected to Network storage.
Network storage crashed and we lost all our data.
Other problems on the SQL server forced us to create a new VM with a fresh SQL install and restored all databases from last night.. this is a plain Tivoli SQL backup - not a SharePoint application backup or point in time backup. This worked and our farm is back up.
However, We were told this restore type is not supported by Microsoft and might not work because you can't restore the SharePoint config database... but somehow we did and everything seems fine.
- Anything we should be checking?
- If we have not made MOSS config changes in the last year and have no plans to make config changes in the future are there user actions that somehow cause the config db to change and get out of sync with content dbs? If so what?
- If the answer to 2 is that nothing a user can do will change the config db, then can we assume that a restore of that specific config db in the future can be mixed and matched with newer content dbs? If no, why not?
Basically, if we are not making changes in central admin... why is a SQL restore of the config DB unsupported?