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 is RAID and what are different types of RAID configurations?
In clustered and non clustered indexes which one is faster while executing a query ?
What are the types of stored procedures in an sql server?
Do you know what are various aggregate functions that are available?
What is outer join in sql server joins?
What are key, name and value columns of an attribute? : sql server analysis services, ssas
where the connection string store in the database
Can we write a distributed query and get some data which is located on other server and oracle database?
What is transaction server distributed transaction?
Which sql server table is used to hold the stored procedure script?
what is an index? : Sql server database administration
What is usually the first word in a sql query?