The back up details would have been stored in the system table backupset

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 / rajasethupathy

3 Answers
7715 Views
CarrizalSoft Technologies, IBM, I also Faced
E-Mail Answers

Answer Posted / rajasethupathy

The back up details would have been stored in the system
table backupset of system database msdb. So we can get it
from there.

ex

use msdb
select * from backupset

Is This Answer Correct ?

1 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is forward - only cursors / read only cursor?

1071

What is the purpose of the model database?

1003

What is updatable resultset?

982

explain different types of backups avaialabe in sql server? : Sql server database administration

957

Explain what stored procedure sp_replcounters is used for? : sql server replication

1488

Explain primary key?

947

How to get a list of table columns using the "sp_columns" stored procedure in ms sql server?

996

What is normalization? Explain different forms of normalization?

1122

what is the main function of a query parameter?

152

How do I start sql server?

956

How to create user defined functions with parameters?

1205

What is dirty read?

1066

What is PROJECTION Operation?

1004

What are page splits?

986

What is transaction server distributed transaction?

1021