Delete Data, But File Size Increase

Jul 23, 2005

I encounter one weird problem, I have a database with around 7 GB ...
when I delete a bunch of data from it, it suppose to reduce the
database file size, but weirdly, the file size increase to 8 GB.

Wondering why. Is it suppose to be like that?
Is it the architecture is designed to work like that?

Is there any way for me to reduce the database file size?


Thanks.




Peter CCH

View 2 Replies


ADVERTISEMENT

How To Increase The Data File Size?

Aug 2, 2006

Hi All,
Is it possible to increase the size of data file in SQL Server 2005 Express Edition.
I think the licensed limit is 4096MB whcih i am unable to increase.
Could anyone let if is it possible to increase the data file size and if yes then how?

Thanks,
Varun

View 4 Replies View Related

How To Increase The Data File Size?

Aug 2, 2006

Hi All,

Is it possible to increase the data file size in SQL Server 2005 Express edition?

If yes then how?



Thanks,

Varun

View 1 Replies View Related

Increase Data File Size Of Database Which Is Configured For AlwaysOn?

Jun 7, 2015

Need to confirm if we can add space(increase data file size) for the database which is configured for always on similar to that of mirroring or we need to follow any different procedure.

I have a requirement wherein the datafiles on both the primary and secondary replica got full, if i add space to the primary database will it automatically get added to the secondary replica or not?

View 5 Replies View Related

SQL 2012 :: Increase File Size For A Mirrored Database?

Apr 14, 2015

I need to increase the file size for a mirrored database. I am new to using mirroring for replication. Will increasing the file size break the mirror?

View 2 Replies View Related

Data Warehousing :: How To Increase Partial Cache Size On Lookup Stuck

Apr 20, 2015

After converting from SSIS 2008 to SSIS 2012, I am facing major performance slowdown while loading fact data.When we used 2008 - one file used to take around 2 hours average and now after converting to 2012 - it took 17 hours to load one file. This is the current scenario: We load data into Staging and Select everything from Staging (28 million rows) and use a lookups for each dimension. I believe it is taking very long time due to one Dimension table which has (89 million rows). 

With the lookup, we currently are using partial cache because full cache caused system out of memory.Lookup Transformation Editor - on this lookup - how to increase the size on partial Cache size 64-bit? I am being stuck at 4096 MB and can not increase it. In 2008, I had 200,000 MB partial cache size.

View 2 Replies View Related

How To Increase The DB Size

Mar 5, 2007



hi,

I have one DB in SQL Server 2005.When I was creating it

takes 7813 MB.Now the databse size almost full.Now I want to extend the

DB Size.At my HDD has more space(near by 160 GB).But I don't know how to

extend the Size.More over I had one doubt.Am executing the

exec sp_helpdb command.It shows the Datafile maxsize is Unlimited.I want to

know when the data is full,whether it automatically takes the size from the

HDD or not.

Please Help me out to this Problem.

View 2 Replies View Related

Increase Segment Size

Oct 6, 1998

