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 many servers can we create in a single subscription?

154

what is memory-optimized nonclustered indexes

650

How to retrieve error messages using odbc_errormsg()?

618

What are the steps to take to improve performance of a poor performing query? : sql server database administration

689

How to find index size for each index on table?

670

How do we synchronize On-Premise SQL server with SQL Azure?

106

What is fill factor and pad index?

650

What are the advantages of partitioning?

742

What is a fill factor?

719

Define outer join?

623

What is DCL?

676

Explain the different types of backups available in sql server? : sql server database administration

593

What are the purpose of Normalisation?

715

How do I completely remove sql server instance?

670

What is transaction server distributed transaction?

633