In my previous post after succesfully finshed installing the WSS v3 SP2 and now tried to restore my site to my surprise i came across another error :)
Another site already exists at http://mysite. Delete this site before attempting to create a new site with the same URL, l
choose a new URL, or create a new inclusion at the path you originally specified
I had a look at the Sharepoint Central Admin and i could see the site but the delete button was greyed out
So i taught it must be an orphan site so i tried using the
staadm - o databaserepair "YOURSITE" - databasename "YouDB"
also used the -deletecorruption option but still returned 0
But it returned 0 which meand there are no orphaned sites arg.!!!!!!!
So my last taught was the database isn't refreshing so i simple detached and re-attach the WSS_Content DB
and BINGO tried to restore and it worked.
Hope that helps