Home > IT Answers > SQL Server > sysfiles1 is missing sql server 2005
AshwiniSrinivasa
5 pts.
 sysfiles1 is missing sql server 2005
SQL Server 2005, sysfiles1
is sysfiles1 table removed in SQL Server 2005 onwards?

Software/Hardware used:
ASKED: May 3, 2010  2:19 PM
UPDATED: May 4, 2010  1:53 PM
RELATED QUESTIONS
Answer Wiki:
Yes it has been removed. Use sys.database_files instead.
Last Wiki Answer Submitted:  May 4, 2010  6:57 am  by  Denny Cherry   64,520 pts.
All Answer Wiki Contributors:  Denny Cherry   64,520 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

But this query still returns one row (an object of type S):

select * from sys.objects where name = 'sysfiles1'

And the description for error # 5024 (from SQL Server 2008 Books Online) is:

“No entry found for the primary log file in sysfiles1. Could not rebuild the log.”

Did it really get removed, or was it kept for backward compatibility ?

carlosdl
 63,535 pts.