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

How to assign null values to variables or columns?

955

Explain what is “asynchronous” communication in sql server service broker?

895

What structure can you implement for the database to speed up table reads?

1179

Explain syntax for viewing trigger?

903

Give me any three differences between Truncate and Delete.

1083

What is ddl command?

956

How to check status of stored procedure in sql server?

957

What is measure group, measure? : sql server analysis services, ssas

993

What is BLOCK statements in SQL?

1248

Explain few examples of stored procedure over triggers?

1009

Can we use trigger new in before insert?

895

What is logshipping and its purpose?

973

How to insert new line characters into strings?

967

What is clustered primary key?

995

How do I know if localdb is running?

928