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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-01-29 : 17:24:29
|
| Daniel Lau writes "Dear Sir/Madam,My SQL server can not work until I manually expand the size ofdatabase tempdb and transaction log of tempdb file. I have already set autogrow options to database tempdb and transaction log of tempdb.Why transaction log of tempdb can not autogrow when it is full?How can I avoid this thing happen again?During the backup process of SQL7.0, I have got the following error log.[2002-01-21 16:06:24.84 kernel Tape 'POSTape' (Family ID: 0xc82d0b2a, sequence 1) mounted on tape drive '\\.\Tape0'.2002-01-21 16:06:36.12 backup Log backed up with following information: Database: FB, creation date and time: 2002/01/09(08:22:03), first LSN: 5:185129:1, last LSN: 5:186939:1, striped: 0, number of dump devices: 1, device information: (FILE=8, TYPE=TAPE, MEDIANAME='POSTape': {'\\.\Tape0'}).2002-01-21 16:19:33.96 spid16 Error: 9002, Severity: 17, State: 22002-01-21 16:19:33.96 spid16 The log file for database 'tempdb' is full. Back up the transaction log for the database to free up some log space..]ThanksDaniel Lau" |
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2002-01-30 : 01:07:03
|
| Hard to say without more info. Is the drive that holds tempdb files low on space? What is the size of the logfile? What is the size of the tempDB?Are there any other errors in the errorlog?-Chad |
 |
|
|
|
|
|
|
|
SQL 7.0 Server halt when using backup tape