Monthly Archives: November 2011

Download: Troubleshooting a day – Nov 2011

Posted on November 30, 2011 by

As I did for powershell a day Series Blog April 2011, consolidated the all months blog into one pdf file here. I have done this month as well, I Blog about Troubleshooting sql server issues -Errors , which we get during … Continue reading →

Posted in Troubleshooting | Tagged , | Leave a comment

Day 30: More Fatal Errors and BUGs

Posted on November 30, 2011 by

Day 30 More Fatal Errors and BUGs For sql server 2000 and earlier you may get 5242 and 5243 corruption in the record  structure(for sql server 2005 onwards you may get 824). Msg 5242, Level 22, State 1, Line 1 … Continue reading →

Posted in Bug, Troubleshooting | Tagged , | Leave a comment

Day 2: Log file grown high cannot shrink log file.(available size in – negative)

Posted on November 29, 2011 by

Description:- Yesterday, we discussed what happen when tempdb data file grown very high, now what if log file of any user database has grown high and occupying most of its space. Please see the great blog post to know about … Continue reading →

Posted in Transaction Log, Troubleshooting | Tagged , | Leave a comment

Day 29: Fatal Errors 823, 824, 825, 832, OS error 23

Posted on November 29, 2011 by

Day 29: Fatal Errors 823, 824, 825, 832, OS error 23 Error 823: IO error OS cannot read the data Error: 823, Severity: 24, State: 2. The operating system returned error 21(The device is not ready.) to SQL Server during … Continue reading →

Posted in Troubleshooting | Tagged | 1 Comment

Day 28: Linked server errors

Posted on November 28, 2011 by

This post was published to Vinay Thakur – Sql Server DBA at 5:05:51 PM 11/25/2011             Day 28: Linked server errors Linked server is another good linking took where you can linked the server access the data from different … Continue reading →

Posted in Troubleshooting | Tagged | Leave a comment

Day 27: Log Shipping Errors

Posted on November 27, 2011 by

Day 27: Log Shipping Errors Log shipping is another tool for High availability it will generally have primary and secondary server, Full Backup restores at both location and then Tlog backups will copied to secondary server and restore. The step … Continue reading →

Posted in High Avaliability, Troubleshooting | Tagged , | 1 Comment

Day 26: Replication Errors

Posted on November 27, 2011 by

Day 26: Replication Errors Replication is one of my favorite topic, I worked on Transaction Replication, and Blogged about it here. Replication is possible from higher version to lower version. configure replication… remember to configure from higher version to lower … Continue reading →

Posted in Replication, Troubleshooting | Tagged , | Leave a comment

Day 25: General Transact sql script errors

Posted on November 25, 2011 by

        Day 25: General Transact sql script errors You can create only one identity column in a table. create table errors (i int identity(1,1),j int identity(1,1))   Msg 2744, Level 16, State 2, Line 1 Multiple identity columns specified for table … Continue reading →

Posted in Others | Leave a comment

Day 24: Attach database errors

Posted on November 25, 2011 by

Day 24 Attach database errors “Microsoft recommend that you move databases by using the ALTER DATABASE planned relocation procedure, instead of using detach and attach. ALTER DATABASE (Transact-SQL). “ If you do not have permission to attached the database : … Continue reading →

Posted in Troubleshooting | Tagged , | Leave a comment

Day 23: Detach database Errors

Posted on November 25, 2011 by

Day 23: Detached Errors “Microsoft recommend that you move databases by using the ALTER DATABASE planned relocation procedure, instead of using detach and attach. ALTER DATABASE (Transact-SQL). “ “ We cannot detached system databases: Server: Msg 7940, Level 16, State … Continue reading →

Posted in Troubleshooting | Tagged | Leave a comment