Viewing 15 posts - 6,811 through 6,825 (of 9,244 total)
needed to see details of the configuration this morning not after you switched to asynch
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 16, 2011 at 12:07 pm
n.heyen (8/16/2011)
Currently only 12GB of RAM and only 2GHz on 1CPU allocated for SQL, just not enough.
I would of thought the RAM is ok, definitely ramp up the CPU to...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 16, 2011 at 11:43 am
oops my bad, yes you need primary server too :blush:
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 16, 2011 at 11:40 am
please execute the following against the primary and post the results
select * from sys.database_mirroring
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 16, 2011 at 11:34 am
jpro1001 (8/16/2011)
and for the secondary server I would do this?exec sp_change_log_shipping_secondary_primary @database = 'MainDb',
@ file_retention_period = '8640'
😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 16, 2011 at 10:54 am
so are you running in High-Performance(asynchronous) or High-Protection(synchronous) mode?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 16, 2011 at 10:46 am
DBAgal (8/16/2011)
since the documentation I've found is somewhat vague.
When running in High availability mode Books Online is quite clear and quotes the following
Books Online
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 16, 2011 at 10:40 am
have you verified that the new disk resources you intend to use for the new instance online and offline properly through the cluster management console?
Also check the new IP address...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 16, 2011 at 10:30 am
jprovines (8/16/2011)
Is it safe to just manually update the backup_retention_period field?
That's exactly how you do it!
Use the following on the mirror\primary
exec sp_change_log_shipping_primary_database @database = 'YourDB',
@backup_retention_period = '8640'
Only change...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 16, 2011 at 10:27 am
I would swap to a Majority Node Set quorum and remove the disk drive dependency to allow the cluster to start
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 16, 2011 at 8:27 am
To add more CPU and RAM shutdown the virtual machine and then from the VMWare virtual infrastructure client edit the VM settings. Increase the CPU and RAM and then restart...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 16, 2011 at 8:20 am
Please execute the following against the sql server instance and post back the results
selectst.text,
start_time,
DATEADD(ms,estimated_completion_time,
GETDATE()) AS EstimatedEndTime,
percent_complete,
((estimated_completion_time / 1000) / 60) as EstCominMins,
((total_elapsed_time / 1000) /...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 16, 2011 at 4:16 am
jprovines (8/15/2011)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 16, 2011 at 4:04 am
I would expect this to be purged after 2 days
backup_destination_directory\\lap8ea03\TransactionLogShippingTemp
As this is set to 2 days
file_retention_period2880
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 15, 2011 at 4:31 pm
nmoore (8/15/2011)
Do you actually need the NAS element?
As I explain in the beginning of the article the whole point of the article is to give the reader experience in all...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 15, 2011 at 2:58 pm
Viewing 15 posts - 6,811 through 6,825 (of 9,244 total)