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 |
|
velvettiger
Posting Yak Master
115 Posts |
 Posted - 2009-09-08 : 11:22:55
|
| Hi all,- Running SQL SERVER 2000- One server host 4 territoriesCurrently, my company host 4 databases for 4 different countries. Lets call them A,B,C and D. Each territory has basically the same data structure. I came into the office and found that database A, B and C were missing from the SQL window. I checked the server and I got the blue screen. I then referred to my backups and they to were corrupted.(The were on separate machines. Apparently one of developers were running some code on the servers containing databases A to D and it gave a timeout error and crashed so he went on the next available machine (backup) and destroyed everything and the thing is I am not a db administrator and my company doesn't have one on the pay roll, I am a simple data analyst and.. ok i am bantering back to the issue).The data.mdf and log.mdf files for B and C are on the system but I keep getting the 823 error, when I try to attach them back unto the SQL server.Database A has been completely deleted. ie there are no mdf or ldf files for A.So I managed to save the D_data.mdf and the D_log.ldf files. I was advised to copy the tables,store procedures, functions etc into an empty database for each territory, rename them as B, C and A and then import new data.Do you guys think that this is the best step right now?Does any know how to import into a new database the tables,store procedures, functions etc from an existing database using the wizard. It was said that I shouldn't copy the data.mdf and log.ldf , rename them and then attach it as the new name. |
|
|
velvettiger
Posting Yak Master
115 Posts |
Posted - 2009-09-08 : 11:26:01
|
| I forgot to mention that I couldn't run DBCC CHECKDB because I was not able to access the databases. |
 |
|
|
|
|
|
|
|
Error Message 823