Method One resolution process:
View the properties of the following database, which is autogrow and does not specify a maximum file size.
Google on the internet for a long time, tried some methods are not, the database is located on the disk has a lot of free space, try to take the heavy medicine.
Change the size of the tempdb data file and log file directly to 3000M,
Problem solving.
Record the command to empty the log:
DUMP TRANSACTION dbname with no_log
Truncate the transaction log command:
BACKUP LOG dbname with no_log
Shrink Log operations:
Right-click Database-Properties-All Tasks-Shrink database-file-select File-ok.
Method Two resolution process:
First, let's describe in detail how to clean up SQL 2000 logs with Enterprise Manager:
1. Open Enterprise Manager, right-click the database to be processed--"attribute--" option--"Fault restore, choose" simple "-" OK. "
2, right-click the database to be processed-"All Tasks-" shrinking database-"Nothing moves, the default first is 0%, the other two is unchecked, click OK-" If you have a previous database log file larger than 1M then now look, is not only 1 m.
3, the operation after--"according to the first step, the" failure to restore ", select" complete ", The Legend of SQL Server 2000 has automatic restore function, said that if the illegal shutdown and other factors such as data loss can be automatically rolled back, the other can be used to implement the operation Rollback, it is best to let the fault restore is" complete.
Log of sqlserver2000 database ' tempdb ' is full