SQL Backup causes Unexpected Shutdown

Question

Post reply

SQL Backup causes Unexpected Shutdown

Matt-202875

SSC Rookie

Points: 31
More actions
January 20, 2005 at 1:13 pm

#109128

I have a Windows Server 2003 box that has an Unexpected Shutdown approx 30 seconds before the SQL Backup job starts. (I have the job scheduled to run in Enterprise Manager.)
I am running SQL 2000 SP3a.

Anyone have any ideas of what would be causing this?

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Johan Bijnens SSC Guru Points: 135369 More actions · Answer 1

No Idea.

check :

- windows event logs

- sqlserver logs

- sqlagent logs

Johan

Learn to play, play to learn !

Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:

- How to post Performance Problems
- How to post data/code to get the best help[/url]

- How to prevent a sore throat after hours of presenting ppt

press F1 for solution, press shift+F1 for urgent solution 😀

Need a bit of Powershell? How about this

Who am I ? Sometimes this is me but most of the time this is me

SQLBill SSC Guru Points: 51440 More actions · Answer 2

Maybe it's something in your backup script or a script that runs just before your backup.

Does your script stop any services? (MSSQLServer and SQLServerAgent services need to be running).

Is your database set to Auto Close? If so, it could be the connection is being closed prior to the backup.

-SQLBill

Matt-202875 SSC Rookie Points: 31 More actions · Answer 3

We're not using a script.

I just used the "Backup Database" wizard in Enterprise manager.

Not sure if our database is set to Auto Close...how could I check that?

It's really weird, the server shuts down every time appox 30 seconds before the database is scheduled to run.

-matt

Angela But Hall of Fame Points: 3848 More actions · Answer 4

You can check auto close by running sp_helpdb from Query Analyser or by looking at the properties of the database from Enterprise Manager.

Are you sure there is nothing in the SQL & OS logs?

Are you able to run a backup manually?

Antares686 SSC Guru Points: 125444 More actions · Answer 5

Check the logs as suggested first, could be an error is blowing out the system and if you can duplicate the issue yo can pinpoint what is happening right before it all goes down. You should also have a dump file created by this so check for that.

Matt-202875 SSC Rookie Points: 31 More actions · Answer 6

Acutally I think I found the problem

We have Veritas Backup Exec remote agent installed, with Open File Option installed.

Once in un-installed the Open File Option, the shutdowns stoped.

This seems to have fixed the problem.

Thanks for all your help though.