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 |
How to optimize stored procedures in sql server?
What is dirty read?
What is a NOLOCK?
In performance wise distinct is good or group by is good? eg:select name from emp group by name; select distinct name from emp;
Why I have to use stored procedures?
How to create user messages with print statements in ms sql server?
What is the native system stored procedure to execute a command against all databases?
How to create a login account in ms sql server to access the database engine using "create login" statements?
Explain features of analysis services?
How do I save a stored procedure in sql server?
what is a transaction? : Sql server database administration
An employee table, with the columns id, name, sal and dob. Query to select emp names of all highest salaries(there are 4-5 people having the same salary which happens to be the highest).
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)