Computing.Net > Forums > Windows NT > reboots when SQL backup starts

Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.

reboots when SQL backup starts

Reply to Message Icon

Name: captainmorgan
Date: May 18, 2004 at 13:20:51 Pacific
OS: Windows NT 4.0
CPU/Ram: Pentium III, 450mhz / 512
Comment:

Windows NT Server reboots when SQL does a Transaction Log Backup and the Backup fails.I get the following Error message:
---------------
Microsoft SQL-DMO (ODBC SQLState: 42000)

The Microsoft Tape Format (MTF) soft filemark database on backup device 'N:\NewClient\NewClient_tlog_200405171516.TRN' cannot be read, inhibiting random access.
Backup or restore operation terminating abnormally.
----------------
Any information on this would be greatly appreciated.



Sponsored Link
Ads by Google

Response Number 1
Name: wanderer
Date: May 18, 2004 at 17:55:42 Pacific
Reply:

Have you looked at the stored backup procedure to make sure reboot the server is not enabled?

You're doing a transaction log backup to tape?? That is a bit odd. Should be to file. You can always backup the logs with regular tape backup.


0

Response Number 2
Name: captainmorgan
Date: May 19, 2004 at 10:11:08 Pacific
Reply:

As far as I know I am not using a Stored Procedure for backup purposes. I am using a Database Maintainance Plan, the jobs are under SQL Server Agent and I can not see anywhere where you can enable or disable reboot the server.

The server is rebooting on its own whenever I try to do a Full Database Backup, a Differential Backup or a Transaction Log Backup and the backup fails with the Error Message:
----------------
SQL-DMO (ODBC SQLState: 42000)
---------------
The Microsoft Tape Format (MTF) soft filemark database on backup device 'N:\NewClient\NewClient_tlog_200405171516.TRN' cannot be read, inhibiting random access.
Backup or restore operation terminating abnormally.
----------------

No I am not doing a transaction log backup to tape it is to file: 'N:\NewClient\NewClient_tlog_200405171516.TRN'. But I do a Full Backup ever night to tape.

Any information on this would be greatly appreciated.



0

Response Number 3
Name: wanderer
Date: May 19, 2004 at 11:26:50 Pacific
Reply:

Let's start with some basics.

When was the last time the drives were defragged? It is the first place to look when you have file writing issues.

In the maintenance plan are you running optimization?

Are you backing up master, msdb and your database? You need all three to restore your database.

I did find this
http://support.microsoft.com/default.aspx?scid=kb;en-us;290622&Product=sql

One of the first things I do is reapply the service pack for SQL. I have had it correct issues.


0

Response Number 4
Name: captainmorgan
Date: May 27, 2004 at 05:37:32 Pacific
Reply:

Thank you everybody for your responses to my problem. The problem has been corrected, it ended up being a BAD MOTHERBOARD. Some of the capacitors were leaking and corroded. Thanks again.


0

Sponsored Link
Ads by Google
Reply to Message Icon

Related Posts

See More







Post Locked

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.


Go to Windows NT Forum Home


Sponsored links

Ads by Google


Results for: reboots when SQL backup starts

sql backup www.computing.net/answers/windows-nt/sql-backup/7846.html

Tape backup error www.computing.net/answers/windows-nt/tape-backup-error-/22155.html

NT 4.0 Server Backup (Tape) www.computing.net/answers/windows-nt/nt-40-server-backup-tape-/14937.html