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 |
|
Steel_m
Starting Member
25 Posts |
 Posted - 2008-11-04 : 09:45:38
|
| hi all. my database is full. The problem is, i cant even delete a table free up some space. The message i get in attempt to delete a tablel is " the log file for datase is full, backup the transaction to free up space" Im using 7.0, pleae help |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-11-04 : 10:00:17
|
| Change your Recovery model to Simple and shrink the log with DBCC shrinkfile. |
 |
|
|
Steel_m
Starting Member
25 Posts |
Posted - 2008-11-04 : 10:17:54
|
quote:
Originally posted by sodeep
Change your Recovery model to Simple and shrink the log with DBCC shrinkfile.
thanks for replying but How do i do this ? |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-11-04 : 11:52:54
|
| Go to database properties and change it to Simple recovery model and shrink log file with DBCC shrinkfileor usebackup log DBname with truncate_onlyand shrink log file |
|
|
|
Steel_m
Starting Member
25 Posts |
Posted - 2008-11-04 : 12:49:45
|
quote:
Originally posted by sodeep
Go to database properties and change it to Simple recovery model and shrink log file with DBCC shrinkfileor usebackup log DBname with truncate_onlyand shrink log file
I went into database properties but i didnt see an option to choose simple recovery model. And in options 'truncate log on checkpoints' and 'auto shrink' is unchecked. SHould i check either of them ? |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-11-04 : 13:22:52
|
| Do like this:1)Backup log DBname with truncate_only2)DBCC shrinkfile(logfile,desired size in MB) |
|
|
|
Steel_m
Starting Member
25 Posts |
Posted - 2008-11-04 : 15:53:17
|
| hey thanks much k |
|
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
Posted - 2008-11-04 : 17:03:28
|
quote:
Originally posted by Steel_mI went into database properties but i didnt see an option to choose simple recovery model. And in options 'truncate log on checkpoints' and 'auto shrink' is unchecked. SHould i check either of them ?
Truncate log on checkpoints is the SQL 7 equivalent of Simple Recovery Model in SQL 2000 and beyond. Auto Shrink means it will run DBCC SHRINKDB on a regular basis. You don't necessarily want to be shrinking your files on a regular basis because there are performance impacts when they have to grow again.---------------------------EmeraldCityDomains.com |
|
|
|
|
|
|
cant delete table