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 happens if ntwdblib.dll is missing on your machine?
What is dbcc?
Can you pass expressions to function parameters?
What are the differences in Clustering in SQL Server 2005 and 2008 or 2008 R2?
how to define testing of network layers? : Sql server database administration
What is SQL Azure Fabric?
What is abstracting periodical?
What is database architecture? : SQL Server Architecture
Tell me what is the difference between locking and multi-versioning?
How do I find the transaction log size in sql server?
How can we use ConnectorJ JDBC Driver with MS SQL?
Tell me what are the essential components of sql server service broker?
what are triggers? : Sql server database administration
what is a major difference between sql server 6.5 and 7.0 platform wise? : Sql server database administration
In which format does an image save in SQL Server database ?