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
Answers were Sorted based on User's Feedback
Answer / basha
SELECT * FROM SYSFILES, run this query against the db to
which u have to find file size.
Is This Answer Correct ? | 12 Yes | 3 No |
Answer / pandian s
SELECT * FROM MSDB..BACKUPSET WHERE
Database_Name='<DatabaseName>'
Is This Answer Correct ? | 1 Yes | 1 No |
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 |
What are number line correlation administrators will use while working with a subquery?
What is the maximum rows in sql server table?
Explain the properties of a relational table?
What is a field name?
Explain different forms of normalization?
What are mdf,ndf,ldf files and how to see the data in those files?
How do I uninstall sql server 2014?
List the different types of collation sensitivities in sql server?
How many types of keys are there?
Why the trigger fires multiple times in single login?
How to concatenate two strings in SQL Server.
how to find 6th highest salary