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...
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 ...
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?!
...
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?
What exactly happen to the mdf and ldf files when shrink is applied (Internals???)
...
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...
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 ...
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...
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?
...
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...
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...
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...
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...
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)?
...
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
...
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...
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...