I seem to have a problem to restore my data base I have no problem to back it up. When I try and restore it seems to bog on transaction control and display 0 of 169126 and go no where else. Is there a specfic time I should wait to let it try this or any other ways to restore. I tried to create a new data base that is blank and restore to it. I did that then I wanted to restore to the same data base using optimize and it would not do that. Any solutions as to why I can not restore. Nothing is wrong with my data base that I know of it works fine. I just thought it would be a good idea to be able to perform the function.
Original Post