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

how to create “alternate row colour”?

109

What is tablix?

115

Explain the different index configurations a table can have?

502

Define primary key?

655

Describe different Processing Modes offered by SSRS?

164

What are xml indexes?

526

What are the purposes of floor and sign functions?

536

Can we update data in a view?

599

How to use union to merge outputs from two queries together in ms sql server?

556

What is the difference between clustered and a non-clustered index?

591

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

534

Explain sql delete command?

605

What are various limitations of the views?

609

How to test values returned by a subquery with the in operator?

667

Explain transaction server auto commit?

531