Viewing 15 posts - 6,841 through 6,855 (of 9,244 total)
jprovines
please execute the following against the primary server
use master
exec sp_help_log_shipping_primary_database @database = 'yourdb'
and this against the secondary
use master
exec sp_help_log_shipping_secondary_database @secondary_database = 'yourdb'
Post the results for both these!
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 14, 2011 at 3:34 am
Thank you all for your feedback. I created this article as to me it seems the DBA is always an afterthought in most organisations.
"oh he\she only looks after the...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 12, 2011 at 10:05 am
ss-457805 (8/12/2011)
great articles Perry. Have added to my favourites :-). Keep up the good work.
thank you, i appreciate your feedback
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 12, 2011 at 3:35 am
Thank you, combine all 3 parts and you have all you need to create a cluster testbed from scratch
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 12, 2011 at 12:56 am
please execute the following against your log shipped secondary database and post back the results
exec sp_help_log_shipping_secondary_database @secondary_database = 'secondary_database'
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 10, 2011 at 10:04 am
Execute the script below against your production database server under the context of the database for which you wish to export users and the resulting script output will form the...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 8, 2011 at 1:58 pm
Ninja's_RGR'us (8/6/2011)
Perry Whittle (8/6/2011)
Ninja's_RGR'us (8/5/2011)
I say "then" because between all 5 of us we probably close 100-150 threads / day and we pretty much cover 24 / 7.
You...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 8, 2011 at 12:23 pm
Ninja's_RGR'us (8/5/2011)
I say "then" because between all 5 of us we probably close 100-150 threads / day and we pretty much cover 24 / 7.
You should be looking...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 6, 2011 at 8:04 am
Are you using MS iSCSI initiator?
If so do not use teaming for these NICs use the initiator policies for fail over or load balancing
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 6, 2011 at 5:56 am
You have added the LUNs as physical disks but not as cluster resources. Go into failover cluster manager and select add storage and add all new disks, you may then...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 6, 2011 at 5:51 am
classic example of how a transaction log can experience runaway growth when the database is in Simple recovery mode!
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 4, 2011 at 6:59 am
the backup drive must be a dependency on the clustered sql server resource. If the disk dies replace it or temporarily remove the dependency.
The loss of one disk shouldn't cause...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 4, 2011 at 6:55 am
Jonathan Marshall (8/3/2011)
The databases on the secondary server to not have to be in a read state but requirements could change of course.
🙂 tell me about it
Jonathan Marshall (8/3/2011)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 3, 2011 at 11:58 am
Just because the networks have high latency doesn't rule out mirroring, you can adjust the failover timeout quite easily. You will need some trial and error to find the ideal...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 3, 2011 at 5:58 am
Marios Philippopoulos (7/22/2011)
All I...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 23, 2011 at 6:55 am
Viewing 15 posts - 6,841 through 6,855 (of 9,244 total)