meta user
network profile
| bio | website | |
|---|---|---|
| location | Toronto, Canada | |
| age | ||
| visits | member for | 1 year, 8 months |
| seen | May 15 at 17:49 | |
| stats | profile views | 13 |
SQL Server 2005/2008/2012
|
May 15 |
comment |
SQL Server 2012 - Missing or lost transaction and no errors to show what went wrong I will have to use ApexSQL tool to read the log, because it is a specific table that has inserts on it daily. I must search the log for a specific ID that would have been on the 2 records that were supposed to be inserted. I don't think something this specific can be found using db_dump_dblog/fn_dblog. I'll update this Question for sure once the log shows if it even contains those 2 records & what happened to them! |
|
May 15 |
comment |
SQL Server 2012 - Missing or lost transaction and no errors to show what went wrong I will say though, it's a SQL Server issue not application. I am fairly confident about this. |
|
May 15 |
comment |
SQL Server 2012 - Missing or lost transaction and no errors to show what went wrong @mrdenny Agreed. Just a DBA/Sysadmin here and do not know application errors specifically. I know that the application has not changed for a very long time & it's a new issue. |
|
May 15 |
comment |
SQL Server 2012 - Missing or lost transaction and no errors to show what went wrong @Kin Yes! That is the plan regarding finding missing transactions but I want to read the log simply to confirm what transpired. (If it was a rollback or they are entirely missed) I do not want a repeat of this occurrence. |
|
May 15 |
comment |
SQL Server 2012 - Missing or lost transaction and no errors to show what went wrong "SQL Server didn't just loose the transactions." this is the crux of the issue! The portion of application that inserts these transactions has not changed in over year if not longer. It is also inserting via stored procedure and noone can delete transactions in this database. I feel. SQL Server rolled them back after issuing OK return code to the application due to its own timeout issues, and didn't log an error but I cannot prove this....it is worst case scenario too. As it means it will happen again. Which is unacceptable for this instance. |
|
May 14 |
comment |
SQL Server 2012 - Missing or lost transaction and no errors to show what went wrong Similar issue I have found: dbforums.com/microsoft-sql-server/… - I wonder how to find this Rollback transaction to get the data that was lost. |
|
Jan 23 |
comment |
Cannot remove Mirroring / nor restore or delete database:Error 3456 (SQL Server 2012) Will do thanks! This was a virtual machine that I shut down, FYI |
|
Jan 22 |
comment |
Cannot remove Mirroring / nor restore or delete database:Error 3456 (SQL Server 2012) Also Remus, this is why I could not update the database. |
|
Jan 22 |
comment |
Cannot remove Mirroring / nor restore or delete database:Error 3456 (SQL Server 2012) Yes this is what I had to do. Luckily the Primary was not corrupted. The mirroring is Asynchronous so - well I am still confused why the corruption happened in the first place! |
|
Jan 21 |
comment |
Cannot remove Mirroring / nor restore or delete database:Error 3456 (SQL Server 2012) Nothing at all coming up under all Broker events for Mirror and for Principal. |
|
Jan 21 |
comment |
Cannot remove Mirroring / nor restore or delete database:Error 3456 (SQL Server 2012) Cool! I will try it, but note, I already disabled Mirroring for this database on the Principal. So it should not be showing errors on Principal. It's the Mirror Database that got stuck with error and is not accepting any kind of changes including ALTER SET PARTNER OFF. |
|
Jan 21 |
comment |
Cannot remove Mirroring / nor restore or delete database:Error 3456 (SQL Server 2012) Because there is a live database on Principal - I worry this is not a good approach. I definitely do not want it to corrupt the other database. I really just want to drop this corrupted one... :) My plan right now is to shut down the Mirror SQL Service and rename the MDF/LDF files & basically steal them from under its nose. I hope that doesn't corrupt the SQL Server instance itself. |
|
Jan 21 |
comment |
Cannot remove Mirroring / nor restore or delete database:Error 3456 (SQL Server 2012) Hi mrdenny, for a period of short time the Mirror could not reach the Principal (I had to shut it down to physically change LAN connection but the LAN had no connectivity when I restarted the machine and this is when this happened). Right now it can reach the Principal and there are multiple databases with this Principal that are working fine with mirroring. Just this one database was not able to resume mirroring. If I run this - will it disrupt the other databases? Thanks! |
|
Jan 7 |
comment |
Moving rows from one table to another Yes, that is what I meant. Thanks, I see your point. |
|
Jan 4 |
comment |
Moving rows from one table to another None of the above. I suppose I could go that route, I like code minimalism. I just do not want to lose records if the insert fails for any reason. (ie: table locking, timeouts, etc) Thank you! |
|
Oct 4 |
comment |
Can I replicate to a pre-existing database? Agreed, also found instructions from MSDN: msdn.microsoft.com/en-us/library/ms151705.aspx |
|
Oct 1 |
comment |
Can I replicate to a pre-existing database? The same thing! But. It's SQL 2012 and the old server is 2005. |
|
Sep 28 |
comment |
Should I rely on Database Engine Tuning Advisor for creating indexes? The reason DMVs are not particularly useful is because I am trying to think of Indexes for brand new tables. |
|
Sep 28 |
comment |
Should I rely on Database Engine Tuning Advisor for creating indexes? Yes SQL Server 2012. Sorry I should have been more specific. |
|
Sep 16 |
comment |
Alternatives to AdeptSQL Diff (for MS SQL Server 2012) Ah sorry! I read Adept instead of Apex. Apologies. |
