Existing Backup File Kept Growing In Size.

Jan 3, 2007

I'm having a problem. When I use the SQL query to make a backup of the database, it worked fine. But everytime I use it, the backed-up file's size kept growing in size. Say I have the file, test.bak whose filesize is 450 MB then I run a new backup to overwrite the existing test.bak file, it just end up as 900 MB. If I run it again, it become 1350 MB and so on.

Is there a way to prevent that from happening?

View 1 Replies


ADVERTISEMENT

Backup File Size Is Growing....!

Oct 15, 2007

Dear All,

I am using Append to media backup option in 2000 Version. The size of backup is growing. how can I best create the maintenace plan to clear the history or clear the old files in BACKUP (.bak) file but still be able to restore point in time from same physical file. I

Is there any side effect of doing that.

Thanks,

View 10 Replies View Related

SQL2K: MDF File Size Growing Fast

Jul 30, 2007

Hello,

I have got another annoying problem. The MDF file size on one of the machines is growing really fast. We zip the mdf/ldf files every day from all the machines in the dataentry dept. On this particular machine, the mdf file size is growing by about 1GB per day. However, when the file is zipped, the zipped file size comes closer to the zipped files from the other machines.

I have tried doing this:

http://www.sql-server-performance.com/lost_data_sql_server.asp

on it as well, but didn't solve my problem.

Any ideas as to what it might be? and how to solve this problem?

Thanks in Advance.
J!

View 11 Replies View Related

SQL 2012 :: MDF File Size Is Growing Fast?

Jul 28, 2014

I have a Problem like the Following ..

On 24th my Mdf size was 10GB,when i checked now the Mdf size was increased suddenly to 30GB.

solution to decrease the Size and as well as where can i check the reasons behind that..

View 2 Replies View Related

Recovery :: Log File Size Growing Too Big Need To Truncate In Server With AlwaysOn Feature

May 10, 2015

I want to truncate my sharepoint config database and WSS_Logging database logs the size of sharepoint_config database is growing at a pace of ~10GB every week. I have scheduled a weekly full backup. Current .ldf file size is 113GB.

I am using SQL server 2012 with Always On High Availability feature. I am not able to set the recovery mode from Full to Simple as it gives me message that mirroring is running on both server.

In my case to reduce the log file what I need to do.

View 3 Replies View Related

SQL 2012 :: Existing Replica MDF File Size Increased In Size Than New Replica Install

Apr 14, 2015

Here are my scenarios:

We have an application with replicated environment setup on sql server 2012 . Users will have a replica on their machines and they will replicate to the master database. It has 3 subscriptions subscribed to the publications on the master db.

1) We set up a replica(which uses sql server 2012) on a machine with no sql server on it. After the initial synchronization(used replmerge tool) the mdf file has grown to 33gigs and ldf has grown to 41 gigs. I went to sql server management studion . Right click and checked the properties of the local database. over all size is around 84 gb with little empty free space available.

2) We set up a replica(which uses sql server 2012) on a machine with sql server 2008 on it. After the initial synchronization(used replmerge tool) the mdf file has grown to 49 gigs and ldf has grown to 41 gigs. I went to sql server management studio , Right click and checked the properties of the local database. over all size is around 90 gb with 16 gb free space available.

3) We set up a replica(which uses sql server 2012) on a machine with sql server 2012 on it. We have dropped the local database and recreated the local db and did the initial synchronization using replmerge tool. The mdf file has grown to 49 gigs and ldf has grown to 41 gigs. I went to sql server management studio , Right click and checked the properties of the local database. over all size is around 90 gb with 16 gb free space available.

Why it is allocating the space differently? This is effecting our initial replica set up times.

View 0 Replies View Related

Log Backup File Size Not Matching Log File Size

Apr 15, 2008

I have a log file that is approximately 50 GIG. I backed up just the log and the file size of the .bak is 192 GIG . Why is this? Shouldn't it be closer to the 50 GIG.

Normally I wouldn't let log grow this much. But we are in process of getting new server up and running and don't have backups going yet. They are working on getting that up and running this week.

So I did a log backup to give me back some log space for now but was concerned when I saw the size of the .bak file.

When I view media contents of the backup device it shows one tranaction log back up and size of 192 GIG.

