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
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
What is the difference between dbcc indexdefrag and dbcc reindex?
What is snapshot report?
what is isolation level at dead lock?
What is a DBMS, query, SQL?
What are the five characteristics of good data?
What are the different types of locks in the database?
Is it possible to import data directly from t-sql commands without using sql server integration services? If so, what are the commands?
How do I manually uninstall an instance of sql server 2016?
How to create a simple stored procedure in ms sql server?
List out the difference between union and union all in sql server?
List out different types of normalizations in sql server and explain each of them?
What is self contained scalar sub query?
How to get a list of columns in a view using the "sp_columns" stored procedure?
how to trace the traffic hitting a sql server? : Sql server database administration
Do you know what is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure?