We have an issue at our company where none of our computers can connect into one of our MSSQL databases. The DB engine is MSSQL 2000(ver 8).
We were able to access this DB through Enterprise Manager last week, but all of a sudden, nobody can interface with the DB anymore. My techy-admin guy doesn't know what happened. We've tried many other programs which are like Enterprise manager, but nothing can connect to this DB. Fortunately, our websites that use this DB can still talk to it fine.
So, does anyone know of anything that might be causing this? I know the information is vague, but thats all I have to work with. We don't have a clue what happened to our Enterprise Manager access to our DB.
Thanks for your suggestions,
Andres G.
To save your data please remove the last backup .bak file to a different server and install SQL Server in another box to see if you can register this server. If you cannot then you may have to run setup and take the repair option this is where the last backup being moved to another server is important, if the repair damage your database you can recreate the database with the.bak file through the backup and restore wizard in Enterprise manager by choosing the restore from device option. There are third party tools you can test drive. Hope this helps.
No comments:
Post a Comment