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 schemabinding a view?
What is sql sandbox in sql server?
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
How to fetch the next row from a cursor with a "fetch" statement?
What is database replication?
What are synonyms?
Explain datetime2 data type in sal server 2008?
What is importing utility?
Which data types generate inaccurate results if used with an = or <> comparison in a where clause of a sql statement?
Tell me what is the order in which the sql query is executed?
How the authentication mode can be changed?
What is sub-query in sql server? Explain its properties.
How to delete existing triggers using "drop trigger"?
Explain what is public role in sql server?
What are system databases into sql server (2005/2008) : sql server database administration