What is up with this. I know in SQL 2000 the log backup files where never this big. they were about the size of the log itself.

Any ideas?

Stacy

View 8 Replies View Related

SQL 2012 :: Compress Existing Backup File?

Jan 22, 2015

I have a SQL 2012 enterprise server, and I'm using Commvault as my backups. So commvault can restore a .bak file to my server, but it cannot use sql compression on the file apparently. So what would be a 150GB .bak backup file is now 600GB. I have to manually upload these files to an auditing firm on an sftp server and the transfer times are now huge.

Is there a way to use something in sql to compress this already existing .bak file down?

View 5 Replies View Related

Size Of Backup File

Feb 4, 2004

Hi all,

How can I see what is exact size of SQL server backup file while backup is running. The process is running for more than 2 hours, it is chewing up disk space (it already took about 20G), but the size of backup file is still showing as 0.

Thanks in advance

View 7 Replies View Related

SIZE OF Backup File

Dec 12, 2007

what will be size of backup file(FULL) for 1TB database. Just wanna make sure backup is done right.I did a full backup of 1TB database and backup file came like 507GB. I am using GUI for backup.But it completed 100% but didn't give me the screen'The backup is completed successfully' .it says executing---0%

View 5 Replies View Related

Database Backup File Size

Oct 27, 2004

How does backup database command works? I don't see size of database backup file increasing while backup is in progress OR is it locked till the backup is finished.

Thanks.

View 1 Replies View Related

Backup File Size Problem

Apr 18, 2008

I have installed the sql server management studio express for my express edition of studio 2005 for backup purposes.
I need to automate backing up my database.
I created a backup script and have successfully got sched tasks to backup each night. the problem is it is not overwriting the previous data. My first backup was 1 gig, the next night the file was 2 gig, the next it was 3 and so on.
This is not due to that much data being added to the db.
When I go to restore, I have the option to restore any of the 3 backups. I would like my backup to be a single image of the database at the last backup time. How can I do this?

View 4 Replies View Related

How To Compute For A Backup File Size

Jan 9, 2008

hello guys,

Please bare with my english.

Is there a way to compute for the backup file size of the database.
Example.

DatabaseName
TEST_DB

*in MB
DataSize DataSize_Used DataSize_UnUsed
150.00 81.00 70.00

LogSize LogSize_Used LogSize_UnUsed
30.00 1.00 29.00


When I run a backup for TEST_DB ,
*base on this figure - can we compute the the estimated backup file size for TEST_DB?

View 2 Replies View Related

Transaction Log Size Growing Very Large

Oct 10, 2006

hi all,


my tlogs at the subscriber are growing very large

irregardless of my recovery mode. any help

using snapshot-push replication

thanks,

joey



View 8 Replies View Related

SQL 2012 :: Database Size From Backup File

Apr 21, 2014

finding the database size from the backup file.I have SQL 2012 backup file, is there any way to find the estimated database size from the backup.I tried restoring , i got an error saying " no space need additional xxx bytes " ...does this error gives the exact space needed to restore ?

One more question....one of the backup file size is 7.2 GB, when i try to restore it ....it throws error saying it needs 292GB extra space while only 100 Gb is available. How come 392 Gb sized database becomes 7.2 Gb .bak file ?

View 5 Replies View Related

Database Size Not Growing Despite Unlimited Growth

Mar 11, 2004

Hi All,

Database size is not increasing automatically ,however I have set it as unlimited growth. Any idea about this ?

thanks for in advance,


Sedat Duztas

Probil

View 1 Replies View Related

Does AppAssure Backup Schedule Affect Log File Size

Jul 22, 2015

In a recent attempt to keep the size of my transaction log files down I altered the schedule of my SQL Server log backups from running every 15 minutes from 07:00 to 19:00 to run every 15 minutes.My company also uses a Dell AppAssure application to also take backups. The backups are of the entire drives so I don't this will affect the size of my SQL log files but I did notice that AppAssure has a tick box to truncate the SQL logs so it made me wonder that it could affect the size of my log file. The Appassure backups currently run every 15 minutes from 07:00 to 19:00. I'm wondering if I would be able to maintain my log files at a smaller size if I ran this every 15 minutes from 07:00 to 07:00.

