-
Archives
- August 2017
- May 2017
- April 2017
- March 2017
- February 2017
- October 2016
- September 2016
- May 2016
- April 2016
- January 2016
- December 2015
- July 2015
- May 2015
- December 2014
- February 2014
- October 2013
- June 2013
- May 2013
- January 2013
- October 2012
- September 2012
- August 2012
- July 2012
- June 2012
- May 2012
- April 2012
- March 2012
- February 2012
- January 2012
- December 2011
- November 2011
- October 2011
- September 2011
- August 2011
- July 2011
- June 2011
- May 2011
- April 2011
- March 2011
- January 2011
- November 2010
- October 2010
- September 2010
- August 2010
- June 2010
- May 2010
- April 2010
- January 2010
- December 2009
- November 2009
- October 2009
- September 2009
- August 2009
- July 2009
- June 2009
- May 2009
- March 2009
- September 2008
- August 2008
- July 2008
-
Meta
Monthly Archives: November 2011
Download: Troubleshooting a day – Nov 2011
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
Day 30: More Fatal Errors and BUGs
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
Day 2: Log file grown high cannot shrink log file.(available size in – negative)
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
Day 29: Fatal Errors 823, 824, 825, 832, OS error 23
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
Day 28: Linked server errors
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
Day 27: Log Shipping Errors
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
Day 26: Replication Errors
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
Day 25: General Transact sql script errors
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
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
Day 23: Detach database Errors
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
