469,343 Members | 5,686 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,343 developers. It's quick & easy.

How do I make a backup device file smaller ?

Hi
I have a backup device file ... ".bck" whick has grown pretty large.
Is there any way I can reduce its size ?

Thanks

David Greenberg
Apr 9 '08 #1
4 3357
Are you appending multiple backups to the same backup file? In that case,
the file will grow indefinitely because you can't remove individual backups.
You'll need to periodically rename the backup file to start anew.

One approach is to append a backup date/time to the file name so that you
separate backup files and keep a rolling number of the latest copies
according to your recovery requirements. A database backup maintenance plan
can facilitate this or you can roll your own.

--
Hope this helps.

Dan Guzman
SQL Server MVP
http://weblogs.sqlteam.com/dang/

"David Greenberg" <da*****@iba.org.ilwrote in message
news:ft**********@news4.netvision.net.il...
Hi
I have a backup device file ... ".bck" whick has grown pretty large.
Is there any way I can reduce its size ?

Thanks

David Greenberg
Apr 9 '08 #2
aCe
On Apr 9, 3:56 pm, David Greenberg <davi...@iba.org.ilwrote:
Hi
I have a backup device file ... ".bck" whick has grown pretty large.
Is there any way I can reduce its size ?

Thanks

David Greenberg
You can zip it. :D

Hope this short answer helps.

aCe
http://www.acerahmat.com
Apr 10 '08 #3
On Apr 9, 10:56*am, David Greenberg <davi...@iba.org.ilwrote:
Hi
I have a backup device file ... * ".bck" whick has grown pretty large.
Is there any way I can reduce its size ?

Thanks

David Greenberg
Maybe you can try to truncate you log data with a command like this:
BACKUP LOG dbname WITH TRUNCATE_ONLY

Bye
Apr 11 '08 #4
Davide Benfenati (da**************@gmail.com) writes:
On Apr 9, 10:56*am, David Greenberg <davi...@iba.org.ilwrote:
>I have a backup device file ... * ".bck" whick has grown pretty large.
Is there any way I can reduce its size ?

Maybe you can try to truncate you log data with a command like this:
BACKUP LOG dbname WITH TRUNCATE_ONLY
No, that is not even close. BACKUP LOG WITH TRUNCATE_ONLY is a command
that you should only use in an emergency as it breaks the log chain
if you are running in full or bulk-logged recovery. And WITH TRUNCATE_ONLY
does not make anything smaller. Although you may be able to shrink
the log file after the operation.

But Davide asked for how to reduce the size of a backup file. The only
way to do that is to delete it or overwrite it with WITH INIT.
--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx
Apr 11 '08 #5

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

5 posts views Thread by TThai | last post: by
2 posts views Thread by nt | last post: by
3 posts views Thread by butatista | last post: by
4 posts views Thread by uthuras | last post: by
reply views Thread by Massimiliano Campagnoli | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by suresh191 | last post: by
1 post views Thread by Marylou17 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.