I'm upgrading from SQL Server 2005 to 2008. I've detached the database I need, but can't find it on the file system.
Where does a default installation of SQL Server 2005 store these?
+1
A:
try this, run this query
use model
go
SELECT physical_name FROM sys.database_files
in my case on my laptop it is in this folder
C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\
SQLMenace
2010-08-17 00:01:55
not always true, especially not on a server, for example on my server Log files are on the L drive and data files on the U and V drives..it is determined by the model database
SQLMenace
2010-08-17 00:04:10
@SQLMenace: He's asking about a _default_ installation
SLaks
2010-08-17 00:05:19
I see, it also depends what you mean by default, our default is L for logs, M for system, T for tempdb and rest of userDB
SQLMenace
2010-08-17 00:08:24
@SQLMenace: But that's not a default _installation_.
SLaks
2010-08-17 00:18:10
+2
A:
You can also use management studio to look at the properties>files of any database - that will show the files and their growth settings.
Sam
2010-08-17 00:04:27
-1 because you didn't tell me to scroll to the right. Just kidding! :) Thank you very much!
kirk.burleson
2010-08-17 02:27:37
A:
You should probably do a database export from management studio so there aren't any compatibility issues.
Byron Whitlock
2010-08-17 00:11:11