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

Explain linked server in sql?

1206

What are different types of database indexes?

1088

What is sql server database?

995

How to apply filtering criteria at group level with the having clause in ms sql server?

993

What is the meaning of lock escalation and why/how to stop this? : sql server database administration

1029

What languages bi uses to achieve the goal?

998

Differentiate between a having clause and a where clause.

960

In what three ways is the return statement used in a stored procedure?

1002

What is difference between standardization and normalization?

1087

Explain time data type in sal server 2008?

918

What are the different types of data sources in ssrs?

196

What are the drawbacks of reporting in ssrs?

149

How to set a database state to offline in ms sql server?

1037

What is clustered primary key?

1008

What is the server name in sql server?

999