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 |
|
Faris2100
Starting Member
10 Posts |
 Posted - 2006-12-06 : 11:31:27
|
| when backing up SQL server databases, i am getting an error backup is failing because there is no (960kb)1MB contiguous blocks. it appears as if the SQL Virtual memory is fragmneted, because of that i was not able to process a query till the server was rebooted. Any one knows what the issue is and what the cause/solution??Thanks alotFaris |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2006-12-06 : 11:56:25
|
is your disk very defragmented?Go with the flow & have fun! Else fight the flow  blog thingie: http://weblogs.sqlteam.com/mladenp |
 |
|
|
Faris2100
Starting Member
10 Posts |
Posted - 2006-12-06 : 15:27:43
|
| i did not check and since the reboot fixed the problem i am thinking it has nothing to do with the HD rather it is memory issue. |
|
|
|
snSQL
Master Smack Fu Yak Hacker
1837 Posts |
Posted - 2006-12-06 : 17:13:32
|
| See http://support.microsoft.com/default.aspx/kb/904804 |
|
|
|
Faris2100
Starting Member
10 Posts |
Posted - 2006-12-07 : 08:43:54
|
| thanks snSQL.i have seen that article, not much there about whata cause the problem and how to avoid it. If any one knows what the cause is and how to prevent it from happening i greatly appreciate it.thanks |
|
|
|
snSQL
Master Smack Fu Yak Hacker
1837 Posts |
Posted - 2006-12-07 : 10:36:37
|
| Tell us about your server - how much RAM, SPs installed, database size etc. |
|
|
|
|
|
|
SQL Memory Error