Sql server 2000 data file location

Not an IT pro? Windows Server TechCenter. Sign in. United States English. Ask a question. Quick access. Search related threads. Microsoft SQL Server has become one of the most popular relational database management systems for small and large businesses alike.

IT pros need to be able to say exactly where important SQL database files are stored, without delays or errors, for multiple reasons, such as to facilitate backups and recovery processes, to transfer files to another location, or to find the folder if a server instance was installed to a non-standard location.

The default database file location for server instances depends on the version of the Microsoft SQL Server software:.

SSMS allows you to check one database at a time, and queries require a fair amount of expertise and time to compose them. You can also report and alert on configuration changes, such as modifications to important functions, schemas, functions, database options and object owners. Even better, Netwrix Auditor also provides deep visibility into permissions to your SQL instances, databases and other SQL objects, as well as reporting and alerting on changes to those permissions.

With this powerful tool, you can spot and revert improper or malicious changes to configurations and permissions before they lead to downtime or a data breach. Using this script you can show all the databases name and files used with exception of system dbs. Below script can be used to get following information: 1. DB Size Info 2. FileSpaceInfo 3. AutoGrowth 4. Recovery Model 5. This script lists most of what you are looking for and can hopefully be modified to you needs.

Note that it is creating a permanent table in there - you might want to change it. It is a subset from a larger script that also summarises backup and job information on various servers. Following query gives you the current name of the database and the Logical file name which might be the original name of the Database when it was created and also corresponding physical file names. To get around queries which error when multiple data files e.

Stack Overflow for Teams — Collaborate and share knowledge with a private group. Create a free Team What is Teams? Collectives on Stack Overflow. Learn more. Asked 9 years, 10 months ago. Active 3 months ago. Viewed k times. I'd like to get a list showing which database is using what files on the local disk.

Improve this question. Vadim Kotov 7, 8 8 gold badges 45 45 silver badges 61 61 bronze badges. M4N M4N Add a comment. Active Oldest Votes. Improve this answer. Mikael Eriksson Mikael Eriksson k 21 21 gold badges silver badges bronze badges. Thanks, that joined with sys. Factor Mystic Mehdi Haghshenas Mehdi Haghshenas 2, 1 1 gold badge 13 13 silver badges 33 33 bronze badges. What is Use [?

It gives an error that it cannot find that stored procedure.