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

Indexes are updated automatically is the full-text index also updated automatically?

1065

How to create new tables with "select ... Into" statements in ms sql server?

1048

How to fine-tune reports?

279

What is the difference between Normalization and De-normalization?

1145

What is the difference between grant and with grant while giving permissions to the user?

1025

What according to you is the difference between mysql and sql server performance?

1145

How can we get count of the number of records in a table?

996

What is the correct order of the logical query processing phases?

995

What is indexing explain it with an example?

1070

What is a partition key?

1030

What are the different methods available under sqlcommand class to access the data?

1169

Explain what you mean by 3 tier architecture.

1127

What is Federation Root Database?

104

Can I use sql azure as a backup with log shipping or database mirroring?

156

Please explain go command in sql server?

1112