Q231347 INF: SQL Server Databases Not Supported on Compressed Volumes
Bill Toleman [MS SQL Support]
This posting is provided "AS IS" with no warranties, and confers no rights.
Are you secure? For information about the Strategic Technology Protection
Program and to order your FREE Security Tool Kit, please visit
http://www.microsoft.com/security.
HTH
Jasper Smith
Quote:> Hi All
> Is it possible to compact a sql database and how would i do that?
> Thanks
> Henk
> HTH
> Jasper Smith
> > Hi All
> > Is it possible to compact a sql database and how would i do that?
> > Thanks
> > Henk
Shrinking the database improve the speed? Yes if you consider the speed
gained by the OS having to read less data from the file, the disk drive may
have to return less data and so on...
I'd also recommend rebuilding the indexes. That would rearrange the data in
the database.
Reinaldo Kibel
Microsoft? Corp. - SQL Server Support Engineer
This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use. ? 2002 Microsoft Corporation. All rights
reserved.
Additional support can be obtained at http://support.microsoft.com
Are you secure? For information about the Strategic Technology Protection
Program and to order your FREE Security Tool Kit, please visit
http://www.microsoft.com/security.
--------------------
| Subject: Re: compacting a sql server database
| Date: Sun, 13 Jan 2002 23:22:42 +0100
| Lines: 23
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2600.0000
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000
| Newsgroups: microsoft.public.sqlserver.server
| NNTP-Posting-Host: cc142005-a.kampe1.ov.nl.home.com 213.51.93.20
| Path: cpmsftngxa09!cpmsftngxa07!tkmsftngp01!tkmsftngp02
| Xref: cpmsftngxa09 microsoft.public.sqlserver.server:190331
| X-Tomcat-NG: microsoft.public.sqlserver.server
|
| Does shrinking a database improve the speed ?
| Patrick
|
| > If you mean compact as in try and shrink then have a look
| > at DBCC SHRINKDATABASE and DBCC SHRINKFILE in BOL
| >
| > HTH
| > Jasper Smith
| >
| > > Hi All
| > > Is it possible to compact a sql database and how would i do that?
| > > Thanks
| > > Henk
| > >
| > >
| >
| >
|
|
|
1. Repairing, compacting SQL Server database.
Hello All,
I need to know if somebody have ever done tasks from the Subject line using
ADO, DAO or something else. If you have done this before can you explain me
the best way to do this, or if you know any Internet source to get this
information, please share it with me.
Thanks in advance.
Oksana Romankova.
2. PL/SQL function core dumps when returning un-assigned REF CURSOR variable
3. Compact Oracle Database (Shrink it using SQL Plus)
5. Compact an Access 97 Database with SQL
6. Wintegrate - some answers sought
7. Shrinking SQL Database = MSAccess Compact?
8. Logs switches failing on 8.1.5
11. Compacting/Packing Foxpro 3.0 Database with SQL
12. How to compact a SQL Serverd DataBase?
13. Compact Oracle Database (Shrink it using SQL Plus)