Viewing 15 posts - 6,826 through 6,840 (of 9,253 total)
I would swap to a Majority Node Set quorum and remove the disk drive dependency to allow the cluster to start
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...
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) /...
August 16, 2011 at 4:16 am
jprovines (8/15/2011)
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
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...
August 15, 2011 at 2:58 pm
check which TCP protocols you have bound to the NICs, you will need IPV4
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...
August 15, 2011 at 11:48 am
Markus (8/11/2011)
Using SQL install evict the passive node.
Why do you think this is necessary?
August 15, 2011 at 11:23 am
Roy Ernest (8/15/2011)
Are you talking about LiteSpeed from Idera?
Don't you mean Quest? 😉
August 15, 2011 at 11:16 am
if you have a tool such as Redgate SQLBackup or Quest Litespeed these tools can generate the schema and data insert scripts for you.
August 15, 2011 at 11:15 am
jprovines (8/15/2011)
backup_source_directory\\lap8db03\TransactionLogBackupbackup_destination_directory\\lap8ea03\TransactionLogShippingTemp
file_retention_period2880
initially everything seems ok, this value
file_retention_period2880
will apply to this
backup_destination_directory\\lap8ea03\TransactionLogShippingTemp
and not this
backup_source_directory\\lap8db03\TransactionLogBackup
The secondary server should never delete files from the source backup direrctory as there could be more than one...
August 15, 2011 at 10:44 am
Hi
please execute the following against your Log shipping primary server and post the results back
use master
exec sp_help_log_shipping_primary_database @database = 'yourdbname'
August 15, 2011 at 6:53 am
what you should be doing is to build yourself a dataset that would mimic your live data and use this database for development and possibly even testing. This allows dev...
August 15, 2011 at 6:39 am
Viewing 15 posts - 6,826 through 6,840 (of 9,253 total)