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 |
1sqlover
Yak Posting Veteran
56 Posts |
Posted - 2006-12-28 : 11:17:08
|
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
Master Smack Fu Yak Hacker
1837 Posts |
Posted - 2006-12-28 : 11:35:06
|
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. |
|
|
1sqlover
Yak Posting Veteran
56 Posts |
Posted - 2006-12-28 : 11:39:20
|
I see, and backing it up should be done through SQL Server not just, our Backup Software?epoh |
|
|
snSQL
Master Smack Fu Yak Hacker
1837 Posts |
Posted - 2006-12-28 : 11:58:55
|
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. |
|
|
1sqlover
Yak Posting Veteran
56 Posts |
Posted - 2006-12-28 : 12:26:46
|
Veritas BE 10d with SQL Agent. So I should be okay.epoh |
|
|
readysetstop
Posting Yak Master
123 Posts |
Posted - 2006-12-28 : 12:51:08
|
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. |
|
|
1sqlover
Yak Posting Veteran
56 Posts |
Posted - 2006-12-28 : 12:52:40
|
Good suggestion.epoh |
|
|
Kristen
Test
22859 Posts |
Posted - 2006-12-28 : 14:21:14
|
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 |
|
|
Annabellewuj
Starting Member
1 Post |
Posted - 2012-12-19 : 06:31:15
|
unspammed |
|
|
|
|
|
|
|