Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Over Sized Transaction Log

Status
Not open for further replies.
dylanwhite

dylanwhite

MIS
Apr 4, 2003
25
GB
Hi,

I have a Data file of 17GB and a Transaction Log of 78GB!

Can anyone tell me why this might be and how i sort it out?

Thanks

Dylan

 
Sort by date Sort by votes
The TLog has never been backed up. Backup the file and shrink the log

Thanks

J. Kusch
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

GCL2007
  • Locked
  • Question
Simple Recovery model - Huge Trans Log
Replies
0
Views
160
GCL2007
GCL2007
JScannell
  • Locked
  • Question
SQL login on Classic ASP localhost site
Replies
0
Views
166
JScannell
JScannell
RRinTetons
  • Locked
  • Question
SQL Server 2008 R2 login auditing
Replies
0
Views
155
RRinTetons
RRinTetons
RRinTetons
  • Locked
  • Question
Logging into a database using SSMS from non-domain machine
Replies
1
Views
207
fredericofonseca
fredericofonseca
joblack23
  • Locked
  • Question
Large transaction log file
Replies
5
Views
133
joblack23
joblack23

Part and Inventory Search

Sponsor

Back
Top