Hi all,
I encountered error 1105 (Can`t allocate space for object .....) while running a query.
I had dump transaction with no log sucessfully and retry running my query but
still encounter error 1105.

I had checked my database size and following are the info:
Datasize : 2500MB Database size available : 753.39
Log space : 500MB Log space available : 500MB (this was acheive after
after dump trans. twice. it was around 480MB before)

Thus looks like the data segment is full!!!
I expanded the size of the disk device D on which the segment device A is on by 50MB. When I did a sp_helpdevice D, the expansion is reflected.
Next I run sp_extendsegement, A, D.
However running sp_helpsegment A doesn`t show that segment A is expanded.
Please help!!! How do I expand the size of the segment? (without creating a new disk device, is it possible)
Any other way to resolve this problem?

Also how to check if a particular segment is full? eg. the %usage of data/log segment.

Thanks in advance.

View 1 Replies View Related

How Do I Increase Font Size In 6.5?

Jan 27, 1999

I seem to remember that the font size and type can be controlled in SQL Server 6.5 and the process controlls the fonts displayed
throughout the program - Enterprise Manager, Query Tool, etc.

I have just re-installed 6.5 and the fonts are way too small.

Can anyone tell me how this is done?

Thanks.

Jack

View 1 Replies View Related

Increase Database Size

Jan 13, 2005

I have a database that is over 45 GB and need to increase the size, can someone help me with the code to get it done?

Thanks

View 6 Replies View Related

How To Increase Size Of Datatype...

Jul 15, 2006

Dear

I am using varchar data type in my table.it provides maximum 8000 character. but i want more than that.

how to increase size more than 8000

i want to use text datatype but when i type in length it doenst type.it displays only 16.i cant change to another value.

please help me out

Waiting for reply

Regards,
ASIF

View 1 Replies View Related

How Can I Increase The Size Of Varchar

Nov 10, 2006

Dearfriends,
please guide me,
i've a column with varchar(100).
presently, i need that column as varchar(500).



thank you very much.

Vinod

View 4 Replies View Related

HOW TO INCREASE THE COLUMN SIZE

Feb 23, 2007

Dear friends,

i've a column with nvarchar type. how can i increase the size of the column?

Vinod

View 5 Replies View Related

Cant Increase Column Size

Jul 9, 2007

hey

i've a db running sql server express sp2. the db size now is 1.1 gb
i've a table with a varchar column of size 20 . when i try to increase the column size to 50 i get a
timeout exception, and the the cloumn size is unchanged. this table has 2.5 million records

i use sql server management studio express to do the changes

is there a way to increase this timeout or whtever i can do to update this column size?

thx in advance

View 4 Replies View Related

Increase Transaction Log Size

Oct 22, 2007



Hi,

How can I increase the transaction log size of my sql server 2005 database? i can execute the shrink and backup log which can shrink the .ldf file to 1MB. However, since my dts involves a lot of inserts and updates, the my transaction log grows to 700MB in the middle of my dts execution. How can i increase the transaction log size maximum capacity to probably 1.5GB just so it can accommodate my full dts execution?

BTW, this is my commands to shrink the log file:

DBCC SHRINKFILE(<dbname>_log, 1)

BACKUP LOG <dbname> WITH NO_LOG

DBCC SHRINKFILE(<dbname>_log, 1)

cherriesh

View 3 Replies View Related

DB Size Increase From SQL 2000 To 2005

Feb 23, 2008

A few months ago a customer moved from SQL 2000 to SQL 2005. The db wasbacked up on SQL 2000 and restored to SQL 2005. The application using thisdata works on SQL 2005 but takes no advantage of new features. The db onSQL 2000 was about 2.9GB, now on SQL 2005, it is 16.5GB. The db is set toSimple recovery so trx log is only 2mb. The mdf file is 16.5GB, ManagementStudio shows only 5mb free space. There has not been a huge increase intransactions.One of the largest tables has only added 2,000 rows since the move to SQL2005. Yet the data and index size has jumped from about 400mb to 3.5 GB. Iused the 'BigTables.sql' script found at various SQL sites:www.databasejournal.com/img/BigTables.sqlAny ideas why such a large increase?Thanks

View 4 Replies View Related

Query To Change Increase The Size Of A Field

Apr 11, 2007

Hi all,
I tried to change the size of a field of my table using the query :-

ALTER TABLE test MODIFY id varchar(50)

Initially the size of id was set to 30 .Is there any other way or any error in my query.Please help me soon.



joshymraj

View 2 Replies View Related

SQL Search :: How To Increase Server Buffer Size

Nov 6, 2015

I'm trying to query a table where in the data in a cell is 65KB and when i try to do a SELECT I am unable to get the entire data from the cell.

SELECT CAST(Xml_data as XML) from TableName where ID=100
Error Message: Msg 9448, Level 16, State 1, Line 1 XML parsing: line 241, character 76, well formed check: undeclared entity

View 4 Replies View Related

How To Increase Datagroth Size In Sql 2005 Database?

Mar 4, 2008

View 2 Replies View Related

Is It Possible For A Table To Increase Size When Deleting Records?

May 24, 2007

No transaction log involved, only the table itself.



Use sp_spaceused "table_name" to check the space used.



It seems the table size actually increased from the beginning to the middle of deletion, at the end of deletion, its size decreased.



Recovery mode set to be simple, autoshrink turned on.



The tables tested are about 50MB ~ several GB in size, all have the same behavior. The size increased about 5%~10%.



Since the deletion is called from another software, I want to know if it is possible for SQL Server to have this behavior or it is absolutely the 3rd party software's issue



Thanks!

View 2 Replies View Related

SQL Server 2014 :: Sudden Increase In Table Size?

May 5, 2015

I save Table size and recs. no every day. and check it some days.

...
insert into @t
exec sp_msforeachtable 'exec sp_spaceused ''?'''
...

But Today I saw sudden increase size in a table. about 128 MB in a day. (Average Growth fro this table was 4 or 5 MB in a day)This growth was for Only 4222 Records. While for more number of records (about 7000) in yesterday we had only 2 MB GRowth!

This Table information (Now):

sp_spaceused 'Table1'

Result:

name ---Rows --reserved --data

Table1--1021319--460328 KB --283104 KBI Try to gess The reason. I copy These new records to another table.But The result was more strange : on new table the size of these record was : < 1 MB I copied All records to another table . The size was : 148 MB (while this is 283 MB in my real database)

View 4 Replies View Related

Analysis :: Increase Size Of Calculated Column In Cube

Aug 21, 2015

Where we have increase the size of the calculated column in cube..whether in attribute  or some where else...

View 4 Replies View Related

Reporting Services :: How To Increase Chart Size In SSRS

May 25, 2015

How to increase the chart report size to avoid the mismatch of output data like below....

View 2 Replies View Related

How To Increase Query Buffer Size In The Crash Dump?

Jul 9, 2007

Hi,

SQLSERVER 2005 keeps throwing assertation error and generating crashdumps.

I want to isolate the cause, however, the query is too long (>2kb) to fit in a crash log.



Is it possible to increase the size allocated to showing the query in the crash dump, or get the full text of that query causing the crash?

View 1 Replies View Related

(URgert)Is There A Way I Can Increase The Size Of The Drop Down List In My Report Viewer

Jan 18, 2008



Hi,

I have a report on my report server... and it has set for multivalue parameter... but since the particular client has only one plan so they wont have the select all function... but the size of the ddl is so squished that we cannot see the Plan name at all...

So can someone pls help me as to how can i increase it..

Regards
Karen

View 5 Replies View Related

Urgent Need For Problem Of Increase In Database Size For Ntext Type Fields

Jan 22, 2006

I had several databases under sqlserver ce 2.0 (in my Pocket PC) which contained ntext fields. The size of the databases varies from 50,000 to 700,000 records. The size of an ntext field is from 4 bytes to 2 megabytes.

When I recreated my databases under sql server 2005 mobile on my desktop using VS2005 (see my post just under this one), I saw a big difference between the old and new database sizes. This problem was mentioned in one of the posts in this forum and the reply was to replace ntext data with ncharvar type.

Since most of my data was longer than 4000 bytes (which is the limit for nvarchar type), I couldn't use this suggestion. Instead, I changed my ntext type to image type and used a GetByte conversion.

No change! The size of the new database is still 50 % larger than the original. Since the difference is around 300 MB, this is an unacceptable thing.

Now, I either wait from somebody to suggest a new solution (apart from keeping the ntext data in a separate binary file and keep index of the records of this file in the records of sql database) or, most preferably, have

Microsoft solve this problem as soon as possible.

Thanks for any help in advance

Talat

View 4 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

Reporting Services :: Increase Range Bar Chart Size Dynamically Inside A Table In SSRS

Oct 21, 2015

 I have a range bar chart Inside a table of row group and the chart is repeatedly generate according to category ,i want to increase chart height dynamically based on category.

suppose for if category =A THEN CHART HEIGHT=10CM
category =B THEN CHART HEIGHT=7CM

View 5 Replies View Related

Log File Size (IDF) Is 4 Time Greater Than Data File (MDF)

Feb 19, 2013

I have a database whose log file size is 4 time greater then data file size, and its continuously growing day by day. Recently face limited disk related issue.

Is there any way to truncate log file???

What is impact on db if i truncate log file???

Is there any way to prevent this file continuously growing???

View 13 Replies View Related

SQL Server Admin 2014 :: Can Delete A Data-file Or File-group

Apr 27, 2015

In a server we had File Growth,And then We had to Add New Hard Drive And New File On It.And Now We have New server with a Huge Hard Drive.But all files remaind.Can I Reduce This files to One data file or not ?

View 3 Replies View Related

Check Db Size Data File And Log File

Apr 27, 2008

Hi,

i'm trying to write this script that check my database file and log size(in MB) and insert them into a table.i need the following columns
dbid,dbname,compatability_level,recovery_model,db_size_in_MB,log_size_in_MB.
i try to write this a got stuck.
select sysdb.database_id,sysdb.name,sysdb.compatibility_level,
sysdb.recovery_model_desc,sysmaster.size from sys.databases sysdb,sys.master_files sysmaster
where sysdb.database_id = sysmaster.database_id

can anyone help me with this script?
THX

View 13 Replies View Related

Data File Size

Apr 27, 2004

SELECT size_in_mb,used_size_in_mb,size_in_mb-used_size_in_mb as free_in_mb FROM (
SELECT cntr_value/1024 size_in_mb ,
(SELECT cntr_value/1024 FROM master..sysperfinfo WHERE counter_name='Log File(s) Used Size (KB)' AND instance_name='mydb') used_size_in_mb
FROM master..sysperfinfO WHERE counter_name='Log File(s) Size (KB)' AND INSTANCE_NAME='mydb'
) a

I need to store totalsize,usedsize,freesize of the datafiles in a table to get an average of how much my datafile has increased over a week.
The above query i am using is for logfile size. Can any one help me with datafile size plz.
I've checked sp_helpfile, sysfiles but couldn't find what i am lookin for(used and free space). EM in taskpad view for a database shows the statistics for the datafile. I've tried a trace to find out a stored procedure but couldn't!!!
May be i am unaware of a simple stored-procedure that can do this for me.

Howdy!

View 3 Replies View Related

Data File Size Problem

Jun 30, 2007

how can i change the initial size of the data and log file size ??? in my database properties it shows that my data file size is 81 mb and log file size is 985 mb! but my database only contains some tables and stored procedures with few rows of data in each tableand i checked that the actual mdf and ldf files are really that big... i tried to change it but it didn't work...can someone please teach me how to change it thanks! 

View 2 Replies View Related







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