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

SQL Server 2005/2008/2012


Sep
12
comment Mirroring failed over - created 2 principal database and will not allow me to drop one of them
Yes - at which point the database for which I removed mirroring entered "principal, disonnected" state, this one I attempted to delete and failed. Another database in similar situation (for which I did not try to remove mirroring) reverted to being mirror, synchronized instead.
Sep
12
comment Mirroring failed over - created 2 principal database and will not allow me to drop one of them
Sadly I just solved this problem with a reboot of the server. The databases became Mirror/Synchronized after reboot. Sigh...though I'm glad it's fixed, it's not the solution I was hoping for
Aug
15
comment PostgreSQL Slave has more files in pg_xlog than /wal_archive
I think the slave complaining it couldn't find the 00000001000000000000001C file is actually just part of pg_standby as the slave server is not accepting connections and overall infinitely checking for the latest file to be sent to it. I thought this was an error but likely it was not.
Aug
15
comment PostgreSQL Slave has more files in pg_xlog than /wal_archive
@Craig standby.log was never created or at least nowhere to be found. Ultimately, after various attempts to fix situation above because of failures to start the server, I (you may shudder) deleted the /var/lib/postgresql/9.3/main folder contents on the slave (as much as ubuntu would allow me to delete). Performed base backup on the master and rsynced the contents of /var/lib/postgresql/9.3/main over to the slave. I wonder if the large quantity of log files on Standby were just a side effect of streaming replication. I see in your answer you more or less agree that base backup was needed :)
Aug
14
comment PostgreSQL streaming versus file-based replication (In terms of server behavior & configuration)
Very helpful, I am wondering if you think this article: blogs.amd.co.at/robe/2009/05/… is on topic with my question. I have been told "log shipping is more stable" and this article seems to share that opinion.
Jul
29
comment Missing the pg_ctl package in Postgres 9.3 installation
yes, this worked.
Jul
28
comment Missing the pg_ctl package in Postgres 9.3 installation
"The program 'pg_ctl' is currently not installed. To run 'pg_ctl' please ask your administrator to install the package 'postgres-xc'"
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
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
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?
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).
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.
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.