SELECT * FROM MSDB..BACKUPSET WHERE Database

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 / pandian s

Answer Posted / pandian s

SELECT * FROM MSDB..BACKUPSET WHERE
Database_Name='<DatabaseName>'

Is This Answer Correct ?

1 Yes

1 No

Please Help Members By Posting Answers For Below Questions

Explain the creation and execution of a user-defined function in the sql server?

993

What is the architecture of ms sql reporting service?

918

What are Row versions of DataRow?

972

What are the different types of subquery?

1093

How do you create a clustered index?

997

How can I create a report based on a query? : sql server management studio

969

Define candidate key, alternate key, and composite key.

866

How to invoke a trigger on demand?

1025

How to drop an existing stored procedure in ms sql server?

959

How to use values from other tables in update statements in ms sql server?

1038

List some advantages and disadvantages of stored procedure?

964

How do I run sql server 2014?

936

What is the cartesian product of the table?

902

Explain what are the authentication modes in sql server?

942

How do you start single user mode in clustered installations?

901