Differential backups and SQL Server 2000
Describe the difference between differential backups and SQL Server 2000 complete?
Expert
A total backup creates a copy of the whole database. A differential backup creates a copy of the changes which have been made to the database as last complete backup. A complete backup must be completed before the first differential backup. Since the differential backups are much faster and they can be taken more often and chance of data loss is reduced. Complete backups take longer however are slightly simpler to employ for recovery.
Explain briefly the term data mart?
What is the repository?
Determine the stand-alone procedures?
Give a brief introduction of the term BUS Schema?
What is OLAP? Briefly define it.
Specify the types of prompt in the Cognos?
Explain the performance of SQL Server Reporting Services.
What do you understand by the term locking in DBMS?
Briefly describe the reason of synchronization function offered in Analysis Services 2005 ?
Explain different domain which is there in BO?
18,76,764
1952376 Asked
3,689
Active Tutors
1418454
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!