Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2009
    Posts
    73

    Question Unanswered: Mssqlsystem resource database ????

    i cannot see mssqlsystemresource database on my server

    i installed fresh copy of Mssql 2005 std 64 bit with sp1

    where is mssqlsystemresource database i have read about this databse in blogs ut cannot find it ....i m a new to this..Help!!!

  2. #2
    Join Date
    Jan 2003
    Location
    British Columbia
    Posts
    44
    From Books Online, iow the help file

    The physical file name of the Resource database are mssqlsystemresource.mdf and mssqlsystemresource.ldf. By default, these files are located in <drive>:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\. Each instance of SQL Server has one and only one associated mssqlsystemresource.mdf file, and instances do not share this file. In a cluster, the Resource database exists in the \Data folder on a shared disk.

  3. #3
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    The mssqlsystemresource database isn't user-accessible. As the name implies, it is a system resource.

    -PatP
    In theory, theory and practice are identical. In practice, theory and practice are unrelated.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •