Explian different types of BACKUPs avaialabe in SQL Server?
Given a particular scenario, how would you go about
choosing a backup plan?
Answer / guest
o A full database backup is a full copy of the database.
o A transaction log backup copies only the transaction log.
o A differential backup copies only the database pages
modified after the last full database backup.
o A file or filegroup restore allows the recovery of just
the portion of a database that was on the failed disk.
Is This Answer Correct ? | 3 Yes | 3 No |
WHEN DOWN TIME WHAT CAN U DO?
what is logical system in sap basis
Give the two types of tables involved in producing a star schema and the type of data theyhold.
What command would you use to encrypt a PL/SQL application?
Explain the difference between $ORACLE_HOME and $ORACLE_BASE.
You have just had to restore from backup and do not have any control files. How would you go about bringing up this database?
i have 10gp file.now i need store in database..but database have only 7gb memory only..how do u store the file ?
now one user in online.now i want drop him..how do u drop him?
what r the types of backup?
How can we know the exact updation date of a particular database?
When setting replication, can you have distributor on sql server 2005, publisher on sql server 2008? : sql server DBA
how can you find out if a table can be redefined?