Web Wiz Support and Community Forums : wwf SQL database size https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Mon, 06 Apr 2026 13:41:26 +0000 Fri, 21 Sep 2007 23:06:58 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=24469 <![CDATA[Web Wiz Support and Community Forums]]> https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ <![CDATA[wwf SQL database size : Where ever you want it stored...normally...]]> https://forums.webwiz.net/wwf-sql-database-size_topic24469_post127915.html#127915 Author: Nick-V
Subject: 24469
Posted: 21 September 2007 at 11:06pm

Where ever you want it stored...normally under C:\Program Files\Microsoft SQL Server\MSSQL\BACKUP and optionally a sub folder for each database.
 
Setting to Full does not actually make the backups occur. You need to schedule the backups using jobs and maintenance facilities (can't remember sql 2000) but read the help.


Edited by Nick-V - 21 September 2007 at 11:07pm]]> Fri, 21 Sep 2007 23:06:58 +0000 https://forums.webwiz.net/wwf-sql-database-size_topic24469_post127915.html#127915 <![CDATA[wwf SQL database size : Hello Nick,this sounds good......]]> https://forums.webwiz.net/wwf-sql-database-size_topic24469_post127913.html#127913 Author: iSec
Subject: 24469
Posted: 21 September 2007 at 10:28pm

Hello Nick,

this sounds good... I see the full recover model can be done from the db properties as shown below, but where would the backup be stored on the server?



]]> Fri, 21 Sep 2007 22:28:30 +0000 https://forums.webwiz.net/wwf-sql-database-size_topic24469_post127913.html#127913 <![CDATA[wwf SQL database size : You might want to try out a full...]]> https://forums.webwiz.net/wwf-sql-database-size_topic24469_post127897.html#127897 Author: Nick-V
Subject: 24469
Posted: 21 September 2007 at 8:48am

You might want to try out a full recovery model (I use it). Take a full backup once a week and take transaction log backups every day (or every hour if you wish). I think this is what you were aiming for. With this model you can restore to any point in time. It will use the the full backup and add the transactions up to a specific minute so you must keep the files that make up a set.
 
An alternative is a simple model with a full backup of the database every day (or whatever). Of course with this you could lose up to 99% of a day's work - you can only restore to the last available backup. You must keep one file only.
 
You can still do it using differentials but remember they hold all changes since the last full backup and not since the last differential backup (like the transactions option). Therefore you only need the last full and one differential (not all transaction files). Because they are bigger files they take longer than transaction backups. You must keep the full backup and latest differential.
 
It really depends how critical your use is, how frequently changes are made, if you wish to protect against database failure or user error too (deleting whole threads!). Option 1 is good but all sorts of other things can screw up your server too so think about these too.
 
Always keep more than one full backup generation in case a backup set fails! Keep backups off-site...fire and thieves, etc can kill your database AND your backups!
 
Good luck.


Edited by Nick-V - 21 September 2007 at 8:53am]]> Fri, 21 Sep 2007 08:48:24 +0000 https://forums.webwiz.net/wwf-sql-database-size_topic24469_post127897.html#127897 <![CDATA[wwf SQL database size : Hello Nick, that was a bit confusing......]]> https://forums.webwiz.net/wwf-sql-database-size_topic24469_post127884.html#127884 Author: iSec
Subject: 24469
Posted: 21 September 2007 at 2:00am

Hello Nick,

that was a bit confusing... I guess I should just stick to the daily FULL backup...unless there is a better way of doing it.
]]> Fri, 21 Sep 2007 02:00:04 +0000 https://forums.webwiz.net/wwf-sql-database-size_topic24469_post127884.html#127884 <![CDATA[wwf SQL database size : If you are using differential...]]> https://forums.webwiz.net/wwf-sql-database-size_topic24469_post127883.html#127883 Author: Nick-V
Subject: 24469
Posted: 21 September 2007 at 1:32am

If you are using differential backups I wonder when was the last full backup was done. Is this helpful:
 
The size of a differential backup depends on the amount of data that has changed since the base. Generally, the older a base is, the larger a new differential backup will be. A specific differential backup captures the state of changed extents at that time that backup is created. If you create a series of differential backups, a frequently updated extent is likely to contain different data in each differential. As the differential backups increase in size, restoring a differential backup can significantly increase the time that is required to restore a database. Therefore, we recommend that you take a new full backup at set intervals to establish a new differential base for the data. For example, you might take a weekly full backup of the whole database (that is, a full database backup) followed by a regular series of differential database backups during the week.
]]> Fri, 21 Sep 2007 01:32:59 +0000 https://forums.webwiz.net/wwf-sql-database-size_topic24469_post127883.html#127883 <![CDATA[wwf SQL database size : I use the Enterprise Manager tool...]]> https://forums.webwiz.net/wwf-sql-database-size_topic24469_post127882.html#127882 Author: iSec
Subject: 24469
Posted: 21 September 2007 at 1:22am

I use the Enterprise Manager tool to schedule the backup... it's the simplest way.
The size continues to grow when the differential backup is done every couple of hours...
now i changed it from hourly back to daily, and complete backup instead of differential. The first back will be done tonight so let's see how it will be.
]]> Fri, 21 Sep 2007 01:22:16 +0000 https://forums.webwiz.net/wwf-sql-database-size_topic24469_post127882.html#127882 <![CDATA[wwf SQL database size : What recovery model are you using...]]> https://forums.webwiz.net/wwf-sql-database-size_topic24469_post127881.html#127881 Author: Nick-V
Subject: 24469
Posted: 21 September 2007 at 1:13am

What recovery model are you using and is it the best choice for you? Look at the sizes of the data and transaction log backups. How often do you do a full backup reset the transaction logs....or are they just continuing to grow?

Edited by Nick-V - 21 September 2007 at 1:15am]]> Fri, 21 Sep 2007 01:13:58 +0000 https://forums.webwiz.net/wwf-sql-database-size_topic24469_post127881.html#127881 <![CDATA[wwf SQL database size : Well,I just went in and looked...]]> https://forums.webwiz.net/wwf-sql-database-size_topic24469_post127880.html#127880 Author: iSec
Subject: 24469
Posted: 21 September 2007 at 1:05am

Well,

I just went in and looked up the db properties and discovered that the db size is only around 47 MB. But the backup that is done daily is 312 MB, isn;t that weird? The backup is done daily every couple of hours...
]]> Fri, 21 Sep 2007 01:05:21 +0000 https://forums.webwiz.net/wwf-sql-database-size_topic24469_post127880.html#127880 <![CDATA[wwf SQL database size : Do a shrink database and see what...]]> https://forums.webwiz.net/wwf-sql-database-size_topic24469_post127879.html#127879 Author: Nick-V
Subject: 24469
Posted: 21 September 2007 at 1:00am

Do a shrink database and see what happens. But remember to reindex. If you happened to add and then delete a lot of data this is exactly what you will get.



Edited by Nick-V - 21 September 2007 at 1:01am]]> Fri, 21 Sep 2007 01:00:25 +0000 https://forums.webwiz.net/wwf-sql-database-size_topic24469_post127879.html#127879 <![CDATA[wwf SQL database size : right that&#039;s what i mean......]]> https://forums.webwiz.net/wwf-sql-database-size_topic24469_post127878.html#127878 Author: iSec
Subject: 24469
Posted: 21 September 2007 at 12:56am

right that's what i mean... in 2 months the db size increased from 45 mb to 312 Ouch
]]> Fri, 21 Sep 2007 00:56:39 +0000 https://forums.webwiz.net/wwf-sql-database-size_topic24469_post127878.html#127878