View 2 Replies View Related

SQL Server 2008 :: Finding Backup File Size In Advance?

Mar 8, 2015

My backups are failing sometimes.My db size is around 400 GB and we are taking backup to the remote server. Free size available on the disk is showing 600 GB but my database full backup run more than 10 hrs and failed. The failure reason is there is not enough space on the disk.

What could be the possible failure reasons? It has more than the the database size on the backup server but why it is showed that msg on the job failures. I noticed same thing occurred couple of times in the past.

Is there any way to find how much the backup file will be generate before we run the backup job?

i.e. If we run the full backup of test1 database now, it will generate ....bak file for that test1 db

currently we are using maintenance plan and with compression (2008R2) and the database has TDE enabled

View 3 Replies View Related

SQL 2005 Resize Initial Log Size: MODIFY FILE Failed. Specified Size Is Less Than Current Size.

Sep 4, 2007


I am trying to resize a database initial log file from 500M to 2M. I€™m using€?

ALTER DATABASE <DBNAME> MODIFY FILE ( NAME = <DBLOGFILENAME, SIZE = 2 ) "



And I'm getting "MODIFY FILE failed. Specified size is less than current size." I tried going into the database properties and setting the log file to 2M, but it doesn€™t keep the changes.



Any help with this process?

View 1 Replies View Related

SQL 2012 :: TempDB Log File Usage Constantly Rising And File Keeps Growing?

Jun 16, 2014

The TEMPDB transaction log file keeps growing.The database server is new and the transaction log was presized to 1 GB on installation. After installing a number of databases, the log file grew over a day to 38GB. Issuing a manual checkpoint was the only way to free some space to allow it to be shrunk back to a usable size. The usage of the file is still going up.

I am struggling to find what process is causing the log to be used so heavily. Looking at the log reuse wait desc for tempdb returns "Nothing" and tempdb itself isn't being used very much or growing in size.

View 9 Replies View Related

Why Does My .ldf File Keep Growing?

Aug 7, 2007

Why does a log (.ldf) file keep growing and growing and growing? Is this related to the fact that the scheduled Maintenance keeps failing due to exclusive access problems?

SQL Server 2000 Std.

Thanks!

View 7 Replies View Related

Log File Sizes Are Growing Like Anything.

Nov 8, 2000

Hi,
my log files are growing like anything. One of my log file size is 20GB.
How i have to reduce the log file size.
If i run DBCC command is it come backs...
Pls tell me the way how i have to find the free space and reduce logsizes.
After taking backups also my log file sizes are not reducing.

Thanks!
Kavira

View 2 Replies View Related

Growing Tran Log File

May 16, 2006

I have a database of 22 gb in sql 2000, my database option is set to full recovery mode, the problem i'm having is the tran log is growing too fast, this morning it was 24 gb, more than the database size. Can anyone help how I can keep it in a managable size?

Thanks in advance!!

View 2 Replies View Related

Index File Growing Big

Nov 15, 2004

Hi all

I have a DB with 1 data file, 1 log file and 1 index file.
data file is 3 GB but index file is 12 GB.
Index file is growing big day by day.
This cause performance of DB down.
What should I do to prevent index file become bigger and size of index file smaller?

Thanks in advanced
Thi Nguyen

View 5 Replies View Related

Log File Growing Uncontrollably?

Nov 8, 2012

My log file was 2x the size of my actual Database which is obviously too large on a DEV box. I know that my data can be easily recovered so I actually do not even want/need a log file.

After doing some investigation I found that I should turn my database into "Simple Recovery Mode" and after this I used a few scripts to truncate my log file. Things at this point looked great!

Unfortunately my log File is still growing even with this 'simple recovery mode'. So how do I stop this craziness from occurring?

I even unchecked the box 'allow autogrowth' on the database! However, I eventually get errors when creating records in the system because it complains about running out of room in the log file.

Code:

The transaction log for database 'ReportingDB' is full. To find out why space in the log cannot be reused, see the log_reuse_wait_desc column in sys.databases

View 8 Replies View Related

Sql Text File Growing !very Urgent!

Jun 28, 2000

