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 do I view a stored procedure in sql server?

975

Do you know how to implement service broker?

926

What functions can a view be used to performed?

1054

What does executeupdate return?

968

Can select statements be used on views in ms sql server?

1057

How to receive returning result from a query?

1109

What are different types of views?

940

How to create an index on a view?

1060

What is logshipping and its purpose?

984

What happens if date-only values are provided as date and time literals?

1013

Why truncate is ddl?

1078

What are the disadvantages of indexes?

1076

What is attribute relationships, why we need it? : sql server analysis services, ssas

956

Does transparent data encryption provide encryption when transmitting data across the network?

1028

What is a non-clustered index?

990