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 mysql and mysqli?
Explain different forms of normalization?
How to download microsoft sql server 2005 express edition?
What is the default sql server instance name?
What is the correct order of the logical query processing phases?
What are the differences between DDL, DML and DCL in SQL?
How to get the definition of a user defined function back?
there is a trigger defined for insert operations on a table, in an oltp system. The trigger is written to instantiate a com object and pass the newly inserted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better? : Sql server database administration
What is sql server transaction log file?
If the job running very slow what is the action you do
What is tempdb in sql server?
What is impersonation? What are the different impersonation options available in ssas? : sql server analysis services, ssas
Why should one not prefix user stored procedures with ‘sp_’?
How do you improve the performance of a SQL Azure Database?
Can you edit the .rdl code associated with a linked report?