there is a sql.txt file in my c: which grows very fast when i start sqlagent...it keeps occupying the free space in the drive..can anyone please help?

View 4 Replies View Related

Log File Growing In Amazing Manner

Sep 28, 2004

I started my database in last week to user with transfer data from Sybase to sql 2000 server. Intitally log file size was few MB near to 20 MB for each co’s, within 8 days it has reached upto 300 MB still datafile size in few MB , approximately 40MB for each co’s, why log file growing in such manger, how I can manage it?

Thanking You

R.Mall

View 2 Replies View Related

Transaction Log File 210GB And Growing

Oct 12, 2007

I am running Microsoft SQL 2005 Express.

The transaction log of the main database has gotten huge and I just noticed it because the disk is nearly out of free disk space.

The database data file is 46MB and the transaction log is 210GB. This happended because autogrowth was on, and no limit was set I suppose.

So my goal is to knock this thing down to size, and set the max size of the transaction file to like 5GB.

I CANNOT do a backup of the transaction log because I do not have enough free space for such an operation. I tried doing:


DUMP TRANSACTION dbName


No luck, got the following error: Backup or restore requires at least one backup device.

Can I just stop the service and manually DELETE the transaction log file?

Thanks for the help.

View 2 Replies View Related

MSSQL Log File Is 210GB And Growing

Oct 11, 2007



Hello, we are running Microsoft SQL 2005 Express edition (9.0.32).

Recently I just noticed that the database log file of our main database is HUGE. The database data file is only 50MB and the log file is 210GB.

Any idea what is causing this? Seems to be getting bigger with time, in the last 7 days seems to have grown by 100GB. I noticed the following settings under the database:

Autogrowth: By 15 percent, unrestricted growth

Does that seem right? Thanks.

View 13 Replies View Related

LOG File Growing, Similar Issue To A Previous One

May 23, 2007

I have an 19 gig database that somehow has a 100gig log file. The DB MUST BE in full recovery mode, I backup the transaction logs EVERY hour and shrink nightly. but for some reason my logfile WILL NOT SHRINK.





HELP,



I've used both the DBCC Shrinkfile (xxxxxx) and DBCC ShrinkDatabase (xxxxx) and these don't seem to work. I Have No current backup, I have Not capacity for addtional 100 gig worth of backup drive or off-site tape.

View 1 Replies View Related

Why The Log File Is Growing Too Much Upon Running Nested Stored Procedures (MS SQL 2K)

Feb 11, 2006

Hi there,I have a data manipulation process written in a Nested Stored procedurethat have four levels deeper. When I run these individual proceduresindividually they all seems to be fine. Where as when I run them alltogether as Nested proces (calling one in another as sub-procedures) Logfile is growing pretty bad like 25 to 30GB.. and finally getting kickedafter running disk space. This process is running around 3hrs on a SQLserever Standard Box having dual processer and 2gb ram.This procedures have bunch of bulk updates and at least one cursor ineacch procedure that gets looped through.I was wondering if anybody experienced this situation or have any clueas to why is this happening and how to resolve this?I am in a pretty bad shape to deliver this product and in need of urgenthelp.Any ideas would be greatly appreciated..Thanks in advance*** Sent via Developersdex http://www.developersdex.com ***

View 1 Replies View Related

Changing Column Size In Existing Databese?

Jul 20, 2005

I must increase column (filed) size in existing datebase but without usingEnterprise manager....(Becouse we use MSDE on our clients PCs)The Filed is part of primary and foreign key constraints....And every constraint has diferent index number in each database...for example (PK_something_9e382hjl8), and I don't know how to pick thisvalue before "drop constraint" command.....Thank you very much....

View 1 Replies View Related

Sql 2005 Install Error. MODIFY FILE Failed. Specified Size Is Less Than Current Size.

Jun 15, 2006

I installed sql 2005 a while back. Then I recently found out my file system was fat32 (I don't understand why the hardware people did this...) and I had to convert to NTFS. Naturally the sql service no longer worked so I uninstalled inorder to reinstall now I can't reinstall it I keep getting this message



native_error=5039, msg=[Microsoft][SQL Native Client][SQL Server]MODIFY FILE failed. Specified size is less than current size.


I'll try to post the full log in a new post.



View 11 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved