adspace
Accidentally i deleted my table. How can i get that table?
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
How raid can influence database performance?
How to convert numeric expression data types using the cast() function?
What is standby servers? Explain types of standby servers.
When should you use an instead of trigger?
What are the source of constraints?
What is sql or structured query language?
Explain system functions or built-in functions? What are different types of system functions?
What kind of problems occurs if we do not implement proper locking strategy?
How to provide default values to function parameters?
Why use identity in sql server?
What are the different subsets of sql?
List the ways in which dynamic sql can be executed?
What is in place upgrade in sql server?
How to remove duplicate rows from table except one?
What are the different SQL Server Versions you have worked on?