Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

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

Question Posted / chaithanya

Answers were Sorted based on User's Feedback



1.How to check the backup file details if we do not have access to that folder 2.how to check the..

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

1.How to check the backup file details if we do not have access to that folder 2.how to check the..

Answer / pandian s

SELECT * FROM MSDB..BACKUPSET WHERE
Database_Name='<DatabaseName>'

Is This Answer Correct ?    1 Yes 1 No

1.How to check the backup file details if we do not have access to that folder 2.how to check the..

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

More SQL Server Interview Questions

What is attribute hierarchy? : sql server analysis services, ssas

0 Answers  

Tell me in brief how sql server enhances scalability of the database system?

0 Answers  

How do I compare two values when one value(data type) is char and the other is an integer?

3 Answers  

What is sqlcmd?

0 Answers  

Tell me time data type, datetime2, datetimeoffset data type in sql server 2008?

0 Answers  

what is trigger . hw will it use them

2 Answers   TCS,

what is the importence of the trigger in sqlserver2000?

1 Answers   ATI,

What number aggregate functions are accessible there in sql?

0 Answers  

What are sql dirty pages?

0 Answers  

What is sql server schema compare? How we can compare two database schemas?

0 Answers  

What is GUID in sql server?

0 Answers   BirlaSoft,

How is sql server used?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories