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


Please Help Members By Posting Answers For Below Questions

How raid can influence database performance?

1116


How to convert numeric expression data types using the cast() function?

1146


What is standby servers? Explain types of standby servers.

1078


When should you use an instead of trigger?

1050


What are the source of constraints?

1008


What is sql or structured query language?

1226


Explain system functions or built-in functions? What are different types of system functions?

1064


What kind of problems occurs if we do not implement proper locking strategy?

1499


How to provide default values to function parameters?

1256


Why use identity in sql server?

1196


What are the different subsets of sql?

1648


List the ways in which dynamic sql can be executed?

1085


What is in place upgrade in sql server?

1125


How to remove duplicate rows from table except one?

1087


What are the different SQL Server Versions you have worked on?

1077