Hi..here i would like to know the Backup and Restore models?

Answers were Sorted based on User's Feedback



Hi..here i would like to know the Backup and Restore models?..

Answer / naren

Back up we have full and defferential
(incremental),transaction log backups


Recovery models full,bulk, simple

Is This Answer Correct ?    6 Yes 0 No

Hi..here i would like to know the Backup and Restore models?..

Answer / laxman

that may recovery models:
simple
bulk-loged
full

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL Server Interview Questions

What are system databases into sql server (2005/2008)?

0 Answers  


If no size is defined while creating the database, what size will the database have?

0 Answers  


What is sql server english query?

0 Answers  


How do I perform an unattended install of sql server 2000?

0 Answers  


I need a query that retrieves info from an Oracle table and a query that retrieves info from a SQL Server table. The info has to be joined together according to Record ID numbers. I have very limited access to the Oracle database but full control of the SQL Server database.How do I join two different queries from two different databases?

1 Answers  






1. How to fetch all the duplicate records from the table. 2. How to fetch the second highest salary from the table.

12 Answers   Accenture,


Explain filtered indexes benefits?

0 Answers  


You want to implement the many-to-many relationship while designing tables. How would you do it?

0 Answers  


What is an indexed view?

0 Answers  


How many types of cursor type are there?

0 Answers  


how to find the particular row in table?(means suppose one table contain 10 rows , in these 10 rows how to find the particular row(example in 10 rows i want 5 row how)?

16 Answers   Accenture, IBM, Marlabs,


What are the new data types are introduced in sql 2000?

0 Answers  


Categories