Hi guys. I have a question.

I'm trying to locate the database in the SQL Server. Normally I can access the database in "Windows Authentication" mode (I think), but I'm having a little trouble in locating the database in "SQL Server Authentication".

The default location for the databases is "C:\Program Files\Microsoft SQL Server\MSSQL10_50.IDDMSSQLSERVER\MSSQL\DATA" and the problem is that I'm unable to find this default location. I've tried almost everything that I know and I'm having a lot of trouble in what key words do I need to use in google to search for the answer in my problem.

I was planning to update the database and the options that I have right now is to:

1.) Detach the database that I needed to update
2.) Copy the entire database and move all the data into another database.

The first option is actually a bad idea and I'm planning on using the 2nd option.

I hope you guys could help me in my problem.