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

Why should you use or avoid select * statements?

1109

Explain system functions or built-in functions? What are different types of system functions?

1065

How can I check that whether automatic statistic update is enabled or not?

1112

How do I create a trace in sql server?

1120

How to remove duplicate rows from table except one?

1088

What is a view in sql?

1040

How to provide default values to function parameters?

1259

what is spatial nonclustered index

1058

What is a scheduled job or what is a scheduled task?

1039

How can we solve concurrency problems?

1122

Why use identity in sql server?

1199

Why and when do stored procedure recompile?

1061

What is temporary table in sql server? Why we use temp table?

1021

How to convert numeric expression data types using the cast() function?

1149

What are the properties of the transaction?

1073