Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
amitkumarmadhukar
Starting Member
45 Posts |
 Posted - 2005-09-10 : 02:53:06
|
| Hello Guys,I have a Problem. Today My SQL Server 2000 refuse to Start. When i Start the service manually . it refuse to start. however sql server agenet, search and transaction controller are started.i try to rebuild the registary . but all in vain.now the problem is i have a database. in which i made some table label changes. i put some stored procedures and trigger and i my last backup does not incorporated with these new changes.however i have my mdf and ldf files are intact. can i recover my atleast data structureits an emergancyplase help meamit kumar madhukar |
|
|
Kristen
Test
22859 Posts |
Posted - 2005-09-10 : 07:08:22
|
| Basically you should be able to do something like:1) Make sure SQL Server is stopped (sounds like it is!)2a) Copy the MDF and LDF to another server2b) Ideally put them in exactly the same drive/folder on the New Server3) "ATTACH" the database on the New ServerKristen |
 |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2005-09-10 : 15:51:43
|
| What made you decide to try and rebuild the registry??MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
|
|
|
SQl Server Failure while Startup