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 >> DB Administration
  2. Suggest New Category

one datafile is lost in standy side how can you recover that??

Question Posted / anil.t

Answer Posted / anil.t

Yes we can recover the database but we will lose uncommitted transactions since log file is not available.

From 2005 onwards we use option called:
CREATE DATABASE database_name for ATTACH option.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

I have kept recovery catalog on same target database and taken backup of target DB to disk. deleted the target DB & tried to restore and revoer DB using the backup on disk but it is not possible, how do we restore & recover DB

1887

how can you process messages in order asynchronously?

931

When setting replication, can you have distributor on sql server 2005, publisher on sql server 2008? : sql server DBA

950

how does an oracle clusterware manage crs resources?

1028

How to bind a cobol module to a given job? I am not able to understand this concept.Can anyone help me out as how to carry out this task?

2036

how do we explain a project in cognos in an interview? please help me. Also how do we perform testing in cognos after creating reports?

3346

What would you do with an "in-doubt" distributed transaction?

1833

What are the differences in clustering in sql server 2005 and 2008 or 2008 r2? : sql server DBA

940

A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables?

2401

What is fill factor? : sql server DBA

1185

what is ora 24313?what is the procedure to exclude that error?

2521

What are the steps you will take to improve performance of a poor performing query?

2794

You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?

2747

How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database? : sql server DBA

1141

How do you troubleshoot errors in a sql server agent job? : sql server DBA

1054