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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2006-12-07 : 07:54:15
|
| Abe writes "i am using SQL server 2000, when i tried to back up the database in SQL server, the backup began failing coz SQL Server could no longer allocate 964kb of contiguous blocks. (the min needed is 1MB)What causes the memory or blockes to be fragmented?How do you solve this issue other than rebooting the server?How do you prevent this from happening or monitor this issue?Regards,Abe" |
|
|
Kristen
Test
22859 Posts |
Posted - 2006-12-07 : 08:13:40
|
| See http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=75984 |
 |
|
|
|
|
|
SQL Server memory fragmentation