Interested to Buy Any Domain ? << Click Here >> for more details...
I lost one datafile i dont have backup how can you recover that???
- 2 Answers
- 6194 Views
- HP, I also Faced
- E-Mail Answers
Answer Posted / mohapatra.gouranga@gmail.com
Recovery is not possible if no backup.
But inconsistent recovery is possible by following method:
1.shutdown your database
2.take the database in mount state
3. Make the tablespace of lost datafile to off line.
4.alter database create datafile 'old_datafile_path'
as 'new_datafile_path';
5. Made the database online.
6.once new file created do the incomplete recovery. from
any old backup.
7. open the database with resetlogs.
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
Due 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? : sql server DBA
What are the differences in clustering in sql server 2005 and 2008 or 2008 r2? : sql server DBA
what is the last version,the release date of that version and fix pack of ibm db2 udb?
What would you do with an "in-doubt" distributed transaction?
What is dbcc? : sql server DBA
I got an error SQL1042C. An unexpected system error occurred. Explanation: A system error occurred. One possible reason for this error is that the database manager is not installed correctly or the environment is not set up correctly. On OS/2, while trying to start the database manager, a very common reason for this error is a corrupted NET.ACC file. The command cannot be processed. The tables and views would not be opened. What is the way to open the dataase? pls help me
In what script is "snap$" created? In what script is the "scott/tiger" schema created?
What are the new features in sql server 2005 when compared to sql server 2000? : sql server DBA
What are the different types of database compression introduced in sql server 2008? : sql server DBA
How would you extract DDL of a table without using a GUI tool?
which background process invoke at the time of upgradation tell me???
how can you enable flashback feature?
what are the types of connection load-balancing?
What is the difference between dropping a database and taking a database offline? : sql server DBA
Explain about your sql server dba experience? : sql server DBA
