July 13, 2010 at 4:04 am
Hi,
I have a big problem...
My client, after the server went down got the status of one database as Suspect, then he copied the .mdf datafile to other location and deleted the database from SQL Server 2000...
BIG MISTAKE
Now, he sent to me the DMF file, so i can see if i can recover it.
I have create a new database with the exact same size as the one that was on the Client's server. Then i stoped SQL Server 2000 service and swap the datafile for this datafile that the client gave me.
Then, i have made the following procedures on SQL query analiser:
exec sp_configure 'allow updates',1
reconfigure with override
go
update master..sysdatabases
set status ='32768'
where name ='My_database'
go
exec sp_configure 'allow updates',0
reconfigure with override
go
Then i restarted the SQL Server service and then made the following command:
dbcc rebuild_log ('My_database','c:\My_database_log.ldf')
then , when i try to acccess the database i keep receive the following error:
Cannot open database 'SGT' version 0. Upgrade the database to the latest version.
What can i do to recover this database?
Thank you,
Pedro
July 13, 2010 at 6:50 am
Well, you could follow the advice I gave you in email a couple of hours ago... there's basically nothing to be done except to take the database back to a clean state and upgrade it (or it could be that the database is corrupt so the boot page has the wrong physical version number). Without looking at the database, as I said, it's impossible to tell from what you've said.
Basically, I think you're looking at total data loss.
Paul Randal
CEO, SQLskills.com: Check out SQLskills online training!
Blog:www.SQLskills.com/blogs/paul Twitter: @PaulRandal
SQL MVP, Microsoft RD, Contributing Editor of TechNet Magazine
Author of DBCC CHECKDB/repair (and other Storage Engine) code of SQL Server 2005
July 13, 2010 at 7:14 am
thank you for reply again paul.
I can't put the database in emergency mode...
How can i put the database in emergency mode in SQL Server 2000?
July 13, 2010 at 7:17 am
update master..sysdatabases
set status = status + 32768
where name ='My_database'
go
Not guaranteed to work at all in SQL 2000.
Paul Randal
CEO, SQLskills.com: Check out SQLskills online training!
Blog:www.SQLskills.com/blogs/paul Twitter: @PaulRandal
SQL MVP, Microsoft RD, Contributing Editor of TechNet Magazine
Author of DBCC CHECKDB/repair (and other Storage Engine) code of SQL Server 2005
July 13, 2010 at 7:22 am
It worked, the database is now in emergency mode, but when i try to put it on single user mode or see it's tables i always receive the same error:
Msg 946, Level 14, State 1, Line 2
Cannot open database 'SGT' version 0. Upgrade the database to the latest version.
Msg 5069, Level 16, State 1, Line 2
ALTER DATABASE statement failed.
July 13, 2010 at 7:30 am
See my first response...
Paul Randal
CEO, SQLskills.com: Check out SQLskills online training!
Blog:www.SQLskills.com/blogs/paul Twitter: @PaulRandal
SQL MVP, Microsoft RD, Contributing Editor of TechNet Magazine
Author of DBCC CHECKDB/repair (and other Storage Engine) code of SQL Server 2005
July 13, 2010 at 8:13 am
Does your client have a clean backup?
July 13, 2010 at 8:15 am
What do you mean by clean backup? it's a backup with no data inside?
July 13, 2010 at 8:17 am
Sorry, I meant a recent backup that is not affected by the corruption.
I assume you run backups / checkdb on a regular basis?
July 13, 2010 at 8:20 am
nop, the clients most recent backup if from April.....
July 13, 2010 at 8:24 am
I think you might be out-of-luck then. might not be a total loss as you could restore the data from April.
July 13, 2010 at 8:32 am
hoe can we restore it? we do not have information to restore the data
July 13, 2010 at 8:40 am
From the backup taken in April..
July 13, 2010 at 8:42 am
YES, but from april to july, where will we find data?
July 13, 2010 at 8:44 am
river1 (7/13/2010)
YES, but from april to july, where will we find data?
You don't.
The database is damaged beyond repair and you have no backups. That's pretty much an 'out-of-luck' situation.
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 15 posts - 1 through 15 (of 27 total)
You must be logged in to reply to this topic. Login to reply