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 |
|
venkath
Posting Yak Master
202 Posts |
 Posted - 2006-06-22 : 08:32:59
|
| Hi allThe file 'ATPP25' has been expanded beyond its maximum size to prevent recovery from failing. Contact the system administrator for further assistance.How to deal with the above issue..Thanks in advance.. |
|
|
drewsalem
Constraint Violating Yak Guru
304 Posts |
Posted - 2006-06-22 : 08:35:33
|
| Again,Is the database size limited?or Is the disk full?On SQL Server 2000If the database is limited:1 Go to Enterprise Manager.2 Click on the Server that the database lives on3 Click on Databases4 Find you database and right click on it5 Click on Properties6 Select the Datafiles tab7 Make sure the "Automatically grow file" checkbox is ticked.8 Select the Maximum file size to "Unrestricted File Growth"9 Then click on the Transaction Log tab and repeat steps 7 and 8.If the disk is full. Free up some space on the physical disk that database/transaction log lives on. You can determine the letter of that disk from the same tabs as above (by looking at the path under "location".Hope that helps. |
 |
|
|
venkath
Posting Yak Master
202 Posts |
Posted - 2006-06-22 : 08:52:08
|
| Thanks..can i add new data and log files for the database if the problem is with the limited database size...instead of making the maxsize as unlimited..Thanks.. |
|
|
|
drewsalem
Constraint Violating Yak Guru
304 Posts |
Posted - 2006-06-22 : 09:02:35
|
| Yes, you can. Again you can use enterprise manager. I'm not sure at what stage (or how) it starts using the secondary log file. It may occur automatically. I'm unsure. |
|
|
|
|
|
|
File expansion beyond its max size