Note that this Wiki is a work in progress, items may not be updated or may disappear entirely as the pages are updated.

From SpacialAudio

QUESTION:

How do I restore my Database Manually?

ANSWER: A time may arise that you may have corrupt tables that cannot be restored;

Using your last backup.

You have some options, if you have an older known good backup you can just use the restore feature within SAM and restore it. In this case there was a corrupted queuelist table that didn't allow the restore feature to function correctly thus not restoring the entire database. To determine if the table was corrupted we had to go through each table and restore it, it will return OK if successful.

create database samtest;

use samtest;

restore table queuelist from 'c:/samback';

restore table historylist,eventtime from 'c:/samback';

restore table disk,event from 'c:/samback';

restore table song_lyrics,song_comments,policies from 'c:/samback';

restore table requestlist from 'c:/samback';

restore table songlist from 'c:/samback';

restore table songlistlist from 'c:/samback';

restore table categorylist from 'c:/samback';

restore table category from 'c:/samback';

Now that you have done this you should have a clean working database to import into your database. Using this method after all others fail may just be your only option, but it should get you up and running.