Problem with Backup Plan - SQL Server Forums

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.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

Problem with Backup Plan

Author

Topic

PatDeV
Posting Yak Master

197 Posts

Posted - 2006-08-28 : 14:37:29

Hi all,

I am getting this error in log server:
WARNING: Failed to reserve contiguous memory of Size= 65536.
then
Buffer Distribution: Stolen=3562 Free=162 Procedures=127506
Inram=0 Dirty=918 Kept=0
I/O=0, Latched=40, Other=74684
then -->
Buffer Counts: Commited=206872 Target=206872 Hashed=75642
InternalReservation=223 ExternalReservation=0 Min Free=128 Visible= 206872

I have my SQL 2000(SP4) on Windows 2003 Server: with Windows SP1

what is the problem?

Please help.....

thanks

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2006-08-28 : 14:42:24

Run DBCC CHECKDB to see if you have any database corruption. Check Event Viewer for hardware problems.

Tara Kizer

PatDeV
Posting Yak Master

197 Posts

Posted - 2006-08-28 : 14:44:53

i tried runing that too and everything looks fine with DBCC checkDB command. it returned with no error found in database.

Thanks

PatDeV
Posting Yak Master

197 Posts

Posted - 2006-08-28 : 14:47:22

and if i restart the SQL server then it works fine!!

Vivaldi
Constraint Violating Yak Guru

298 Posts

Posted - 2006-08-28 : 14:49:36

quote:
Originally posted by PatDeV

and if i restart the SQL server then it works fine!!

based on a quick google search, you aren't the only one having trouble.
http://groups.google.com/group/microsoft.public.sqlserver.server/browse_thread/thread/aa0b65303994bda/b8b27c39dd309b81%23b8b27c39dd309b81

________________________________________________
"Wow, you have a master's degree in psychology? I will order a vodka martini, thanks"

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources