1.How to check the backup file details if we do not have access to that folder

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

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

Answers were Sorted based on User's Feedback

1.How to check the backup file details if we do not have access to that folder 2.how to check the..

Answer / basha

SELECT * FROM SYSFILES, run this query against the db to
which u have to find file size.

Is This Answer Correct ?

12 Yes

3 No

1.How to check the backup file details if we do not have access to that folder 2.how to check the..

Answer / pandian s

SELECT * FROM MSDB..BACKUPSET WHERE
Database_Name='<DatabaseName>'

Is This Answer Correct ?

1 Yes

1 No

1.How to check the backup file details if we do not have access to that folder 2.how to check the..

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