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 |
|
neil
Starting Member
29 Posts |
 Posted - 2003-01-08 : 14:06:24
|
| We had a problem with a virus on the network. Some of the SQL Server executables and Dll's are damaged. The SQL Server services seem to be okay as I can connect throught the client and through web applications. What is the best way to repair the SQL Server installation as the data files seem to be okay as my tables and sproc's seem to be operating as normal.Can I de-attach the data files remove the current installation and do a fresh install of SQL server and then re-attach the data files and the transaction logs. If this is not possible how would I repair SQL server install.Thanks |
|
|
royv
Constraint Violating Yak Guru
455 Posts |
Posted - 2003-01-08 : 14:17:14
|
| ****YOU NEED TO MAKE SURE BEFORE TRYING THIS******You can reinstall SQL Server, I think, without detaching the database, it will not overwrite your db files. There should not be an issue with losing your database if you try to reinstall SQL Server***************************************Death must absolutely come to enemies of the code! |
 |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2003-01-08 : 14:22:26
|
| NO.Reinstalling will overwrite the master db, and you won't have rows in master..sysdatabases that point to your existing database files.Do a real detach, reinstall the software, and then attach the files afterwards. This ensures that SQL Server recognizes everything properly.Take a look at AjarnMark's articles on migrating to SQL 2000:http://www.sqlteam.com/item.asp?ItemID=9066http://www.sqlteam.com/item.asp?ItemID=9465He has a checklist of steps to do in order to make sure everything proceeds smoothly. |
|
|
|
neil
Starting Member
29 Posts |
Posted - 2003-01-09 : 07:34:36
|
| SQL Sever uninstall is corrupted How do you remove SQL Server to re-install ? Thanks |
|
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2003-01-09 : 08:17:02
|
| Given the problems you have had I would copy the database backups off the server, reformat the disk and reinstall everything from scratch then restore the databases. Or attach the files if you can't do a backup.Do a test attach to another server before junking this one.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
neil
Starting Member
29 Posts |
Posted - 2003-01-09 : 09:57:06
|
| Thanks for all your help, the server is now back online |
|
|
|
royv
Constraint Violating Yak Guru
455 Posts |
Posted - 2003-01-09 : 10:24:47
|
| Apologize for the incorrect wording, I should have said that you need to detach the database. What I meant to express in my post was that you will not physically overwrite your db files (mdf, ldf) when you reinstall SQL Server. Anyway, things are working, that's great.***************************************Death must absolutely come to enemies of the code! |
|
|
|
scottpt
Posting Yak Master
186 Posts |
Posted - 2003-01-14 : 15:27:25
|
| Actually, I have copied the data files off, master and all. Reinstalled Sql server to the same SP and using the same sort orders and everything. Stopped the services copied all the datafiles backover and restarted the services. The server was fine. |
|
|
|
|
|
|
|
|
SQL Server executables are corrupted