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 |
|
samsonpablo
Starting Member
3 Posts |
 Posted - 2010-11-22 : 14:16:24
|
| Hi, I inherited a db that was set to allow the transaction log to grow unrestricted. It's running on rather old hardware on mirrored 8gb drives. The transaction log is ~6gb, the actual data files are only ~550mb :-/ The transaction logs go back to 2005 when this system was first put into production. If I go into the transaction log tab under database properties and set "Restrict File Growth" to something like 4gb, what becomes of the current transaction log? Will the oldest entries just roll off or will all the transaction logs be lost?thanks!-sam |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
samsonpablo
Starting Member
3 Posts |
Posted - 2010-11-22 : 15:05:21
|
| Thanks for the quick reply Tara. I should have added that I'm not a dba, I'm doing contract unix sysadmin, networking and infosec work for the company. The person who took care of this just left and it was handed to me because there are no other IT folks...The recovery model is set to full and append log backups occur to a different drive every 3 hours 7am-8pm (it's only used during the day). They are running nightly tape backups but I also just set the backups to go to an external drive because AFAIK they've never actually tested a restore. My primary concern is freeing some disk space so the system can continue to run until it's migrated to sql server 2005. I take it that my original question was not as simple as I thought? :-) |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
samsonpablo
Starting Member
3 Posts |
Posted - 2010-11-22 : 15:21:46
|
| Thanks Tara! |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
question about Transaction Log Tab under db props