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