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 / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the difference between ddl and dml?

768


Tell me something about security and sql azure?

112


Explain the types of indexes.

831


What is the meaning of sql server?

694


After creating the cube, if we added a new column to the oltp table then how you add this new attribute to the cube? : sql server analysis services, ssas

727






how can a database be repaired? : Sql server administration

685


What is user-defined inline table-valued function?

691


How do you run a trace?

686


Mention the differences between substr and charindex in sql server.

692


How many types of subqueries are there in sql server?

657


What is normalization? Describe its different types.

762


How sql server enhances scalability of the database system?

774


Tell me what do you understand by a view? What does the with check option clause for a view do?

794


What are the new features introduced in SQL Server 2000 (or the latest release of SQL Server at the time of your interview)? What changed between the previous version of SQL Server and the current version?

798


What is a self join in sql server?

775