Interested to Buy Any Domain ? << Click Here >> for more details...
Accidentally i deleted my table. How can i get that table?
- 4 Answers
- 9466 Views
- I also Faced
- E-Mail Answers
Answer Posted / adhi
IN MS SQL SERVER 2005.
1.Take Tail Log backup
2.Restore Full backup
3.Restore Diff (If u have)or Log backup in sequence order
4.Restore Tail Log backup
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
What are the tables in sql?
What are the system database in sql server 2008?
Explain what is use of dbcc commands?
Comment,Datatypes are unlimited
hi, the following are the outputs of sp_spaceused and sp_tempdbspace sp_spaceused ------------ database size unallocated size tempdb 77752.95 MB 28026.99 MB sp_tempdbspace ------------- database size spaceused tempdb 77752.945312 1.007812 the unused space in sp_spaceused is nearly 28 Gb and in sp_tempdbspace is nearly 76 Gb cany any one explain about this output and why its giving different results.
What is the report model project?
How to locate and take substrings with charindex() and substring() functions?
How to change the data type of an existing column with "alter table" statements in ms sql server?
I have all the primary data files, secondary data files as well as logs. Now, tell me can I still restore the database without having a full backup? : sql server database administration
What are the differences between user defined functions and stored procedures?
What is 'write-ahead log' in sql server 2000 ?
Define normalisation?
Why is replication required on the sql server?
What is index in an assignment?
When columns are added to existing tables, what do they initially contain?
