Hi..here i would like to know the Backup and Restore models?
Answer Posted / 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 |
Post New Answer View All Answers
How to execute a sql statement using mssql_query()?
What will be the maximum number of indexes per table?
What is the syntax to execute the sys.dm_db_missing_index_details?
You want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition?
Do you know exporting and importing utility?
What is rank function?
What is the purpose of indexing?
What is the meaning of lock escalation and why/how to stop this? : sql server database administration
What are sql dirty pages?
Which rendering formats are affected by the pagesize properties?
Do you know the different ddl commands in sql?
What are tables in sql server?
What is isolation levels?
role of sql sever 2005 in database rather than any other database
Write an sql query for deleting duplicate rows?