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 / pandian s
SELECT * FROM MSDB..BACKUPSET WHERE
Database_Name='<DatabaseName>'
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
Explain how dts is used to extract, transform and consolidate data?
What is CTE in SQL
What can be used instead of trigger?
Write a Select Query to display title for each group of records, which are collected with Compute Clause? Like titlefield column-A column-B ..... ..... ..... Sum ... titlefield column-A column-B ..... ..... ..... Sum ...
How to modify an existing user defined function?
Explain the different types of joins?
What do you understand by hotfixes and patches in sql server?
can you instantiate a com object by using t-sql? : Sql server database administration
What is the synonym of join?
What command do we use to rename a database?
What is isnull() operator?
What is openxml in sql server?
What is a not null constraint?
Do you know what are the differences between lost updates and uncommitted dependencies?
Can anyone tell that the extra features are there in SQL SERVER 2008 that are not available in previous versions .