Viewing 15 posts - 46 through 60 (of 213 total)
With regards to mirroring:
High Availability is "synched writes". The user's change is written to the primary server. The primary notifies the secondary. The secondary also does the...
Student of SQL and Golf, Master of Neither
November 24, 2008 at 8:32 am
Paresh: Your cut and paste was in reference to High Avail style mirroring
Perry: You were talking about automatic failover.
Don't do either one with a normal internet type connection!
My...
Student of SQL and Golf, Master of Neither
November 21, 2008 at 8:09 am
Paresh Prajapati (11/21/2008)
My both server are located in individual location (in in usa and other in Hongkong).so mirroring wirh sync mode will be time consuming to commit in partner server...
Which...
Student of SQL and Golf, Master of Neither
November 21, 2008 at 7:24 am
What really matters here is: What is the purpose? How busy is the primary database? How much bandwidth are you willing to pay for? My following...
Student of SQL and Golf, Master of Neither
November 20, 2008 at 7:43 am
I've often wondered (but not hard enough to actually lift my fingers and go reading on my own) if doing a backup, drop DB, restore sequence gave you a completely...
Student of SQL and Golf, Master of Neither
November 18, 2008 at 8:01 am
anam (11/17/2008)
Now i am looking after any technique which will help me in changing the recovery state of the database till i get extra disk on my server for...
Student of SQL and Golf, Master of Neither
November 18, 2008 at 7:57 am
To move a database from one server to another, and setup for mirroring, I have done this successfully:
On Server A (was main, will be the mirror):
Run full backup
Run tail of...
Student of SQL and Golf, Master of Neither
November 17, 2008 at 6:44 am
Absolute? Make backups. Verify Backups. Keep Backups safe.
Oh yeah, test Backups.
Student of SQL and Golf, Master of Neither
October 24, 2008 at 8:24 am
Seldom is the answer "never do it this way". It often "depends".
We host a "stock exchange" server for our customers. They trade a lot of documents and data...
Student of SQL and Golf, Master of Neither
August 12, 2008 at 7:52 am
I don't think separate or same channels on the same card will make much difference, it's getting them on separate drive groups that matters. The more separate drive spindles...
Student of SQL and Golf, Master of Neither
July 31, 2008 at 12:03 pm
Ryan (7/24/2008)
2. I also found that the anti-virus software was scanning the logs directory so I've excluded it, at least for now.
My guess is both were excellent choices, but the...
Student of SQL and Golf, Master of Neither
July 24, 2008 at 6:37 am
I'll be the one to ask the idiot question:
When is it advantageous to use a table variable? Since I started in Version 7, when they didn't exist, I just...
Student of SQL and Golf, Master of Neither
July 17, 2008 at 6:38 am
Why wouldn't you simply detach the database, then attach it back with the single file option? Sorry, I'm in a hurry this morning, but I'm almost certain I've moved...
Student of SQL and Golf, Master of Neither
July 14, 2008 at 6:38 am
Pet Peeve: I hate it when someone writes an article (even someone whom I greatly respect) and uses an acronym that (in my world at least) is not exactly...
Student of SQL and Golf, Master of Neither
April 22, 2008 at 6:17 am
Wait, I found it on urban dictionary, and now I hate it more. I mean, who wants to be "dorky"?
Something that has adequate or better performance. Combination of "Performance"...
Student of SQL and Golf, Master of Neither
April 5, 2008 at 1:54 pm
Viewing 15 posts - 46 through 60 (of 213 total)