Re: Transaction Log Size
From: Mark Allison (mark_at_no.tinned.meat.mvps.org)
Date: 11/24/04
- Next message: Wayne Snyder: "Re: 3 triggers into one"
- Previous message: Des FitzGerald: "Re: Having a problem attaching a database"
- In reply to: Steven Hutchinson: "Re: Transaction Log Size"
- Next in thread: Steven Hutchinson: "Re: Transaction Log Size"
- Reply: Steven Hutchinson: "Re: Transaction Log Size"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 24 Nov 2004 13:12:55 +0000
Steven,
To add to Tibor's message, you will generally come up against fewer
problems if you backup your databases and logs natively, then get
CommVault to backup the backup files.
So, only get CommVault to backup your MSSQL\BACKUP directory if that is
where all your native backups go.
-- Mark Allison, SQL Server MVP http://www.markallison.co.uk Looking for a SQL Server replication book? http://www.nwsu.com/0974973602m.html Steven Hutchinson wrote: > Thanks for all your replies. > > We currently use a 3rd party backup agent to backup our SQL databases and > transaction logs (Commvault Galaxy iDataAgent for SQL) and the database is > in Full Recovery mode. It appears that the transaction logs are not reducing > in size after these regular backups are taking place. > > Because we are using a 3rd party agent to backup the database, do I still > need to issue the BACKUP LOG command before using DBCC SHRINKFILE? > > Should I get in touch with Commvault to query this or is this normal > behaviour if you use a 3rd party backup agent instead of the native sql > backup? > > > "John Bandettini" <JohnBandettini@discussions.microsoft.com> wrote in > message news:DC5C5FA6-1ED9-4CDA-9640-E3F5FA90A0EF@microsoft.com... > >>Steven >> >>here are some articles on how to shrink your transaction log. >> >>INF: How to Shrink the SQL Server 7.0 Transaction Log >>http://support.microsoft.com/default.aspx?scid=kb;en-us;256650 >> >>INF: Shrinking the Transaction Log in SQL Server 2000 with DBCC SHRINKFILE >>http://support.microsoft.com/default.aspx?scid=kb;en-us;272318 >> >>http://www.mssqlserver.com/faq/logs-shrinklog.asp >> >>I would guess that you have your database/databases in Full recovery mode >>and you have not been performing Transaction log backups. >> >>You need to either set them to simple recovery mode or schedule regular >>transaction log backups. >> >>To check the recovery mode of your databases, right click on the database >>in >>Enterprise Manager and choose options. You can chnage the mode from the >>window that will open. >> >>To perform transaction log backups (and database ones) you can use a >>wizard >>to set them up or you can create jobs manually and use the backup command. >>(See BOL for format) >> >>Hope this helps >> >>John >> >>"Steven Hutchinson" wrote: >> >> >>>Is it possible to reduce the size of the transaction log for a specific >>>database. At the moment one of our databases has a database of size of >>>16Gb >>>and a transaction log of 43Gb!! >>> >>>As you might guess I am new to SQL Server but this doesn't seem right? >>> >>>Any help would be greatly appreciated.. >>> >>> >>> > > >
- Next message: Wayne Snyder: "Re: 3 triggers into one"
- Previous message: Des FitzGerald: "Re: Having a problem attaching a database"
- In reply to: Steven Hutchinson: "Re: Transaction Log Size"
- Next in thread: Steven Hutchinson: "Re: Transaction Log Size"
- Reply: Steven Hutchinson: "Re: Transaction Log Size"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
Loading
