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 de-normalization in sql database administration? Give examples?
How to drop existing indexes in ms sql server?
What are the different sql server versions?
Explain transaction server implicit?
What is the use of @@spid?
role of sql sever 2005 in database rather than any other database
How you can get a list of all the table constraints in a database?
What is field in algebra?
What program is used to store the data source file?
What will be query used to get the list of triggers in a database?
What is the use of partition by in sql server?
What is db stored procedure?
How to throw custom exception in Stored Procedure?
Explain four layers of abstraction microsoft architectured?
What is the difference between cube operator and rollup operator? : SQL Server Architecture