July 4, 2009 at 3:50 pm
I have reloaded SQL 2000 on Windows Server 2003 beacuse of data corruption. The problem is reconnecting the data files. Do they need to be exported and reimported? Are there any instruction flow charts? I can only find instructions for SQL 2005
July 5, 2009 at 11:42 am
Look up attach in Books Online. you can re-attach the data files.
However that won't get you logins.
What was the problem originally, and what did you do?
July 5, 2009 at 11:50 am
If you reinstalled sql server coz of corruption, i think it'd persist as corruption happens to your database files. If you do not have a clean backup, i think u're going to lose data depending of what type of corruption you had in the past, however some of the corruption issues can be resolved without losing data. Did you run dbcc checkdb on your database earlier?
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply