Wrox Programmer Forums
|
SQL Server 2000 General discussion of Microsoft SQL Server -- for topics that don't fit in one of the more specific SQL Server forums. version 2000 only. There's a new forum for SQL Server 2005.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the SQL Server 2000 section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old August 20th, 2007, 08:21 AM
Authorized User
 
Join Date: Nov 2005
Posts: 41
Thanks: 6
Thanked 1 Time in 1 Post
Send a message via MSN to RobCarter
Default Backup Problem

Hi

My database mdf file and log file combined equate to 1.6 gig in size. Why is my bak file 89 gig? I have inherited this database so have no idea how the previous user set the backup to run -

Any pointers on either of these points would be great.

Many thanks

Rob
__________________
Rob Carter
 
Old August 20th, 2007, 09:46 AM
Friend of Wrox
 
Join Date: May 2006
Posts: 246
Thanks: 0
Thanked 0 Times in 0 Posts
Default

What is your retention time?
Do you have a lot of backups in the BAK file?


 
Old August 20th, 2007, 10:10 AM
Authorized User
 
Join Date: Nov 2005
Posts: 41
Thanks: 6
Thanked 1 Time in 1 Post
Send a message via MSN to RobCarter
Default

I am unsure about what you mean with reagrd to retention time - if you mean how often the back up runs then it is run daily. To my knowledge only one database is backed up in the bak file, what I guess you are asking is has the previous backup been truncated before the new bak file is created - again, after inheriting the database I am unsure.

Can you help me find out?





Similar Threads
Thread Thread Starter Forum Replies Last Post
Create backup folder & also backup files miracles Excel VBA 0 April 16th, 2007 02:28 AM
Backup scandalous Access 3 February 9th, 2007 01:19 PM
Backup help slesicki SQL Server 2005 2 December 28th, 2006 05:11 AM
BAckUp sachindhillan Oracle 2 September 28th, 2003 07:32 AM
BackUp problem acko SQL Server 2000 3 July 7th, 2003 08:16 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.