mjafar (1/3/2008)
Yes sir,I m not using SQL server 2005.
The please post in the SQL 2000 forum so people don't waste their time and yours giving suggestions that don't work on the version you're using.
And about transaction log backup, No not huge transaction is going on it.
So i think it's not necessary to take frequent tranx backup.
Current mdf size is 8 GB & ldf is 61 GB.
How I can optimize my space.?
The log must have grown to that size because it needed that much space for transactions. You can shrink it, but the chances are it will grow again.
Check just before one of your log backups and see how much of the log is in use (taskpad in Enterprise manager)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability