The database object contains a member 'get_LogFiles' that returns a nice collection of the database's logfiles. I can't seem to find the comparable member to return the collection of datafiles. If someone can point me in the right direction, I would be most grateful
That's because log files do not reside in filegroups.
Check out the filegroup property, this contains a collection of data files.
WesleyB
Visit my SQL Server weblog @. http://dis4ea.blogspot.com
sql
No comments:
Post a Comment