Hi..here i would like to know the Backup and Restore models?
Answers were Sorted based on User's Feedback
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 |
Answer / laxman
that may recovery models:
simple
bulk-loged
full
Is This Answer Correct ? | 0 Yes | 0 No |
What are system databases into sql server (2005/2008)?
If no size is defined while creating the database, what size will the database have?
What is sql server english query?
How do I perform an unattended install of sql server 2000?
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. How to fetch all the duplicate records from the table. 2. How to fetch the second highest salary from the table.
Explain filtered indexes benefits?
You want to implement the many-to-many relationship while designing tables. How would you do it?
What is an indexed view?
How many types of cursor type are there?
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?