SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 LDF larger than MDF
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

1sqlover
Yak Posting Veteran

56 Posts

Posted - 12/28/2006 :  11:17:08  Show Profile  Reply with Quote
I was interested to see how large a certain Database had become over the past year, and I was shocked to see that the LDF was larger than the MDF. Is this normal?

snSQL
Flowing Fount of Yak Knowledge

USA
1837 Posts

Posted - 12/28/2006 :  11:35:06  Show Profile  Reply with Quote
It's not necessarily normal, but it is not unusual. It probably means you are not backing up your transaction log at all, or at least you are not backing it up frequently enough. The log gets truncated when you back it up, so if you don't back it up it can get very large.
Go to Top of Page

1sqlover
Yak Posting Veteran

56 Posts

Posted - 12/28/2006 :  11:39:20  Show Profile  Reply with Quote
I see, and backing it up should be done through SQL Server not just, our Backup Software?

epoh
Go to Top of Page

snSQL
Flowing Fount of Yak Knowledge

USA
1837 Posts

Posted - 12/28/2006 :  11:58:55  Show Profile  Reply with Quote
That depends on what your backup software is. If it is regular file backup software then your backups of the SQL Server data files are almost useless and you should start running SQL Server backups and backing up the SQL Server backup files with your backup software.

If your backup software is fully SQL Server aware then it should be doing the equivalent of a SQL Server backup for you, but you need to confirm that.
Go to Top of Page

1sqlover
Yak Posting Veteran

56 Posts

Posted - 12/28/2006 :  12:26:46  Show Profile  Reply with Quote
Veritas BE 10d with SQL Agent. So I should be okay.

epoh

Edited by - 1sqlover on 12/28/2006 12:28:12
Go to Top of Page

readysetstop
Posting Yak Master

USA
123 Posts

Posted - 12/28/2006 :  12:51:08  Show Profile  Visit readysetstop's Homepage  Send readysetstop a Yahoo! Message  Reply with Quote
1sqlover,

I've had issues upon issues with Veritas and database restores. I would recommend ensuring that SQL is backing itself up to disk files, and then getting those with Vertias, rather than relying on the SQL agent. This has always proved very reliable for me.

My $0.02.

-d.
Go to Top of Page

1sqlover
Yak Posting Veteran

56 Posts

Posted - 12/28/2006 :  12:52:40  Show Profile  Reply with Quote
Good suggestion.

epoh
Go to Top of Page

Kristen
Test

United Kingdom
22403 Posts

Posted - 12/28/2006 :  14:21:14  Show Profile  Reply with Quote
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=55210&SearchTerms=Backup+to+Disk,or+direct+to+Tape,What%20type%20of%20backup%20should%20I%20use,Automating%20Backups,Backup
Go to Top of Page

Annabellewuj
Starting Member

Jordan
1 Posts

Posted - 12/19/2012 :  06:31:15  Show Profile  Reply with Quote
unspammed
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.25 seconds. Powered By: Snitz Forums 2000