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 a brief introduction of the term universe in SQL? Brief explain the kinds of universes in business objects?
Can we have a report with several data providers?
Provide a brief introduction of the term ‘Data Mart’?
How can you save the Business Objects document that may be accessed by all the users in the workgroup mode?
Write down a short note on the difference between partial specialization and total specialization.
Describe the difference between differential backups and SQL Server 2000 complete?
Describe briefly the term Session and Batches?
What are the drawbacks of the client or server model?
How can we increase the performance within the Data Stage?
Write down the steps for transforming an entity into a table?
18,76,764
1942022 Asked
3,689
Active Tutors
1431900
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!