Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / srinivas
In sqlserver 8 types of backups
1. full backup
2. differential backup
3. transaction log backup
4. tail log backup
5. mirror backup
6. file and file group backup
7. copy only backup
8. partial backup
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What is the importance of a recovery model? : sql server DBA
what is the use of ocr?
what is grd?
What is the default port no on which sql server listens? : sql server DBA
You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?
How would you best determine why your MVIEW couldn't FAST REFRESH?
Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.
how can you implement fine-grained auditing?
Oracle client is not able to connect to Oracle server although tnsnames.ora file has valid enteries. Oracle error message is “ cannot resolve net service name”. Mention any three reasons.
What is the difference between the 2 operating modes of database mirroring? : sql server DBA
How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?
In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?
In what script is "snap$" created? In what script is the "scott/tiger" schema created?
Claims and Drains are the locks used to control the concurrency between SQL processes and utilities. Referring to the above statement, what is the maximum number of concurrent Claimers for a Subsystem? Choice 1 32 Choice 2 64 Choice 3 128 Choice 4 256 Choice 5 No limit
How to start SQL Server in minimal configuration mode?
