Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
mbevon
Starting Member
41 Posts |
 Posted - 2002-07-05 : 15:04:39
|
| I've a database that has not been back up for the longest while>I can backup unitl monday because ther's no tapeIf i try to do anything , i'm getting the foll message.Error9002 The log fiel for database " TRadsys" is full. Backup the transaction log for the databse to free up some log space.How do i back up the transaction log?thanks |
|
|
Kevin Snow
Posting Yak Master
149 Posts |
Posted - 2002-07-05 : 16:28:08
|
| If you haven't backed up in a long time, you are probably set up to truncate the log on check point (Recovery Model = Simple). If you have filled the transaction log, you will need to expand its size - even before truncating. Using SQL Enterprise Manager, you can expand the log file via the database's PROPERTY|TRANSACTION LOG tab. You may then attempt to shrink the database (using the FILES option button to designate the log) or execute the following in Query AnalyzerALTER DATABASE database MODIFY FILE (NAME = nameoflogfile, SIZE = 20MB --something larger than current)GO}BACKUP LOG { database_name | @database_name_var } WITH TRUNCATE_ONLYThis will free up the transaction log. |
 |
|
|
|
|
|
Transaction Log backup