Re: DataFile and Log File

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

In SQL Server 2000?

Thanks

"Andrew J. Kelly" <sqlmvpnooospam@xxxxxxxxxxxx> wrote in message
news:OGIt1IRiHHA.392@xxxxxxxxxxxxxxxxxxxxxxx
Have a look at the sys.database_files catalog view in BOL.

--
Andrew J. Kelly SQL MVP

"Rogers" <naissani@xxxxxxxxxxx> wrote in message
news:OsKzR7QiHHA.5008@xxxxxxxxxxxxxxxxxxxxxxx
I want to know the datafile and log file for the given input parameter. I
am basically creating function and the input parameter would be database
name and that will return me DataFile and the LogFile.

Can anybody tell me which query I have to used in the function. I have to
used to get the DataFile and LogFile






.

Relevant Pages

  • Re: DataFile and Log File
    ... am basically creating function and the input parameter would be database ... name and that will return me DataFile and the LogFile. ...
    (microsoft.public.sqlserver.clients)
  • DataFile and Log File
    ... I want to know the datafile and log file for the given input parameter. ... basically creating function and the input parameter would be database name ... and that will return me DataFile and the LogFile. ...
    (microsoft.public.sqlserver.clients)
  • Re: Growing Database problem,
    ... Both are, the logfile is actually 160mb, the data 140mb. ... > Is it the log or the datafile which is growing huge? ... Checked by AVG anti-virus system. ...
    (microsoft.public.sqlserver.server)
  • HOW TO RESTORE BACKUP
    ... ANYBODY PLEASE TELL ME HOW TO RESTORE FROM BACKUP (ONLY DATAFILE IS ... NEEDED) WITHOUT ADDING LOGFILE BECAUSE LOG FILE SIZE IS VERY LARGE ...
    (microsoft.public.sqlserver.setup)