Operating System Error 999

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 7,2000 » Backups » Operating System Error 999

Operating System Error 999

Rate Topic

Display Mode

Topic Options

Author

Message

JohnnyDBA

Posted Saturday, June 27, 2009 8:31 AM

Old Hand

Group: General Forum Members
Last Login: Wednesday, June 12, 2013 2:34 PM
Points: 334, Visits: 708

We have a customer that uses a snap server as storage for their SQL Server 2000 databases. Lately we've been getting issues creating the backups, especially on two of the very large databases (450 GB and 500 GB).

The error that I see (among others) is the following:

Operating system error 999(Error performing inpage operation.)

I haven't been able to find much explanation online regarding this error. The only two possibilities I've found are
1) Not enough disk space - I don't think this is the issue, it looks like there is plenty of space
2) Bad blocks on the drive - I don't know how to verify this.

Please advise.

John

Post #743121

Steve Jones - SSC Editor

Posted Monday, June 29, 2009 7:52 PM

SSC-Dedicated

Group: Administrators
Last Login: Today @ 5:09 AM
Points: 31,526, Visits: 13,864

I don't know what a snap server does, but I can think of two things. The bad block you've mentioned, and you'd need vendor tools to check this at a low level on the disk.

The second is possibly the snap server is locking or moving a page as SQL Server is trying to read or write it and it's causing an error. The backup process isn't very tolerant of any interruptions.

Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help

Post #744112

skersey3

Posted Tuesday, June 30, 2009 7:47 AM

Forum Newbie

Group: General Forum Members
Last Login: Friday, July 10, 2009 8:01 AM
Points: 4, Visits: 10

I have had issues with older snap server models doing the same thing. And I am going to assume that these are not Windows Based models. I ended up sending them emails and they gave me the codes and instructions on how to check and fix bad sectors. Make sure that you have good backups bc if it does not work or if it does your data my end up corrupted. Also these models tend to go out after about 4 years in my experience so check the age and maybe look for something new.

Post #744416

Nice Marmot

Posted Tuesday, June 30, 2009 9:47 AM

Old Hand

Group: General Forum Members
Last Login: Friday, May 24, 2013 8:58 AM
Points: 394, Visits: 630

Hi,

A SNAP Server is a NAS device http://www.snapappliance.com/. We store backups on ours.

Is SQL Server happy to have databases on mapped drives? I had always assumed that database files had to be on a local drive, but a quick scan through BOL doesn't turn up any mention of local versus mapped drives.

The NAS will have a management page at http://_hostname_/ - the 'admin' user should have a password on it. w00t

HTH.

Edit: fixed link formatting.

Post #744558

Steve Jones - SSC Editor

Posted Tuesday, June 30, 2009 5:06 PM

SSC-Dedicated

Group: Administrators
Last Login: Today @ 5:09 AM
Points: 31,526, Visits: 13,864

By default SQL Server does not allow databases on mapped drives. You can get around this, but it is not recommended. The reason is that network IO can have latencies and cause issues.

Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help

Post #744991

JohnnyDBA

Posted Tuesday, June 30, 2009 8:14 PM

Old Hand

Group: General Forum Members
Last Login: Wednesday, June 12, 2013 2:34 PM
Points: 334, Visits: 708

It's not housing the data files, just the backups. All of the errors are related to creation of backup files and restores (for log shipping).

Post #745026

Nice Marmot

Posted Wednesday, July 01, 2009 2:43 AM

Old Hand

Group: General Forum Members
Last Login: Friday, May 24, 2013 8:58 AM
Points: 394, Visits: 630

Sorry for picking you up wrongly about the type of files you are storing on the NAS. All I can suggest is using the device's home page: Administration -> Monoitoring -> Event Log. (The site layout may differ depending on your model.) As 'skersey3' said, these do seem to have a finite life - we have 2, and our older one seems to be on its way out. Good NASes, though. Smile

HTH.

Edit: Thanks for the info, Steve.

Post #745174

JohnnyDBA

Posted Wednesday, July 01, 2009 6:43 AM

Old Hand

Group: General Forum Members
Last Login: Wednesday, June 12, 2013 2:34 PM
Points: 334, Visits: 708

Thanks for all the input guys, I'll work with the customer and see what we can figure out.

- John

Post #745304

Nalini D

Posted Monday, February 27, 2012 12:59 PM

Forum Newbie

Group: General Forum Members
Last Login: Friday, August 31, 2012 3:20 PM
Points: 6, Visits: 21

Hi,

Even we ahve same issues on taking backups on DataDomain from EMC (Similar to SanpServer from Netapp). Did you find any solution to this?

Post #1258481

« Prev Topic | Next Topic »

Permissions