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 |
|
donarinetcom
Starting Member
3 Posts |
 Posted - 2011-06-21 : 12:30:41
|
| Does anyone know what is the best practice log file sizes. I have read many discussions and they all refer to "huge" or "big". I am not sure what that menas relative to my environment.I have a content and a search db with the following sizes:- Content: mdf 3.5 gb, ldf 123 mb- Search: mdf 237 mb, ldf 321 mbI am new to SQL admin, I don't think this has been truncated or shrunk. The Infrastructure team tells me that the db in this box is being backed up.Do my databases fall in the "big" category? If so, what are the steps to bring them in the right size? Also, just curious, could this impact my application. The SharePoint (WSS 3.0)application using these databases intermittently hungs.Help! |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2011-06-21 : 12:44:25
|
| There is no best practice. What size your file needs to be depends on your recovery, and if it's not SIMPLE then how often you are performing tlog backups as well as your largest transaction.Your databases are tiny. The ldf file sizes are reasonable and do not need to be touched.I wouldn't trust your infrastructure team regarding backups. If you are the SQL administrator, then this is your number one responsibility. Please check the SQL Error Log for messages pertaining to backups to determine what you have going on. If you don't see anything, then this is a big problem.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog |
 |
|
|
donarinetcom
Starting Member
3 Posts |
Posted - 2011-06-21 : 14:15:30
|
| Tara - thanks.It looks like the db is being backed up based on an error that pops up intermittently appears i.e.Error: 3041, Severity: 16, State: 1Backup failed to complete the command BACKUP DATABASE dbname. Check application log for detailed messages.What puzzles me is in some parts of the same log, a message comes up saying:SQL Database 'dbname' on SQL Server instance 'server name' not found. Additional error information from SQL Server is included below. Cannot open database 'dbname' requested by the login. Login failed for user 'username'Not sure what this message is saying because, 'dbname' is in 'servername' and I do log in as the 'username' to do my admin work.any clue? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
donarinetcom
Starting Member
3 Posts |
Posted - 2011-06-21 : 16:07:37
|
| Thanks Tara. I will check it out |
|
|
|
|
|
|
|
|
SQL LDF and MDF