InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 21 May 2013 21:54:08 GMT20http://www.sqlservercentral.com/Forums/Topic743121-24-1.aspxHi,Even we ahve same issues on taking backups on DataDomain from EMC (Similar to SanpServer from Netapp). Did you find any solution to this?Mon, 27 Feb 2012 12:59:35 GMTNalini Dhttp://www.sqlservercentral.com/Forums/Topic743121-24-1.aspxThanks for all the input guys, I'll work with the customer and see what we can figure out.- JohnWed, 01 Jul 2009 06:43:47 GMTJohnnyDBAhttp://www.sqlservercentral.com/Forums/Topic743121-24-1.aspxSorry 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.Wed, 01 Jul 2009 02:43:56 GMTNice Marmothttp://www.sqlservercentral.com/Forums/Topic743121-24-1.aspxIt'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).Tue, 30 Jun 2009 20:14:37 GMTJohnnyDBAhttp://www.sqlservercentral.com/Forums/Topic743121-24-1.aspxBy 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.Tue, 30 Jun 2009 17:06:14 GMTSteve Jones - SSC Editorhttp://www.sqlservercentral.com/Forums/Topic743121-24-1.aspxHi,A SNAP Server is a NAS device [url=http://www.snapappliance.com/]http://www.snapappliance.com/[/url]. 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.Tue, 30 Jun 2009 09:47:17 GMTNice Marmothttp://www.sqlservercentral.com/Forums/Topic743121-24-1.aspxI 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. Tue, 30 Jun 2009 07:47:58 GMTskersey3http://www.sqlservercentral.com/Forums/Topic743121-24-1.aspxI 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.Mon, 29 Jun 2009 19:52:42 GMTSteve Jones - SSC Editorhttp://www.sqlservercentral.com/Forums/Topic743121-24-1.aspxWe 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:[quote]Operating system error 999(Error performing inpage operation.)[/quote]I haven't been able to find much explanation online regarding this error. The only two possibilities I've found are1) Not enough disk space - I don't think this is the issue, it looks like there is plenty of space2) Bad blocks on the drive - I don't know how to verify this.Please advise.JohnSat, 27 Jun 2009 08:31:47 GMTJohnnyDBA