Start with Why: How Great Leaders Inspire Everyone to Take Action
Advertisements
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
