September 25, 2008 at 1:36 am
Ok i have tried every way i can think of to run a data restore on my data bases with the mdf and ldf.
I have tried the attach multi times and failed. I have tried the make detach and re-attach.
I have also tried to use the tool Apex sql log But it does only a few rows in demo. And don't know about everyone else i can not afford 1500 bucks to buy it.
Microsoft SQL-DMO (ODBC SQLState: HY000)
---------------------------
Error 602: Could not find row in sysindexes for database ID 7, object ID 1, index ID 1. Run DBCC CHECKTABLE on sysindexes.
---------------------------
OK
---------------------------
That's the error i get when i try to reattach it the dbs.
I have tried with the qureey and with the built in one. I need this or i suffer a 28 day loss of very important data.
Also ask why did i not have a back up plan? I did it said it was running fine but seem to stop working 28 days ago like the plan was deleted with out warning. I see the manager was connected and green so i believed it was working. I tried to do the DBCC Checktable but was confused on this if i can not get the db loaded in the first place.
Forgot to mention This MSSQl 2000 for new and old we did a os Upgrade on our dedi host and costed a reformat.
Any help would be greatly appreciated.
ICON
September 25, 2008 at 6:41 am
You are in a pickle, aren't you. No lecture on backups at this point as it is not helpful.
First, might I suggest that you open an incident with Microsoft. Chances are good that it will cost less than $1500, but since we have an Enterprise agreement, I don't know how much those cost these days.
Second, have you discussed with management what is going on with the failed backups and such to see whether or not they are willing to spend $1500 on this apex product? A 28 day loss of data is going to be very costly, tens of thousands at the least. Compare that to 1500, it seems rather minor in the grand scheme of things. I have no doubt that you will be squarely blamed for what has transpired. Take it, but let management know that you are committed to resolving this issue as quickly as possible with minimal data loss.
I know that this is a un-fun place to be. However, you need to communicate the urgency of this to management so that they can authorize the help you need to resolve this issue or suffer the data loss.
Regards, Irish
September 25, 2008 at 10:21 am
There's a post on Paul Randal's blog on how to 'hack' a corrupt DB back into a server after it was detached. It's one of the more recent entries.
http://www.sqlskills.com/blogs/paul
Also note that if your DB is corrupt, you're probably going to lose some data to geet it back working.
I just want to clarify something - this is a SQL 2000 database that you're attaching to a SQL 2000 instance?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 25, 2008 at 12:51 pm
Yes
September 26, 2008 at 12:44 am
Check out Paul's blog post on attaching corrupt databases. It may help you. If you get problem, post in the corruption forumn here (the SQL 2000 one) as Paul sometimes reads that and may be able to help you more.
I don't thing Apex's tool will help much here. That's good for reading the tran log to get the commands recently executed against the database. It's not going to do much if you've lost the entire database.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy