SQL database copy locations
The database copies are named master$4idr, mastlog$4idr, model$4idr, and modellog$4idr.
See Restarting SQL using database copies.
Table: SQL database copy locations
|
SQL database copy
|
Location
|
|
A default installation of SQL 2000
|
C:\Program Files\Microsoft SQL Server\MSSQL\Data\*.* |
|
A named instance of SQL 2000
|
C:\Program Files\Microsoft SQL Server\MSSQL$Instance_Name\Data\*.* |
|
An initial installation of SQL 2005 or later
|
C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\*.* |
|
A second installed instance of SQL 2005 or later
|
C:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\Data\*.* |
|
A default installation of SQL 2008
|
C:\Program Files\Microsoft SQL Server\MSSQL10.<instance name>\MSSQL\Data |
SQL database copy locations