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

hi i am having .mdf file and .ldf file ..how can i get the all table in my .mdf..plz give solution

2 Answers  

After removing a table from database, what other related objects have to be dropped explicitly?

0 Answers  

What are the pre-defined functions in the sql server?

0 Answers  

What is NOT NULL Constraint in sql server 2012?

0 Answers   CDC,

What is partition in sql server?

0 Answers  

how to change column into row in sql

4 Answers   ESS,

How do you set a trace flag in sql server?

0 Answers  

What is the difference between composite index and covering index?

0 Answers  

How to delete duplicate rows?

0 Answers  

How to use linked server?

0 Answers  

Which virtual table does a trigger use?

3 Answers  

What is the difference between substr and charindex in the sql server?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories