SELECT * FROM SYSFILES, run this query against the db to which u have to

1.How to check the backup file details if we do not have
access to that folder
2.how to check the backup file size without connecting to
the folder

Question Posted / basha

Answer Posted / basha

SELECT * FROM SYSFILES, run this query against the db to
which u have to find file size.

Is This Answer Correct ?

12 Yes

3 No

Please Help Members By Posting Answers For Below Questions

What is subquery in sql?

986

What is rolap and its advantage? : sql server analysis services, ssas

1218

What is the latest version of microsoft sql server?

955

How to fetch the next row from a cursor with a "fetch" statement?

1015

What is wide table?

881

Explain transaction server implicit?

923

What does ss stand for sexually?

1009

Explain ms sql server reporting services vs crystal reports?

852

Can you explain important index characteristics?

935

In what version of sql server were synonyms released?

903

How to get all stored procedures in sql server?

936

Explain time data type in sal server 2008?

869

What is self contained multi valued query?

944

What happens if null values are involved in datetime operations?

898

What is factless fact table? : sql server analysis services, ssas

960