Reduce database size

You can shrink databases, rebuild index.. and delete old journal entries (digital copy of receipt) ..

which is the size of your database ?

cod

The database is 911 Mb. It shows I have 16 Mb left.

Thanks for any help.

"coupleofdogs" wrote:

That seems quite small left...sounds like you need a bigger hard drive, or get some of the other stuff of of it. You should be able to run up to 2GB on the SQL Desktop engine...If you need a bigger DB, you should upgrade to full SQL server (no limit)...Retail Realm does have an archiving tool that allows you to pull data out, but it basically pulls that data out of your active DB, and places it in an archive DB. therefore, you would still need more disk space, but that would improve performance in the active DB. Basically, it's the Journals that hog most of the space, you could also get rid of those to fre up some space. Having said all of that, if you are running that close, you probably should consider upgrading your hardware...RAM is the biggest factor (I have found) in the performance of RMS.

H> The database is 911 Mb. It shows I have 16 Mb left.

1st make a backup for your database then:

1) With both the original .MDF and .LDF files located where they supposed to be, run RMS Administrator and select the database you want to shrink.

2) Issue this query to find the log device name: SELECT FILE_NAME(2). This will return the name of your log device (like QSDB_log)

(in our Example the Database will be rmssample and the log device name is QSDB_log

3) Issue this query: DBCC SHRINKFILE (QSDB_log, 1). If this does not shrink the file, proceed to the next step

4) Issue this query: BACKUP LOG rmssample WITH TRUNCATE_ONLY (Replace rmssample with the name of your database FOREXAMPLE RMS_Store1)

5) Then run this query: DBCC SHRINKFILE (rmssample_log, 1)

Afshin Alikhani - [ snipped-for-privacy@retailrealm.co.uk ]

CEO - Retail Realm

= = = = = =

I think he's seeing 16MB left in database properties, not disk properties. SQL Server will 'auto-grow' the DB file as needed until it reaches the version size limit or the end of the drive.

900MB is not really large, but it may be relatively large depending on the hardware it is hosted on (RAM primarily).

I agree that it makes more sense to use the Retail Realm tool than to try archiving or deleting old records on your own.

Glenn Adams Tiber Creek C> That seems quite small left...sounds like you need a bigger hard drive,