Interested to Buy Any Domain ? << Click Here >> for more details...
Accidentally i deleted my table. How can i get that table?
- 4 Answers
- 9353 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
Explain what is cte (common table expression)?
What is nonclustered index on computed columns?
Explain “@@rowcount” and “@@error” in sql server?
How much memory that we are using in Logshipping Concept?
What is b tree index?
What are the new features are introduced in sql server 2012 reporting services?
What are types of scd? : sql server analysis services, ssas
Do you know how to store and query spatial data?
Mention the 3 ways to get a count of the number of records in a table.
what’s the difference between Covering Indexes and Clustered Indexes ? how to use clustered index small ?
Any one plz send me SQL Server Developer/DBA resume for 4 years experience
How to download and install microsoft .net framework version 2.0?
1.what are diff types of joins , and explain diff between cross join and full outer join 2.diff types of views 3. Diff types of index 4. What is diff b/w stores procedure and function procedure 5.diff between double and int in SQL 6.diff between char and varchar in SQL. 7.Oracle or SQL whice you will preferred and why.
What is efficiency data?
Can we take the full database backup in log shipping?
