Hello,

I am new to a system and there are a lot files in a SQL database, most of these files are empty. Because I am only interested in files that contain records I would like to know if there is a tool that gives an overview of all the files and their properties (like numer of records) in a SQL server database.

Many thanks in advance,

John

By default there are two files associated with sql database
.mdf and .ldf

you can find this files in program files/mssql/........../data
folder
if you want to keep copy of that file than stop sql service and then copy files
also you can use attach,detach database procedures

urt

 

Um.... no... there are two files per database as a default and I guarantee that none of them are empty even when first created.

What do you mean by "files"???

--Jeff Moden

With files I mean tables, (I come from I-series system where files and members are the terms in use).

My question remains: is there a tool that gives an overview of all the tables and their properties (like numer of records) in a SQL server database.
Many thanks in advance,

John

Yes... and a bit more, as well... takes a bit to run but if you direct the output to a table or a spreadsheet, had lot's of useful info...

DBCC SHOWCONTIG WITH TABLERESULTS

--Jeff Moden

Thank you very much Jeff Moden!

Regards,

John