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

Who is the owner of a schema in ms sql server?

0 Answers  

In clustered and non clustered indexes which one is faster while executing a query ?

1 Answers  

What are the types of lock supported by ?

0 Answers   HCL,

Thanks to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down?

0 Answers  

how to write test cases for testing databases,especially for testing and writing test cases for stored procedures.any real time database testers.please answer me.

0 Answers  

i have account table which consists of account name,card no and card no consists 16 digits now i want to retrieve the data if card no starts from 4 then it should print visa and if it starts from 5 then it should print master so plse help me to write simple query with out store procs .

3 Answers  

What are the properties of sub-query?

0 Answers  

What is the difference between upgrade and migration in sql server?

0 Answers  

What is acid mean in sql server?

0 Answers  

As a general practice, it is recommended to have dbo be the owner of all database objects however, in your database you find number of tables owned by a user other than dbo, how could you fix this?

0 Answers  

Explain filtered indexes?

0 Answers  

What is difference statement and preparedstatement?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories