All is resolved at the moment, I will post back later with a solution we found at a website that basically describes a routine one can follow when you only have a primary and no log. Had we found this doc in an earlier state we would have saved 4 days of working day and night.
Thanks for...
Perhaps someone can enlight us on the following:
Our database was lost due to a defective hd. We created a new database, which is empty and imported the data from a Backup Exec backup we made. This works, but we did not get ALL permissions! We used DTS import-export wizard. When we choose to...
Thanks SQLBill,
Perhaps you can enlight us on the following:
We created a new database, which is empty and import the data. This works, but we did not get ALL permissions! We used DTS import-expor twizard. When we choose to copy all objects we get error: "failed to copy objects". What...
Hi SQLBill,
Thanks for replying! I'm in the Netherlands and we were working on this late last night. I read the other tread but in it you clearly asked for people NOT to reply so I figured I'd create a new case.
We will take your tip of backing up to heart and do it that way from now on...
The master was build by the reinstall, we did nothing with it, perhaps restore from tapen with BE did? We are not sure right now. What we do know: No more BE. Why? It should be able to do the trick on its own. This silly thing has cost us 4 days, we are setback 2 full working days in data when...
Hi jjeffm,
Thanks for posting back. We solved the problem!
We had a hd crash (completely scraped off) and we had to install SQL again and tried to restore. It is a know issue, has nothing to do with BE (except for that it can not restore completely in itself).
The workaround is to restore the...
Hi,
We have an MSSQL 2000 database (60MB) backup that will not restore with recovery. (as seen everywhere on the net)
Without recover is keeps loading. When we command it to load database ourdatabase with recovery, it will not work.
We are looking everywhere but unable to find a working...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.