Plz tell about backup&recovery?
Answers were Sorted based on User's Feedback
Answer / kanan
Mirrored backups
SQL Server 2005 lets you create mirrored backups. A mirrored
backup allows you to create two or four identical copies of
the backup files in case one of the sets is damaged.
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / senthilsjc
Hai hari...
Thnaks for ur answere..but
Don't post answer what u read in material
b'coz all are know backup type & recovery type
if u post answer its wanna most use full others
that's y i am asking..
this is my humble request..
don't mind..
carry onn..
Is This Answer Correct ? | 1 Yes | 3 No |
Answer / hari
Back up is 3 types
Full backup
Differential backup
Transcational log backup
Recovery
simple recovery
full recovery
Bulk recovery
Is This Answer Correct ? | 0 Yes | 3 No |
List out the differences between the clustered index and non-clustered index in sql server?
What are filegroups in sql server?
what is database replication? : Sql server database administration
What is the difference between having clause and where clause in sql server?
What are different types of views?
What is index?
What are the transaction properties?
If a table does not have a unique index, can a cursor be opened on it?
you have couple of stored procedures that depend on a table you dropped the table and recreated it what do you have to do to reestablish those stored procedure dependencies?
What are the different type of replication in sql server?
What are the types of user defined functions in sql server?
How to get a list all databases on the sql server?