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 |
|
YogeshDesai
Posting Yak Master
136 Posts |
 Posted - 2007-05-04 : 00:16:38
|
| hey guys,I was searching on net regarding the transaction log failure error,I am getting the error "Downgrading backup buffers from 960K to 64K"While reading documentation on MSDN They asked to install hotfix,But I have already SP4 an latest hotfix build 2187 installed three weeks back to fix the same issue.Now,I was just trying to find out the buffer count andThe value of the BufferCount parameter is calculated by using the following formula:NumberofBackupDevices*3 + NumberofBackupDevices + NumberofDatabaseFiles = BufferCountHow to find Number of Backup DevicesNumber of Databasefiles.Please help to fix this issue,Just calculating the buffer count,I will not be able the to fix the issue.Your help is required.Yogesh V. Desai. | SQLDBA| |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-05-04 : 09:36:39
|
| You can find number of db files by querying sysfiles1 table in the db. Number of backup devices is device you specified in backup statement. |
 |
|
|
|
|
|
BufferCount Formula