meta user
network profile
| bio | website | rachel53461.wordpress.com |
|---|---|---|
| location | New York, United States | |
| age | 27 | |
| visits | member for | 1 year, 4 months |
| seen | May 20 at 20:03 | |
| stats | profile views | 373 |
I'm a programmer, not a DBA! Tell them to stop making me figure out and perform the job of a DBA, and I'll stop harassing your site with questions :)
|
1d |
awarded | Good Question |
|
2d |
awarded | Popular Question |
|
May 20 |
awarded | Constituent |
|
May 19 |
awarded | Notable Question |
|
May 15 |
awarded | Notable Question |
|
May 13 |
awarded | Caucus |
|
May 10 |
accepted | If I fail over one database, do the others that share the same mirror endpoint fail over as well? |
|
May 10 |
revised |
If I fail over one database, do the others that share the same mirror endpoint fail over as well? I would like to include the actual answer to my question in this answer (instead of only implying it) so that I can accept it as the best answer to my question. Also added some clarification about the t-sql failover script |
|
May 10 |
comment |
If I fail over one database, do the others that share the same mirror endpoint fail over as well? Thank you very much @Kin! I hope you don't mind, but I've suggested an edit to your answer to include the actual answer to my question so that I can accept your answer :) |
|
May 10 |
suggested | suggested edit on If I fail over one database, do the others that share the same mirror endpoint fail over as well? |
|
May 9 |
comment |
If I fail over one database, do the others that share the same mirror endpoint fail over as well? If I were to use T-SQL for doing a manual failover like you have in your answer, is there a T-SQL way of setting up the old principal database as the mirror? It doesn't look like I can manually put the old principal database in NORECOVERY mode to make it take over as the mirror, although the failover button from the database properties does do that automatically. |
|
May 9 |
comment |
If I fail over one database, do the others that share the same mirror endpoint fail over as well? Thank you @Kin, that was quite helpful :) |
|
May 9 |
comment |
If I fail over one database, do the others that share the same mirror endpoint fail over as well? Thank you very much. I thought that might have been the case, but I wanted to confirm it before testing, and was having problems finding anything definitive using Google. |
|
May 9 |
asked | If I fail over one database, do the others that share the same mirror endpoint fail over as well? |
|
May 9 |
accepted | How can I search the full text of a stored procedure for a value? |
|
May 8 |
comment |
How can I search the full text of a stored procedure for a value? @gbn Thanks, your answer, combined with Aaron's comment, made me think that there was some reason I should never use INFORMATION_SCHEMA for anything, but I see now you were only referring to the context of my question of searching procedure text :) |
|
May 8 |
comment |
How can I search the full text of a stored procedure for a value? @AaronBertrand Thanks for the link. To summarize, it sounds like INFORMATION_SCHEMA is an obsolete and incomplete list of sql objects left over from the SQL 2000 days, and you'd be better off using the newer replacements such as catalog views. From the way you and gbn referenced it, I was expecting something truly horrible to happen if I kept using it :) |
|
May 8 |
comment |
How can I search the full text of a stored procedure for a value? Thank you, it looks like sys.sql_modules will work for me. Can you expand on why you should never use INFORMATION_SCHEMA? |
|
May 8 |
asked | How can I search the full text of a stored procedure for a value? |
|
May 7 |
revised |
How can I query data from a linked server, and pass it parameters to filter by? added 551 characters in body |
