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 - 2002-06-10 : 09:25:17
|
| Jim writes "I have a backup job in SQL Server 2000 SP2 which runs at 2 AM, dumping the contents of my main database to a .BAK file. On seemingly random days, the agent manages somehow to lock the entire machine up (Windows 2000 server sp2 running ADS, SQL Server not added to ADS). No events are written to the event log at all - the machine is entirely frozen and we have to restart with the interrupt switch. The agent does an overwrite full backup to a file on a storage array. I created it from the Management -> Backup item in the SQL Enterprise Manager console. It fails about 1 time in 3 or 4. I am at a complete loss. I have contacted my application vendor, and they are at a complete loss - none of their other clients have this problem.Any suggestions greatly appreciated." |
|
|
efelito
Constraint Violating Yak Guru
478 Posts |
Posted - 2002-06-10 : 10:42:34
|
| Haven't come across this problem, but a little more info might shed some light on the problem.How are you dumping the database? Are you using a custom backup script or a database maintenance plan? Are you backing up to Tape, local disk, or remote disk?Jeff BanschbachConsultant, MCDBA |
 |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2002-06-11 : 03:19:07
|
| also are there any oher processes trying to run at the same time on their box? I have had this kind of trouble where I was told nothing else had been scheduled, and the company actually had about three or four other processes trying to run on that server at the same time... Worth checking..PeaceRick |
|
|
|
|
|
|
SQL Backup trouble