348 reputation
112
bio website
location Toronto, Canada
age
visits member for 2 years, 7 months
seen Mar 31 at 20:46

SQL Server 2005/2008/2012


1d
awarded  Popular Question
Mar
11
comment How to deny database acess to windows autentication users
Can you remove windows authentication from your SQL server, and just have 1 local account on it? (not 'sa', anything but that)
Feb
26
awarded  Popular Question
Feb
5
comment Should I pause Mirroring and stop SQL Server services before running windows updates?
Right, I'm confusing myself with this scenario: sqlblog.com/blogs/tibor_karaszi/archive/2010/04/16/…
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