Search my blog
-
-
Recent Posts
- Reading list for the week – 24/10/11
- Reading list for the week – 17/10/11
- Reading list for the week – 10/10/11
- Reading list for the week – 03/10/11
- Reading list for the week – 26/09/11
- MSP Error: 29528 The setup has encountered an unexpected error while Setting reporting service exclusion path
- Reading list for the week – 19/09/11
Page Views
208,411-
Popular Posts
- How the Cannot generate SSPI context error was fixed
- Find the SQL Server Instance name using Task Manager
- Server is in script upgrade mode. Only administrator can connect at this time
- Script to check database user permissions
- Cannot create an instance of OLE DB provider ‘OraOLEDB.Oracle’ for linked server
Archives
Tags
backup configure data corruption data file hardware hotfix index internals locks maintenance plan performance PradeepAdiga restore RLFTW scripts security services setup sql 2000 sql 2005 sql 2008 sql 2012 sql agent ssis system databases tips and tricks tools Top Posts trace transaction log troubleshoot windows
Tag Archives: data file
I/O error 21(The device is not ready.) on an ONLINE database
Sunday late night, I got a call stating that one of the warehouse databases was throwing this error while the Application job was running. “Microsoft OLE DB Provider for SQL Server: I/O error 21(The device is not ready.) detected during … Continue reading
Posted in SQLServerPedia Syndication, Troubleshoot
Tagged data file, troubleshoot, windows
Leave a comment
File cannot be shrunk as it is either being shrunk by another process or is empty
On Monday on one of the Production Instances we had a High Severity Incident. The problem was that a database which never exceeded 40 GB in size had started growing at a rate of ~10 GB per hour! This database … Continue reading
RSS
Email
Twitter
Ovi App
LinkedIn
FourSquare