393 reputation
418
bio website
location Toronto, Canada
age
visits member for 3 years, 3 months
seen Dec 9 at 20:49

SQL Server 2005/2008/2012


Feb
5
accepted Should I pause Mirroring and stop SQL Server services before running windows updates?
Feb
5
comment Should I pause Mirroring and stop SQL Server services before running windows updates?
I thought if Witness and Mirror are unavailable, Principal will refuse all transactions?
Feb
4
asked Should I pause Mirroring and stop SQL Server services before running windows updates?
Jan
3
awarded  Popular Question
Jul
15
awarded  Popular Question
Jun
10
comment Missing or lost transaction and no errors to show what went wrong
Quick update: We were able to review log using Apex software, however, because we do nightly Full Backup and then afterwards t-log backup, the log was empty. I am investigating ways of preventing this issue. There was a similar t-log truncation question on DBA exchange for anyone interested: dba.stackexchange.com/questions/40666/…
Jun
10
comment Preferred Methods of copying a new database from Development to Production
Thank you! (Just a side note: RedGate prepares scripts and it does the version control for me as well--though I am still fine tuning that).
Jun
10
asked Preferred Methods of copying a new database from Development to Production
May
15
comment 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 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 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 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 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 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.
May
14
asked Missing or lost transaction and no errors to show what went wrong
May
9
revised SQL Server Browser uses NT AUTHORITY\SYSTEM account and logon failure error in SQL Log
edited body
May
9
asked SQL Server Browser uses NT AUTHORITY\SYSTEM account and logon failure error in SQL Log
Apr
24
accepted Cannot remove Mirroring / nor restore or delete database:Error 3456 (SQL Server 2012)
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.