Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Operating System Error 999 Expand / Collapse
Author
Message
Posted Saturday, June 27, 2009 8:31 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Yesterday @ 11:54 AM
Points: 340, Visits: 799
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
Posted Monday, June 29, 2009 7:52 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Yesterday @ 12:57 PM
Points: 33,206, Visits: 15,361
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
Posted Tuesday, June 30, 2009 7:47 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum 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
Posted Tuesday, June 30, 2009 9:47 AM


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Yesterday @ 9:27 AM
Points: 472, Visits: 707
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.

HTH.

Edit: fixed link formatting.
Post #744558
Posted Tuesday, June 30, 2009 5:06 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Yesterday @ 12:57 PM
Points: 33,206, Visits: 15,361
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
Posted Tuesday, June 30, 2009 8:14 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Yesterday @ 11:54 AM
Points: 340, Visits: 799
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
Posted Wednesday, July 1, 2009 2:43 AM


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Yesterday @ 9:27 AM
Points: 472, Visits: 707
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.

HTH.

Edit: Thanks for the info, Steve.
Post #745174
Posted Wednesday, July 1, 2009 6:43 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Yesterday @ 11:54 AM
Points: 340, Visits: 799
Thanks for all the input guys, I'll work with the customer and see what we can figure out.

- John
Post #745304
Posted Monday, February 27, 2012 12:59 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, August 26, 2014 3:24 PM
Points: 8, Visits: 42
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 »

Add to briefcase

Permissions Expand / Collapse