Viewing 15 posts - 6,811 through 6,825 (of 9,241 total)
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
check which TCP protocols you have bound to the NICs, you will need IPV4
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 15, 2011 at 2:15 pm
Just bring one node up at a time if you have both up remove the passive node from the possible owners list on the cluster resources.
Are you assigning new...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 15, 2011 at 11:48 am
😀
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 15, 2011 at 11:42 am
Viewing 15 posts - 6,811 through 6,825 (of 9,241 total)