shrink

How do I shrink my SQL Server Database?

I have a Database nearly 1.9Gb Database in size MSDE2000 does not allow DBs that exceed 2.0Gb I need to shrink this DB (and many like it at various client locations) I have found and deleted many 100's of 1000's of records which are considered unneeded. these records account for a large percentage of some of the main (largest) tables i...

refering to already existing group in regex, c#

I have a regex where %word% can occur multiple times, separated by a "<" %word% is defined as ".*?"|[a-zA-Z]+ so i wrote (".*"|[a-zA-Z]+)([<](".*"|[a-zA-Z]+))* Is there any way i can shrink it using capturing groups? (".*"|[a-zA-Z]+)([<]\1)*, But i don't think \1 can be used as it'd mean repeat the first capture, as i would not ...

Letting a Batch file Minimize a DOS window?

So i'm kinda into MS-DOS and such again, but i came to ask myself, How can i minimize a DOS window? Any kind would be ok, minimalize, shrink to a tiny blue block. I just can't seem to find a way to let it work on my Windows XP computer, is realy evrything excluded in XP?! ...

Programmatically determine available free space on a database?

Ok, I have tried searching around for this answer, but with no luck. I have about 50 databases on our SQL Server at work that I have to check almost every day to see if any space can be freed up via shrinking. Our drives tend to fill up a lot, so this is why it is an almost daily task. Is there a quick way to check what databases ac...

Does performance of a database (SQL Server 2005) decrease if I shrink it?

Does performance of a database (SQL Server 2005) decrease if I shrink it? What exactly happen to the mdf and ldf files when shrink is applied (Internals???) ...

Database size is huge

I have the following problem. We have a database that stores binaries in the database. We know the size of the database can be big so we removed all the binaries from the database and used the task "shrink" on it. This way we hoped that the database would be much smaller. These are the results: before removal size was: 20 gigabyte after...

How to get the first n elements of a std::map

Since there is no .resize() member function in C++ std::map I was wondering, how one can get a std::map with at most n elements. The obvious solution is to create a loop from 0 to n and use the nth iterator as the first parameter for std::erase(). I was wondering if there is any solution that does not need the loop (at least not in my ...

SQL Server 2005 No Space for Transaction Log Backup

Possible Duplicate: SQL Server 2005 Transaction Log too big I am running SQL Server 2005. My db backup scheme is: Recovery model: FULL Backup Type: Full Backup component: Database Backup set will expire: after 0 days Overwrite media: Back up to the existing media set, Append to the existing backup set The db is writing to 250G...

SQL - shrink database log file

I am trying to shrink my database log file. I have tried to run: USE databasename BACKUP log databasename WITH truncate_only DBCC shrinkfile (databasename_log, 1) I get the error message: Msg 155, Level 15, State 1, Line 3 'truncate_only' is not a recognized BACKUP option. Am I missing something? ...

Shrink image in usercontrols

I have asp.net user control that has datalist load images. But it is not working for me. <td class="billboard-itemPicture"> <asp:Image ID="Image1" runat="server" class="billboard-picture" ImageUrl='<%#Eval("UserImage") %>' Width="100px" Height="100px" /> <script type="text/javascript" > $(document).ready(function() { $('.bill...

Shrink database after removing extra data

We have a need to fit database in 4G in order to use ms sql express edition. I started from 7G database, and found a lot of not needed records, and deleted them. After Shrink database size is 4.6G, and 748MB is free (according to database properties). However, when i execute exec sp_spaceused i am having interesting results: Database...

JQuery draggable inside a dialog won't clip or behave

Hi I am using jQuery 1.8 and I want to have a custom 'draggable' control that is a child of a jquery dialog. I am encountering lots of problems as I want the draggable control to shrink to its contents size (its a div for now) and be clipped with in the dialog bounds. If I set the control to position absolute it behaves perfectly but d...

Is it possible to shrink a log file on a linked server using DBCC SHRINKFILE?

I am doing a large archival of data from one DB to another DB on a linked server. I am copying from MS sql server 2000 to MS sql server 2005. This involves copying millions of records and then deleting them. This all happens via a dynamic script. I would like to incorporate the shrinking of the log file for this process, but I am unabl...

SQL Server: Hidden risks of using DBCC SHRINKFILE

We're getting a huge LDF file by using a full recovery mode in a SQL Server DB. so we're planning to shrink the log file. Is there any performance penalty for using DBCC SHRINKFILE to reduce the database log file size (LDF)? and what about applying it to the data file (MDF)? ...

Making .war smaller!

There are several tutorials and even some posts here about shrinking .war files. However, the most common technique (to include grails.war.resources = {} in Config.groovy) does not seem to work for me. No matter what, grails dumps everything into the war file making a 25meg .war. Has this functionality changed? Grails 1.3.4 ...

Can realloc shrink my array on the left side (C only)?

I want to move a large chunk of data i've got in my memory. Unfortunately this data is saved as an array, and i cannot change that. I can't use circular arrays, because the same memory is also used by a couple of fortran methods i do not want to change. On top of it, the arrays are accessed very very often in between the movement. So i c...

Recover unused space in SQL Table

We recently moved the value of a column from an existing table to a new table so that it could reside on a separate disk. The preexisting column still remains but has been set to null as some historical applications may still reference this column when writing data. The table now has 10GB unused space that we can not reclaim even after...