Unanswered: Is it possible to dump database when logdevice is missing ?
I need to test (experiment) if I can recover from a situation where my logdevice is missing.
Is this possible ?
database was created with a seperate data and logdevice.
I have manually removed logdevice file from os (rm mylogdevicefile), entry still exists in sysdevices tables.
I would like to make a database dump of only the pages that are on the datadevice. I know that I would loose information from the logdevice, but that is not important.
In a previous test I had removed the datadevice and then I was still able to make a transaction log dump by using 'dump transaction dbname with no_truncate'. That test was succesfull
Did some of you do this experiment before ? I will now play around with updating system tables and hope to get it working from here.
Obviously this is not best dba practice, but sometimes dba's encounter strange problems.
None of my tests were succesfull.
I have tried to touch a logfile and afterwards dbcc rebuildlog, it failed.
I have tried to to delete entry for the log in sysusages + update segmap=7 of datadevice, but it failed as well.
That was just what we tried to do in this test. Suppose that you lost your logdevice and no valid backup.
What can you still do ? The only remaining valid data is on your datadevice.
I will try if I can still make a database dump and then afterwards recreate the db. I am looking for something like 'dump database mydb with no_truncate" I will post the results after the test
Remember, this is just a case-test, for our real enviromnents we have a strict backup schedule.