how to make database 1GB to 700MB ...

hi.
my database is much bic 1GB... so how to make 700MB.
because cd is 700MB.. I can't put my database to cd..
Can you help me? Do you Know Reduce Database..
Hi
It seems you need to take a backup of your database to CD. The best option
is
1. backup the database
2. Zip the file (File will come down to <500MB)
3. copy the file to CD
-
Thanks
Hari
MCDBA
"chobo sql user" <anonymous@.discussions.microsoft.com> wrote in message
news:70468D63-8083-444C-B86D-BFE51E80222C@.microsoft.com...
> hi.
> my database is much bic 1GB... so how to make 700MB.
> because cd is 700MB.. I can't put my database to cd..
> Can you help me? Do you Know Reduce Database..
|||Hi
One option is to WINZIP or WINRAR it.
"chobo sql user" <anonymous@.discussions.microsoft.com> wrote in message
news:70468D63-8083-444C-B86D-BFE51E80222C@.microsoft.com...
> hi.
> my database is much bic 1GB... so how to make 700MB.
> because cd is 700MB.. I can't put my database to cd..
> Can you help me? Do you Know Reduce Database..
|||Chobo,
if you're lucky, then some of your database file is empty, in which case you
can shrink it. Have a look at DBCC SHRINKDATABASE and DBCC SHRINKFILE in BOL
for the syntax. Alternatively, don't forget that database files/backups are
not compressed, so backing up the databse and zipping it up usually results
in a massive space saving.
HTH,
Paul Ibison
|||Usual step is to create the backup file (~ 1 Gig), then compress it.
Fastest compressor would be lzop, but at a lower compression rate (~ 40%).
Winzip and Winrar would be good choices if you need better compression
ratio. You would then need > 1 Gig of space to work with the backup file
and also the compressed file. Likewise, when you want to restore the
database, you need enough space to store the compressed file, and the backup
file of 1 Gig.
Alternatively, you could use utilities like MiniSQLBackup, SQLLiteSpeed or
SQLZip. What these utilies do is compress the backup file on the fly, so
that you only need enough space to store the compressed file, and you need
less time do create the backup compared to manually compressing the file.
Disadvantage is that these tools are not free, and you need to use the tool
to restore the backup.
Also, as Paul mentioned, you could try shrinking the database before backing
it up, but doing that has its disadvantages too if your database will
eventually grows to that size again e.g. defragmentation, performance hit
when data files grow.
Alternatively, you could take the 1 Gig file, whether you detach the
database or create a backup, and use file splitting utilies to split the
file into 2 parts. You can download a free file splitting utility from my
site.
Peter Yeoh
http://www.yohz.com
Need smaller backups? Try MiniSQLBackup
"chobo sql user" <anonymous@.discussions.microsoft.com> wrote in message
news:70468D63-8083-444C-B86D-BFE51E80222C@.microsoft.com...
> hi.
> my database is much bic 1GB... so how to make 700MB.
> because cd is 700MB.. I can't put my database to cd..
> Can you help me? Do you Know Reduce Database..