Viewing 15 posts - 6,826 through 6,840 (of 9,244 total)
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
Markus (8/11/2011)
Using SQL install evict the passive node.
Why do you think this is necessary?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 15, 2011 at 11:23 am
Roy Ernest (8/15/2011)
Are you talking about LiteSpeed from Idera?
Don't you mean Quest? 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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'
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 15, 2011 at 6:39 am
All
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 15, 2011 at 6:27 am
please supply more info on the server setups such as windows os version, number of cluster nodes and any NIC assignments
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 15, 2011 at 4:00 am
it's probably easier to stop the log shipping and remove the secondary database. Sort out the disk space and file locations and then re initialise the secondary database
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 14, 2011 at 8:15 am
what events do you see in the application event log when trying to start the agent service normally
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 14, 2011 at 7:44 am
mazzz
i'm not clear, are you adding a node to an existing clustered instance or creating a new clustered instance?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 14, 2011 at 6:38 am
chris.mcgowan (8/12/2011)
To make the secondary log shipping instance 'online' and accesible you need to restore a transaction log with recovery.
you do not need to specifically restore a transaction log,...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 14, 2011 at 6:23 am
Viewing 15 posts - 6,826 through 6,840 (of 9,244 total)