Explain the way to shrink a Database
Explain the way to shrink a Database?
Expert
This has historically been difficult to shrink any database except tempdb (since it is created fresh each boot time). The two ways commonly used have been:
1. Make sure that you have scripts for all your objects (several tools like SA Companion, dbschema.pl or DB Artisan from Sybperl can create scripts by an existing database), then bcp out your data, drop that database, recreate this smaller and run your scripts, as well as bcp in your data.
2. Utilize a third-party tool such as DataTool's SQL Backtrack, that in essence automates the first process.This technote draws a third possibility which can work in most cases.
Give details why an information gap exists in most organizations?
Explain the function of metadata for the three-layer architecture?
Core Competency: Helps the managers to think towards developing the core competencies with the help of cloud computing. Huge benefits can be reaped out of the cloud computing.
Can we stop and start one session in the concurrent batch?
Write about stage administrator and manager?
Briefly describe the five elements of an Information Systems Architecture and their relationship to data.
Illustrates the cursors in brief?
Specify the types of prompt in the Cognos?
Which of the following method does not support sorting (Exchange, Selection, Insertion, Deletion)?
What is meant by the term Context?
18,76,764
1928369 Asked
3,689
Active Tutors
1412151
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!