Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Find all data and log files

Author  Topic 

Peter99
Constraint Violating Yak Guru

498 Posts

Posted - 2011-02-09 : 11:50:21
Hi,
I am trying to find out all data and log files in sql server instance. In sql server 2005 I can use following query for this purpose:
SELECT name, physical_name AS current_file_location
FROM sys.master_files

But I don't know how to do it in sql server 2000. When I run this query in 2k it gives error sys.master_files not found, any help will be appreciated.

Thanks

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2011-02-09 : 14:57:33
[code]select fileid, name, filename from sysaltfiles[/code]
Go to Top of Page
   

- Advertisement -