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

Do you know what is difference between stored procedure and user defined function?

1099

How to connect Azure federated root database and apply federation in entity framework?

107

Can I save my report as html, excel or word? : sql server management studio

958

How to find table changes in sql server?

1128

What are the parts of a function?

945

Can you please differentiate between a primary key and a unique key?

1012

How to convert binary strings into integers in ms sql server?

1035

Explain the xml support sql server extends?

1045

Explain error and transaction handling in sql server?

1019

What are the differences between lost updates and uncommitted dependencies?

1086

What does truncate do?

944

How to set database to be read_only in ms sql server?

1016

What you can do to delete a table without the delete trigger firing?

974

How do users use Report Builder with SQL Server data sources?

160

How to create indexed view?

1051