473,326 Members | 2,182 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,326 software developers and data experts.

Transaction logs

SS
This seems like it'd be a really stupid question, but for the life of me I
haven't been able to find an answer that works....

I have a database that's approximately 400MB when shrunk... and the
transaction logs are at about 4.8GB when shrunk... I can't seem to get the
transaction log any smaller, no what I try. How can I get the log down
below 1GB and keep it there? I've only got an 18GB hard drive and I need to
run 2 copies of this database.

-steve
Jul 20 '05 #1
4 1840
"SS" <ph******@hotmail.com> wrote in message news:<6h*****************@twister.nyroc.rr.com>...
This seems like it'd be a really stupid question, but for the life of me I
haven't been able to find an answer that works....

I have a database that's approximately 400MB when shrunk... and the
transaction logs are at about 4.8GB when shrunk... I can't seem to get the
transaction log any smaller, no what I try. How can I get the log down
below 1GB and keep it there? I've only got an 18GB hard drive and I need to
run 2 copies of this database.

-steve


This may help:

http://support.microsoft.com/default...&Product=sql2k

Simon
Jul 20 '05 #2
"SS" <ph******@hotmail.com> wrote in message
news:6h*****************@twister.nyroc.rr.com...
This seems like it'd be a really stupid question, but for the life of me I
haven't been able to find an answer that works....

I have a database that's approximately 400MB when shrunk... and the
transaction logs are at about 4.8GB when shrunk... I can't seem to get the transaction log any smaller, no what I try. How can I get the log down
below 1GB and keep it there? I've only got an 18GB hard drive and I need to run 2 copies of this database.


Truncate the logfile at backup.
How many open transactions are there at backup?
Any transactions not committed will hold an entry in the log.
Study this by running
dbcc opentran


--
Pete Brown
Winluck P/L
IT Managers & Engineers
Falls Creek
Australia
www.mountainman.com.au/software

Jul 20 '05 #3
Am Wed, 07 Apr 2004 03:08:50 +0000 schrieb SS:
This seems like it'd be a really stupid question, but for the life of me I
haven't been able to find an answer that works....

I have a database that's approximately 400MB when shrunk... and the
transaction logs are at about 4.8GB when shrunk... I can't seem to get the
transaction log any smaller, no what I try. How can I get the log down
below 1GB and keep it there? I've only got an 18GB hard drive and I need to
run 2 copies of this database.

-steve

Hello,

is the database setup for replication?
Maybe one user hasn't replicated for long time

HTH
Karpi
<fluctuat nec mergitur>

Jul 20 '05 #4
Am Wed, 07 Apr 2004 03:08:50 +0000 schrieb SS:
This seems like it'd be a really stupid question, but for the life of me I
haven't been able to find an answer that works....

I have a database that's approximately 400MB when shrunk... and the
transaction logs are at about 4.8GB when shrunk... I can't seem to get the
transaction log any smaller, no what I try. How can I get the log down
below 1GB and keep it there? I've only got an 18GB hard drive and I need to
run 2 copies of this database.

-steve

Hello,

is the database setup for replication?
Maybe one user hasn't replicated for long time

HTH
Karpi
<fluctuat nec mergitur>

Jul 20 '05 #5

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

7
by: enigma | last post by:
Just wondering if you could help me on this one. I'm not sure if my transaction logs are behaving oddly or what. I've successfuly managed to shrink my transaction logs from 7GB down to 1MB and now...
3
by: Thiko | last post by:
Hi I take one nightly full database backup at 02:00 and backup the transaction log to one backup set every 15mins. The commands to do this are as follows and are set up to run as database...
0
by: xo55ox | last post by:
Hi, I have been trying to set up an automated restore process from prod to backup server. First, I schedule the full database backup nightly, transfer the backup file and restore it to the...
3
by: Andrew S. | last post by:
I recently performed an SQL server 2000 installation. Other than placing the program files on C: and data on D:, I saw no option to install transaction logs in an alternate location. What is...
7
by: Abdul-Wahid Paterson | last post by:
Hi, I have had a site working for the last 2 years and have had no problems until at the weekend I replace my database server with a newer one. The database migration went like a dream and I had...
2
by: francois1 | last post by:
I am running a website with a SQL Server database attached. My transaction logs are full and my hosting co. won't allocate more disk space for me. I need to delete my database transaction logs...
3
by: TG | last post by:
Coming from a (mostly) Oracle shop, I am unclear how SS transaction logs work as far as up to point of failure recovery goes. I have the few MSSQL databases I look after in full recovery mode,...
1
by: JA | last post by:
Hi, I know just about nothing about SQL Server. I am getting this error: The log file for database 'my_database' is full. Back up the transaction log for the database to free up some log space. ...
3
by: Laurence | last post by:
Hi folks, How to remove the transaction logs which are out of date in HADR environment? DB2 command PRUNE, it can only run on primary database but cannot run on standby database. Because the...
4
by: Brian D | last post by:
In MS SQL 2005 when you do a Full Backup does it also backup and truncate the transaction logs or do I need to back the transaction logs up separately? Thanks. Brian
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.