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

Explain couple pf features of SQL server

2 Answers  

Detail about query optimizer?

0 Answers  

What are the risks of storing a hibernate-managed object in a cache? How do you overcome the problems?

0 Answers  

What is dynamic cursor in SQL SERVER?

0 Answers  

when we use function instead of procedure? plz tell me the situation with ex?

3 Answers   IBM,

What is the difference between a stored procedure and a user defined function in sql server?

2 Answers   Millennium,

How can we remove orphan records from a table?

0 Answers  

HOW TO RENAME A COLUMN NAME

3 Answers  

List the ways in which dynamic sql can be executed?

0 Answers  

Define compound operators?

0 Answers  

Explain transaction isolation levels in sql server?

0 Answers  

How can we determine what objects a user-defined function depends upon?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories