I have a 500 GB Database File (MDF) & (LDF) SQL Server 2005 sitting on an External Device Drive. Western Digital. I've attached the database back to the SQL Server Management Studio; but the MDF and LDF reside on the External Device.
The data is only being used for archiving purposes. End Users will be viewing the data only
1. Will this slow down performance?
2. Good Idea?
3. Is it good to have the end user making changes on this drive? Updates and Adds ( or be too slow)
Any information that can be useful will help.