Re: Shrink Express DB After Large Data Import
- From: "ThoraD" <ThoraDToBeRemoved@xxxxxxx>
- Date: Sat, 16 Dec 2006 06:49:25 -0700
"coastaldata" <coastaldata@xxxxxxxxxxxxxxxx> wrote in message
news:6D216D9B-6431-4688-8E43-3CAAF9875621@xxxxxxxxxxxxxxxx
Hello, I have a small VB.Net application that I've built in VS2005 that
indexes and helps me to work with various collections of files on my
network.
It works great at first, especially with small collections, but after a
time,
or immediately after import of a large collection, the application becomes
unresponsive due to the size of the database and the log.
In regards to the log, I really don't need it -- I just want to slurp in
my
data and run sql queries against it... the database would never need to be
recovered.
I need either VB.Net code that can perform maintenance functions on the
database, or else a way to configure the database to not store logs, or
both...
Or some other solution? Granted, this may not be the best application of
SQL
server, but I need the experience with it, and it's giving me some good
insight into the types of problems and limits that these databases
encounter.
Any help is greatly appreciated!
--Jon
--(CoastalData)
You have installed SQL Server Management Studio Express ?
Right click on your database, chose properties, options, set the database
recovery model to Simple and Autoshrink to True
ThoraD
.
- Prev by Date: Re: How I get control over dialog that opened from my form?
- Next by Date: Re: Shrink Express DB After Large Data Import
- Previous by thread: Re: Document Scanning.
- Next by thread: Re: Shrink Express DB After Large Data Import
- Index(es):
Relevant Pages
|
