April 13, 2010 at 8:05 pm
I have a problem
My sql server 2000 database crashed but data files are still there.
I want to reinstall the sql server 2000 on a new hard disk and want to try attach the data files without detach them but I would like to know any impacts of attaching the data files without detaching them in the first place
April 13, 2010 at 9:51 pm
First things first - take a copy of the files before you do anything.
Next...since SQL Server crashed, there may be transactions that are partially committed i.e. transaction recovery will need to be run against the database before it is usable. This is part of the normal startup process done by SQL Server.
I am not 100% what would happen if you simply attempted to attach the files. What I would do is
- create a new database with files in similar locations to those from the original database
- stop SQL Server
- rename the files so that the files from the old/crashed server database have the names of the new database
- start SQL Server
At this point SQL will simply run transaction recovery and you database should be up and running as soon as that is complete.
April 14, 2010 at 1:52 am
is it possible to get the structure of all tables using a data file
April 21, 2010 at 6:25 am
Until you get SQL Server to open the database (e.g. per my my previous post), you will not be able to very much with the database.
April 21, 2010 at 6:32 am
shinobigoh (4/13/2010)
I have a problemMy sql server 2000 database crashed but data files are still there.
I want to reinstall the sql server 2000 on a new hard disk and want to try attach the data files without detach them but I would like to know any impacts of attaching the data files without detaching them in the first place
When you say the database "crashed", what do you mean exactly?
The Redneck DBA
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply