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 |
|
PatDeV
Posting Yak Master
197 Posts |
 Posted - 2006-08-01 : 11:32:38
|
| My SQL back up fails and does not back up any database,it starts working after restarting the server?it also states that downgrading back up buffer from 960K to 64 KAny solution Please.!!Thanks |
|
|
KenW
Constraint Violating Yak Guru
391 Posts |
Posted - 2006-08-01 : 14:06:13
|
| PatDeV,This is a MS SQL Server forum. Try asking your MySQL questions at the MySQL forums on the MySQL website.Ken |
 |
|
|
PatDeV
Posting Yak Master
197 Posts |
Posted - 2006-08-01 : 14:52:55
|
| i am sorry but It is SQL server 2000 problem.Thanks for clearing out for me. |
|
|
|
schuhtl
Posting Yak Master
102 Posts |
Posted - 2006-08-01 : 17:10:13
|
| Have you applied service pack 4? |
|
|
|
PatDeV
Posting Yak Master
197 Posts |
Posted - 2006-08-01 : 18:13:34
|
| yes!! |
|
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2006-08-01 : 18:44:45
|
| please post the exact error messages. Use copy/paste so we have all the information.Also check your system and application event logs for related errors. paste that information (if there is any) as well.-ec |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2006-08-02 : 04:02:17
|
| Is SQL AGENT service "stopping" for some reason?Kristen |
|
|
|
schuhtl
Posting Yak Master
102 Posts |
Posted - 2006-08-02 : 09:16:28
|
| http://support.microsoft.com/default.aspx/kb/904804In SQL Server 2000 Service Pack 4 (SP4), the following warning message is logged in the SQL Server error log:Downgrading backup buffers from 960K to 64KThis error message indicates that the contiguous virtual memory is either insufficient or is too fragmented for the computer to successfully perform a backup. Contiguous virtual memory that is insufficient or that is fragmented could lead to performance problems when you try to back up the database.For more information, click the following article numbers to view the articles in the Microsoft Knowledge Base: 873482 (http://support.microsoft.com/kb/873482/) FIX: The restore process may take longer to complete when SQL Server 2000 restores transaction log files as part of the log shipping process 824430 (http://support.microsoft.com/kb/824430/) FIX: Performance decreases over time when you back up files in SQL Server 2000 |
|
|
|
|
|
|
SQL Backup Failures!!!!