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

How to insert multiple rows with a subquery?

0 Answers  

What is normalization and denormalization in sql server?

0 Answers  

What is store procedure? When do you use?

0 Answers  

Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting are possible?

0 Answers  

Describe in brief databases and sql server databases architecture.

0 Answers  

What is a trigger and types of a trigger?

0 Answers  

Can a database be shrunk to 0 bytes, if not, why?

0 Answers  

How to check if a table is being used in sql server?

0 Answers  

wat is tuff file in log shipping, wt is d use of tht file?

1 Answers   TCS,

What is named calculation? : sql server analysis services, ssas

0 Answers  

Why I am getting "the microsoft .net framework 2.0 in not installed" message?

0 Answers  

What is a hint?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories