HOW TO SHRINK DATA BASE SIZE IN SEQUEL SERVER

                    HOW TO SHRINK DATA BASE SIZE IN SEQUEL SERVER

1. Open OBJECT EXPLORER -> Expand DATABASES -> Select the database you want to shrink.

2. Right click on the database and choose "PROPERTIES".

3. In the "SELECT  A PAGE" window choose "OPTIONS".

4. In the right pane select "RECOVERY MODEL" to "SAMPLE" and hit "OK".

5. Again right click on database you want to shrink, go to "TASKS" select "SHRINK".
     
    At this level you have two options a) Either to shrink whole database
                                                            or
                                                            b) to shrink a database file .mdf or .ldf

6. if you want to shrink a database select "DATABASE", it will open a new window
      hit "OK".

                                                             or

   if you want to shrink a file  select "FILE" it will open a new window
   In the file type select a file "DATA"  or "LOG" and hit "OK".