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 the report builder?

143

How to Sync Two SQL Azure Databases?

121

What is the use of =,==,=== operators?

1058

Which joins are sql server default?

1071

Explain the microsoft sql server delete command?

1079

What command is used to delete a table from the database in the sql server and how?

1189

What is 3nf normalization?

1051

What is an example of a primary key?

1037

What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting is possible?

1016

which table keeps the locking information? : Sql server administration

1140

What is dml command?

1020

How to change the system date and time from SQL Plus Terminal ?

1272

Give an example of why you would want to denormalize a database

1030

What are cursors and when they are useful?

1151

Explain the third normal form(3nf)?

982