T.LOGANATHAN (8/30/2010)
Hi friends,Can any one give the suggestion regarding SQL server 2005 Backup & restoration size.
My DB size is -> 288347 (MDF) bytes (288 MB)
-> 13752896 (LDF) '' (13.7 GB)
While taking the full backup through SQL Agent jobs, its taking around 1.5 GB only.
My question is , There is no more space in the server and If I create same db with another name its occupying same size what i have mentioned above. How to reduce tran. log file to solve this issue ?
regards,
T.Loganathan
my email id : logu.t@nic.in
Since you have such a (relatively) small database, and such a HUGE log file (I run a 7gb data file with a 1.5gb log file), I strongly suspect that your database is in the full recovery mode, and that you're not taking transaction log files. This will cause your log file to swell to enormous levels as compared to your data, as you are exhibiting.
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes