SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Operating System Error 999


Operating System Error 999

Author
Message
JohnnyDBA
JohnnyDBA
Say Hey Kid
Say Hey Kid (712 reputation)Say Hey Kid (712 reputation)Say Hey Kid (712 reputation)Say Hey Kid (712 reputation)Say Hey Kid (712 reputation)Say Hey Kid (712 reputation)Say Hey Kid (712 reputation)Say Hey Kid (712 reputation)

Group: General Forum Members
Points: 712 Visits: 897
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
Steve Jones
Steve Jones
SSC Guru
SSC Guru (63K reputation)SSC Guru (63K reputation)SSC Guru (63K reputation)SSC Guru (63K reputation)SSC Guru (63K reputation)SSC Guru (63K reputation)SSC Guru (63K reputation)SSC Guru (63K reputation)

Group: Administrators
Points: 63081 Visits: 19113
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
My Blog: www.voiceofthedba.com
skersey3
skersey3
Grasshopper
Grasshopper (10 reputation)Grasshopper (10 reputation)Grasshopper (10 reputation)Grasshopper (10 reputation)Grasshopper (10 reputation)Grasshopper (10 reputation)Grasshopper (10 reputation)Grasshopper (10 reputation)

Group: General Forum Members
Points: 10 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.
Nice Marmot
Nice Marmot
Mr or Mrs. 500
Mr or Mrs. 500 (575 reputation)Mr or Mrs. 500 (575 reputation)Mr or Mrs. 500 (575 reputation)Mr or Mrs. 500 (575 reputation)Mr or Mrs. 500 (575 reputation)Mr or Mrs. 500 (575 reputation)Mr or Mrs. 500 (575 reputation)Mr or Mrs. 500 (575 reputation)

Group: General Forum Members
Points: 575 Visits: 767
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.
Steve Jones
Steve Jones
SSC Guru
SSC Guru (63K reputation)SSC Guru (63K reputation)SSC Guru (63K reputation)SSC Guru (63K reputation)SSC Guru (63K reputation)SSC Guru (63K reputation)SSC Guru (63K reputation)SSC Guru (63K reputation)

Group: Administrators
Points: 63081 Visits: 19113
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
My Blog: www.voiceofthedba.com
JohnnyDBA
JohnnyDBA
Say Hey Kid
Say Hey Kid (712 reputation)Say Hey Kid (712 reputation)Say Hey Kid (712 reputation)Say Hey Kid (712 reputation)Say Hey Kid (712 reputation)Say Hey Kid (712 reputation)Say Hey Kid (712 reputation)Say Hey Kid (712 reputation)

Group: General Forum Members
Points: 712 Visits: 897
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).
Nice Marmot
Nice Marmot
Mr or Mrs. 500
Mr or Mrs. 500 (575 reputation)Mr or Mrs. 500 (575 reputation)Mr or Mrs. 500 (575 reputation)Mr or Mrs. 500 (575 reputation)Mr or Mrs. 500 (575 reputation)Mr or Mrs. 500 (575 reputation)Mr or Mrs. 500 (575 reputation)Mr or Mrs. 500 (575 reputation)

Group: General Forum Members
Points: 575 Visits: 767
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.
JohnnyDBA
JohnnyDBA
Say Hey Kid
Say Hey Kid (712 reputation)Say Hey Kid (712 reputation)Say Hey Kid (712 reputation)Say Hey Kid (712 reputation)Say Hey Kid (712 reputation)Say Hey Kid (712 reputation)Say Hey Kid (712 reputation)Say Hey Kid (712 reputation)

Group: General Forum Members
Points: 712 Visits: 897
Thanks for all the input guys, I'll work with the customer and see what we can figure out.

- John
Nalini D
Nalini D
Grasshopper
Grasshopper (24 reputation)Grasshopper (24 reputation)Grasshopper (24 reputation)Grasshopper (24 reputation)Grasshopper (24 reputation)Grasshopper (24 reputation)Grasshopper (24 reputation)Grasshopper (24 reputation)

Group: General Forum Members
Points: 24 Visits: 43
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?
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search